Difference between inline query and stored procedure?
Answer Posted / jas
Select statement which is part of form clause of any
another statement is called as inline query.
Cannot take parameters.
Not a database object
Procedure:
Can take paramters
Database object
can be used globally if same action needs to be performed.
Is This Answer Correct ? | 27 Yes | 4 No |
Post New Answer View All Answers
Can we use ddl commands in pl sql?
How to write pl sql program in mysql command prompt?
Can we use joins in subquery?
Which nosql database is best?
how to use myisamchk to check or repair myisam tables? : Sql dba
What is the difference between nvl function, ifnull function, and isnull function?
What is mutating table error?
What is normalization sql?
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
Explain ddl statements in pl/sql?
how to show all tables with 'mysql'? : Sql dba
List different type of expressions with the example.
what are the differences between binary and varbinary? : Sql dba
How do I add a primary key to a table?
What does select * from mean in sql?