How to view the data files in the current database?
No Answer is Posted For this Question
Be the First to Post Answer
What is the dynamic sql 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.
What is oracle host variable?
What are group functions in oracle?
Describe the different type of Integrity Constraints supported by ORACLE ?
How to write numeric literals in oracle?
Is oracle the best database?
Differnce between view and index
What is the difference between RBBMS & DBMS?
Does oracle charge for java?
What is a SNAPSHOT ?
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID