Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is pivot table in sql?
Does truncate need commit?
What is field delimiter?
Explain about various levels of constraint.
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What are all the different normalization?
Can we have two clustered index on a table?
Can a foreign key be null?
Does access use sql?
Can we connect to postgresql using sql developer?
how do you know the version of your mysql server? : Sql dba
What is the difference between pl and sql?
What is cte?
What is delete command in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
