What is Difference between StoredProcedure and function?
Answer Posted / shankar
FUNCTION always return a value where as PROCEDURE may or
may not return value.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do I start pl sql?
How do I find duplicates in two columns?
What is difference between sql and excel?
How to select unique records from a table?
What do you understand by case manipulation functions?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Which one is faster ienumerable or iqueryable?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is error ora-01000: maximum open cursors exceeded
What is sql and its types?
What are different joins used in sql?
Is not null in sql?
Difference between global and parameter variables?
What is sqlca in db2?