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.


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

Post New Answer

More SQL PLSQL Interview Questions

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..

8 Answers  


What is int identity in sql?

0 Answers  


What is basic structure of pl sql?

0 Answers  


What is sqlcontext?

0 Answers  


What is the need of a partition key?

0 Answers  






What is the result, when NULL is compared with NULL?

22 Answers   TCS,


which tcp/ip port does sql server run on? : Sql dba

0 Answers  


in procedure how to return a value

3 Answers   Wipro,


How do I run sql?

0 Answers  


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.

14 Answers   iGate, Wipro,


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  


How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,


Categories