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?
No Answer is Posted For this Question
Be the First to Post Answer
Explain an index segment?
What is a Redo Log ?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
How to Remove the 3rd highest salary person record from table?
What is Reduced List of Values?
What happens if you lost a data file?
How to empty your oracle recycle bin?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
Why cursor variables are easier to use than cursors?
How can we find out the current date and time in oracle?
What are the differences between interval year to month and interval day to second?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?