How would you go about generating an EXPLAIN plan?
Answer / gogune
Thr'u command
explain plan for <select statement>
| Is This Answer Correct ? | 0 Yes | 1 No |
In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
How client makes connection with server in client/server architecture?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
what is diff between pre insert,on insert,post insert triggers?
Give two methods you could use to determine what DDL changes have been made.
which one is currently in used software cmpanies.
How many segment are present in Oracle Manufacturing
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
What is the difference between the SQL*Loader and IMPORT utilities?
What view would you use to determine free space in a tablespace?
What is index? How many types of indexes?
please explain about oracle