What is sql query optimization?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,


Does sql*plus have a pl/sql engine?

0 Answers  


What is sp_helptext?

0 Answers  


What is server name sql?

0 Answers  


How to get help at the sql prompt?

0 Answers  






How many types of triggers exist in pl/sql?

0 Answers  


What is forward declaration in pl sql?

0 Answers  


Write the command to remove all players named sachin from the players table.

0 Answers  


what is global table

7 Answers   iFlex,


trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 Answers   Oracle,


What are the subsets of sql?

0 Answers  


What is field delimiter?

0 Answers  


Categories