We are using Developer 2000(Forms/Reports 6) as well as Oracle database packages in our application.
We need a source code control package that will handle this environment.
PVCS, RCS and CVS claim to handle Oracle but I don't have time to do an evaluation.
I would like some real life...
Your select looks fine as far as it goes. I would change your date conversion format to 'mm/dd/rr' or 'mm/dd/yyyy' to be on the safe side for y2k purposes.
You need to bear in mind that a function returns a single value, however. They are useful in returning, for example, totals that require...
In order to give other users access to an Oracle table or other object such as a sequence, package or view, you need to do the following:
1) Determine who owns the table:
select * from sys.dba_tables where table_name = 'your table name here';
2) login to SQLPlus or the tool you used to create...
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.