What is the different between Stored Procedure and Procedure?
Answer Posted / k.deepthi
Yes,Store Procedure/Procedure are one and the same.We have
to Create Procedure and Compile it in Data base,once
compiled it will be stored and we can use the same when
ever required in various other Procedures.
Procedure Usually used to perform set of actions based on
conditions.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is asqueryable?
How many types of indexes are there in sql?
What is a temp table?
what is a constraint? : Sql dba
Why do we need cursors in pl sql?
What are packages in pl sql and also explain its advantages?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How can you load microsoft excel data into oracle? : aql loader
Is left join inner or outer?
What are the types pl/sql code blocks?
Are there any features that are decommissioned in 11g that are not present in 11g?
What are the types of records?
Can a key be both primary and foreign?
define sql update statement ? : Sql dba
What do you mean by stored procedures? How do we use it?