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
What is meant by a deadlock situation?
What are the tools for Oracle ?
Without giving condition how to retrieve the unmatched records from table.
sql command 2 know current database
Hi Can any one tell me what are the API's used in requisition import.
what is primary key and foreign key when and where have to use
What are named parameters?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to sort output in descending order in oracle?
what is shell?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
Explain about integrity constraint?