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 a dynamic performance view in oracle?
How to revoke create session privilege from a user in oracle?
"primary key=unique+null" is equal,reson?not,reason?
What is a directory object?
How are Indexes Update ?
What is the relation of a user account and a schema in oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
How many types of database triggers exist?
Define oracle database
difference between truncate and delete ,drop?
How to see the table columns used in an index?
how do u setup a replication site?