Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shailesh
When we want to handle the null value of any column then we
use nvl function.
| Is This Answer Correct ? | 27 Yes | 1 No |
Post New Answer View All Answers
What is trigger and types?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Explian rowid, rownum? What are the psoducolumns we have?
What is a heap in sql?
Is sql better than access?
How does cross join work in sql?
What is clause?
How to run pl/sql statements in sql*plus?
What is the difference between function and procedure in pl/sql?
How do I run a sql query?
Is microsoft sql free?
What is bind variable in pl sql?
Is it possible to update views?
What is difference between ms sql and mysql?
What if we write return in procedure?
