ok i will use pre-insert trigger,
but problem is same
i don't want gap between ids.
if one entery is deleted, sequence will not check
missing value, it will generated new unique number.
Search found 56 matches
- Mon Jun 12, 2006 1:53 am
- Forum: Oracle Forms & Reports
- Topic: auto generated primary key
- Replies: 4
- Views: 3502
- Sun Jun 11, 2006 3:54 am
- Forum: Oracle Forms & Reports
- Topic: auto generated primary key
- Replies: 4
- Views: 3502
auto generated primary key
Trigger : when create recorde. select Max(id)+1 int :table1.ID from table1; i am having problem when more than one user are using same form. If i use sequence no then, there are chances of having gap between primary key no like 1,2,3,5,7,20 etc. because if sequence generated id lost ,it can not be g...
- Fri Jun 09, 2006 10:12 am
- Forum: Oracle Forms & Reports
- Topic: HELP REQUIRED IN QUERY
- Replies: 6
- Views: 3411
- Fri Jun 09, 2006 6:41 am
- Forum: Oracle Forms & Reports
- Topic: HELP REQUIRED IN QUERY
- Replies: 6
- Views: 3411
HELP REQUIRED IN QUERY
SELECT EMAIL FROM EMPLOYEE; SQL> email ------------------------------------- atif@abc.com altaf@yahoo.com nasir@abc.com najam@hotmail.com Can i get result in this form SQL> email ------------------------------------- atif@abc.com,altaf@yahoo.com,nasir@abc.com,najam@hotmail.com
- Thu Jun 08, 2006 2:31 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Apps Material for the beginners.
- Replies: 8
- Views: 4833
- Wed Jun 07, 2006 3:57 am
- Forum: Oracle Databases
- Topic: how to export oracle schema into access
- Replies: 1
- Views: 1572
how to export oracle schema into access
supose i want to see scott schema in access with data
so how can i export into access.
thanks
so how can i export into access.
thanks
- Tue Jun 06, 2006 4:30 am
- Forum: Suggestions
- Topic: category option
- Replies: 1
- Views: 1256
category option
AOA
this is excellent forum
can u include category option, like bignner ,experience, advanced
for every question or answer, catagory should be mention.
this is excellent forum
can u include category option, like bignner ,experience, advanced
for every question or answer, catagory should be mention.
job info
i need some info about these job.
who much exp person do u requiered
can u tell me the rang of salary
like 20,000 to 30,000
or 30,000 to 40,000
etc
who much exp person do u requiered
can u tell me the rang of salary
like 20,000 to 30,000
or 30,000 to 40,000
etc
- Mon Jun 05, 2006 2:21 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: flexfield
- Replies: 2
- Views: 2946
flexfield
who many type of flexfield exit in oracle apps
- Sun May 28, 2006 2:03 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Oracle apps GL books/tutorial .pdf required
- Replies: 0
- Views: 3673
Oracle apps GL books/tutorial .pdf required
Oracle apps GL books/tutorial .pdf required
- Thu May 18, 2006 2:43 am
- Forum: Oracle Forms & Reports
- Topic: How to run report from form in form9iDS
- Replies: 2
- Views: 2064
How to run report from form in form9iDS
1-How to run report from form in form9iDS
2-From which site I can get max oracle pdf books
3-how to learn oracle apps(finacial) on cheap cast
2-From which site I can get max oracle pdf books
3-how to learn oracle apps(finacial) on cheap cast