Why do you create or replace procedures rather that drop and recreate.
- 0 Answers
- 545 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is oracle latest version?
What is ordinary table in oracle?
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 ?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
what is the difference between substr and instr function in oracle?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
How to view existing locks on the database?
List out the types of joins.
what is a view?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is oracle sid?
Oracle General 
