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.

0 Answers  

---

What is index example?

0 Answers  

---

How many tables can you join in sql?

0 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

What are the different dcl commands in sql?

0 Answers  

---

How do you select unique values in sql?

0 Answers  

---

What will you get by the cursor attribute sql%rowcount?

0 Answers  

---

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

---

What kind of join is join?

0 Answers  

---

what is view? : Sql dba

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

What is mdf ldf and ndf?

0 Answers  

---