in oracle 10g sw after compiling procedure how to pass
parameter values ,if we (v_empid out number)how to give
empid after successful compilation program.This site exact
suitable for 10g with respect to question & answer same
format , im trying sql browser & sql command prompt using
exec procedure name & respective parameters.
Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..
What is int identity in sql?
What is basic structure of pl sql?
What is sqlcontext?
What is the need of a partition key?
What is the result, when NULL is compared with NULL?
which tcp/ip port does sql server run on? : Sql dba
in procedure how to return a value
How do I run sql?
i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How to get the 3rd column(i.e all the data along with the column name)in a table?