what are Dynamic SQL statements?




Answers were Sorted based on User's Feedback



what are Dynamic SQL statements?..

Answer / tharanath.n

A SQL statement is dynamic if it is constructed
at runtime and then executed.
we can use ddl commands by dynamic sql, without we can't
use.

Is This Answer Correct ?    14 Yes 1 No

what are Dynamic SQL statements?..

Answer / soujanya

A SQL statement is dynamic if it is constructed
at runtime and then executed.

Is This Answer Correct ?    8 Yes 1 No

what are Dynamic SQL statements?..

Answer / srikanth

EXECUTE IMMEDIATE

Is This Answer Correct ?    8 Yes 1 No




what are Dynamic SQL statements?..

Answer / naresh

Basically Dynamic SQL means, you'll construct a SQL
statement dynamically while runtime and run it.

Why this needed: Since the stored database objects
(Procedures and Functions and others) will be compiled while
creating and stored inside a database.so everything has been
checked already. so whenever you make a call to these
programs they will directly run withou compiling second time.
since it runs without compiling you cannot use DDL commands
inside a stored program.

So to avoid this you can directly mention Execute Immediate
keywords in front of a SQL query dynamically in your
block.so that it'll work this time.

Hope this helps.

Is This Answer Correct ?    2 Yes 0 No

what are Dynamic SQL statements?..

Answer / brahmam

-> the combination of Sql and Plsql is called dynamic Sql.
when ever sql statements executed runtime then we are using
Execute immediate clause in executable section of the plsql block.

Is This Answer Correct ?    1 Yes 0 No

what are Dynamic SQL statements?..

Answer / thanvi

Both compilation and execution happens at the time.It will be useful where we don't know (the value of col_name or table_name) till runtime.
-Compilation means checks for the syntax.

Is This Answer Correct ?    0 Yes 0 No

what are Dynamic SQL statements?..

Answer / tharanath.n

A SQL statement is dynamic if it is constructed
at runtime and then executed.
we can use ddl commands by dynamic sql, without we can't
use.

Is This Answer Correct ?    0 Yes 1 No

what are Dynamic SQL statements?..

Answer / vishal kumar

Sql statement should be written in quotes like

'select table1.col1, tabel2.col2 from table1,table2 where
table1.col3=table2.col4'
and we can execute through below command "execute immidiate"
EXECUTE IMMEDIATE 'select table1.col1, tabel2.col2 from
table1,table2 where table1.col3=table2.col4'

it execute at runtime, means its not allowed as static.

Is This Answer Correct ?    0 Yes 2 No

what are Dynamic SQL statements?..

Answer / manoj

It take value dynamicaly at run time

Need:- If we need DDL in programming as "CREATE, INSERT"

.. It always written in single
quote " 'sql_statement ' " both end
with termination " ; "

Is This Answer Correct ?    0 Yes 5 No

Post New Answer



More SQL PLSQL Interview Questions

what is meant by databases

4 Answers  


Table1: Col1 col2 1 2 10 3 4 89 5 6 Table:2 Col1 col2 3 2 9 5 4 7 6 87 With the help of table1 and table2 write a query to simulate the fallowing results. Output1: Col1 col2 1 2 2 3 3 4 4 5 5 6 Output2: Col1 col2 2 3 10 4 5 89 6 7 1.Write query for single row to multiple row using sql statements. Eg:a,b,c,d,e,f Change to A B C D E F 2. Write query for multiple row to single row using sql statements. Eg2 A B C D E F Change to Eg:a,b,c,d,e,f Table1: Col1 col2 8 5 2 9 4 2 5 1.Write a query to select all the rows from a table1,if the value of A is null then corresponding B’s value should be printed in A’s value.if the value of A is null in that table then corresponding B’s value should be printed as 30. 2. write a query to find the sum of A and B .display the max among both. 3.write a query to find total number of rows from table 1. Note: if any column value is null in a row then that row should be considered as 2 rows. 4.write a query to display all the records of table1 except A containg 2 as well B containg 5. 5.rewrite the fallowing without using join and group by. Select b.title,max(bc.returneddate –bc.checkoutdate)” mostdaysout” From bookshelf_checkout bc, Book shelf B Where bc.title(+)=b.title Group by b.title. 6.rewrite fallowing query Select id_category from category_master X where exists (select 1 from sub_category Y where X.id_category=Y.id_category) Customer: Name phone1 phone2 phone3 bitwise A 23456 67890 12345 --- B 67459 89760 37689 --- Don’t_call Col1 67890 37689 1.q) update the customer table of bitwise with 1 or 0. Exists in don’t_call table menas show -1 Other wise -0. Output. Name bitwise A 010 B 010

0 Answers   Protech,


How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,


While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,


how many no of table can be join in a sql query.

4 Answers  






declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,


what is the difference between implicit conversions and explicit conversions?

2 Answers  


i want to display 1 to 10 numbers using one select statement.

18 Answers   Oracle, Nyros, HCL,


What is Overloading of procedures ?

4 Answers   Amdocs,


What is a transaction?

5 Answers  


how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,


How you will create Toad Function?

1 Answers  






Categories