Give the constructs of a package, function or a procedure.
No Answer is Posted For this Question
Be the First to Post Answer
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to drop an index?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What is oracle database 10g express edition?
what r tyhe major differences between oracle 9i & 10g?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What is an oracle database table?
What is dynamic proxy?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.