What are few of the schema objects that are created using PL/SQL?
No Answer is Posted For this Question
Be the First to Post Answer
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
Advantages and disadvantages of stored procedure?
What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?
How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?
What are different types of statements supported by sql?
What is a record in a database?
why we use nocopy?
query to retrive the employees whose sal is greater than avg sal
What is sql and its types?
What are the subsets of sql?
Which query operators in sql is used for pattern matching?
what is text? : Sql dba