What is sql query optimization?
No Answer is Posted For this Question
Be the First to Post Answer
How toimport .dmp file in lower version of oracle from higher version ?
Does sql*plus have a pl/sql engine?
What is sp_helptext?
What is server name sql?
How to get help at the sql prompt?
How many types of triggers exist in pl/sql?
What is forward declaration in pl sql?
Write the command to remove all players named sachin from the players table.
what is global table
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.
What are the subsets of sql?
What is field delimiter?