how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What are the types of partitions in oracle?
Explain oracle left join with an example?
Where are the settings stored for each instance in oracle?
How to pass parameters to procedures in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
List the parts of a database trigger.
What are the tools for Oracle ?
What is an anonymous block?
How to change program global area (pga) in oracle?
What are the most common interview questions on ETL Testing for experience?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the difference between substr & instr functions?
Give the constructs of a package, function or a procedure.
How to estimate disk space needed for an export job?