In access or sql server, you can use autonumber which is automatically generated as soon as an insert statement is invoked.
Does anyone know how I can use this in oracle without the benefit of a stored procedure?
For instance, I need to have a sequence number which not only assigns numbers but...
Hi all!
I have a table let's say emp table,
a field on the emp table called ename and a hiredate.
The ename is varchar2, and hiredate is date.
I want to know how long an employee has worked for a company.
I need my output to read:
Ename Years Months
Jeff 16 1 etc.
Can you...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.