What is composite data type in pl sql?
i want run a sql query query? which phases are run in a back ground? pls tell me the answer
What is error ora-01000: maximum open cursors exceeded
what is a foreign key ? : Sql dba
What is sql scripting?
What found sql?
what are the demerits of sql?
What is a mutating table and a constraining table?
What is mdf ldf and ndf?
What is the use of index in hive?
What is the purpose of a sql?
i have a customer 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_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent
Can there be more than one function with a similar name in a pl/sql block?