Why cannot I use bind variables in ddl/scl statements in dynamic sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

how can i read files from a pl/sq l program

3 Answers  


How to call the function and Procedure in trigger?

3 Answers   IBM,


Is sqlite free?

0 Answers  


i have a customer table. 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_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  


Is primary key clustered index?

0 Answers  






Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  


what does myisamchk do? : Sql dba

0 Answers  


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,


How will you select unique values from a list of records?

7 Answers   Cap Gemini,


What is the use of stored procedures?

0 Answers  


What is exit statement?

0 Answers  


What is a subquery in sql?

0 Answers  


Categories