Can %notfound return null after a fetch?


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

Post New Answer

More SQL PLSQL Interview Questions

What are the different types of triggers?

0 Answers  


What is primary key in db?

0 Answers  


What is meant by <> in sql?

0 Answers  


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.

2 Answers   Oracle,


what are date and time data types? : Sql dba

0 Answers  






I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  


what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,


how to connect oracle in unix prompt?

4 Answers   Polaris,


Do stored procedures prevent sql injection?

0 Answers  


What is error ora-01000: maximum open cursors exceeded

0 Answers  


Is sql considered coding?

0 Answers  


Can you skip header records while loading? : aql loader

0 Answers  


Categories