Interested to Buy Any Domain ? << Click Here >> for more details...
what are Dynamic SQL statements?
- 9 Answers
- 26705 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 16 Yes | 1 No |
Answer / soujanya
A SQL statement is dynamic if it is constructed
at runtime and then executed.
| Is This Answer Correct ? | 9 Yes | 2 No |
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 ? | 3 Yes | 0 No |
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 ? | 2 Yes | 0 No |
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 |
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 |
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 ? | 1 Yes | 2 No |
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 ? | 1 Yes | 5 No |
How do I debug a stored procedure?
Does sql profiler affect performance?
When would you denormalize?
8 Answers MBT, Microsoft, MMU,
How do I run a query in pl sql developer?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
What is information schema in sql?
What are the uses of merge?
What does select count (*) mean in sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
How do you know if a relationship is 2nf?
what is difference between pass by value and eference by value in oracle plsql
trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
