1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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.

Question Posted / swathi

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

Post New Answer

More SQL PLSQL Interview Questions

How do you delete duplicates in sql query using rowid?

0 Answers  

What is pl sql commands?

0 Answers  

List the ways to get the count of records in a table?

0 Answers  

What is data types in sql?

0 Answers  

what is hash join

1 Answers   NCR,




What is different between union and minus?

7 Answers   Accenture, TCS,

How do I edit a stored procedure?

0 Answers  

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

Is pl sql better than sql?

0 Answers  

Why indexing is needed?

0 Answers  

What does over partition by mean in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories