What are the commands youd issue to show the explain plan
for select
Answer Posted / venkateswararao
from dual?
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Describe an oracle table?
How to generate query output in html format?
How to create a table index?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is the difference between substr & instr functions?
What happens if the imported table already exists?
Hi Can any one tell me what are the API's used in requisition import.
what is port in oracle? how is it related to database application.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Can multiple cursors being opened at the same time?
What is a connect identifier?
What is the difference between truncate & delete command?
How to load excel data sheet to oracle database
What happens to indexes if you drop a table?
Why cursor variables are easier to use than cursors?