sql is not a named block, it can be stored as sql file outside the database

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

Question Posted / karthik murugan

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to revise and re-run the last sql command?

1163

What is the use of pl/sql table?

1067

Does inner join remove duplicates?

942

Can we use view in stored procedure?

902

What are the dml statements?

1143

What is sql exception?

974

Describe types of sql statements?

1058

What is a unique key?

1056

what are ddl statements in mysql? : Sql dba

1201

What is percent sign in sql?

1283

Is natural join and inner join same?

928

Can %notfound return null after a fetch?

1060

How do you pronounce sql?

1013

What is the location of pre_defined_functions.

1166

Is natural join same as inner join?

943