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 an oracle wallet?
How to change system global area (sga) in oracle?
How to view the data files in the current database?
when do u go for hash partitioning?
what is normalisation?what are its uses?
What is varray?
Whether any commands are used for months calculation? If so, what are they?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
How to export several tables together?
Explain about integrity constraint?
What are the attributes of cursor?