What is procedure and function?


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

Post New Answer

More SQL PLSQL Interview Questions

What are the two types of exceptions in pl/sql?

0 Answers  


What are the two characteristics of a primary key?

0 Answers  


What do you understand by pl/sql packages?

0 Answers  


Why join is faster than subquery?

0 Answers  


what is datawarehouse? : Sql dba

0 Answers  






what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,


how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,


Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,


How do I view tables in sql developer?

0 Answers  


what is error ora-03113: end-of-file on communication channel?

0 Answers  


Is truncate ddl or dml?

0 Answers  


What are different types of joins ?

5 Answers   BirlaSoft,


Categories