What is the basic difference between a sql and stored procedure ?

What is the basic difference between a sql and stored
procedure ?

Question Posted / shriram

2 Answers
6785 Views
L&T, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the basic difference between a sql and stored procedure ?..

Answer / karthik murugan

sql is not a named block, it can be stored as sql file outside the database, when stored procedures are named block can be stored inside the database.

Is This Answer Correct ?

7 Yes

0 No

What is the basic difference between a sql and stored procedure ?..

Answer / thanjairajan@gmail.com

SQL is a Language. Stored procedure is transact SQL statement.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

How many postgresql users are there, worldwide?

0 Answers

what is difference between pass by value and eference by value in oracle plsql

1 Answers

How to raise user-defined exception with custom sqlerrm ?

0 Answers

What is INSTEAD OF trigger ?

13 Answers Hexaware, TCS,

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

0 Answers

What is a trigger ?

11 Answers Accenture, BirlaSoft,

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

0 Answers

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers

how to select unique records from a table? : Sql dba

0 Answers

What is diff between bulk collect and forall

3 Answers Metric Stream,

Write a query to find the names of users that begin with "um" in sql?

0 Answers

What is a left inner join?

0 Answers

For more SQL PLSQL Interview Questions Click Here