query optmization techniques and quwry
analyser+projects+ppts
No Answer is Posted For this Question
Be the First to Post Answer
How to create a stored procedure in oracle?
How to connect asp pages to oracle servers?
Explain oracle insert into command?
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'));
What is a trigger and what are its types in oracle?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
What is a user role in oracle?
What are temporal data types in oracle?
What is RULE-based approach to optimization ?
What is a OUTER JOIN?
Explain the use of rows option in imp command.
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records