ERPstuff - Oracle EBS Community

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.

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...

i could not make cursor logic for this 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

these are so nice links
thanks alot
can u tell any url from where we
can get oracle GL student guide

supose i want to see scott schema in access with data
so how can i export into access.
thanks

AOA
this is excellent forum
can u include category option, like bignner ,experience, advanced
for every question or answer, catagory should be mention.

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 many type of flexfield exit in oracle apps

Oracle apps GL books/tutorial .pdf required

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