What are privileges and grants?
No Answer is Posted For this Question
Be the First to Post Answer
How to delete a user account in oracle?
What are a cluster and non-cluster index?
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.
if i am using dml statement in function. then i am writing select statement what was the output
What is a Data Dictionary ?
Can a parameter be passed to a cursor?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to assign data of the deleted row to variables?
Difference between inner join vs where ?
What are the different types of synonyms?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
What is bind variable in oracle 11g?