What is set operator oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What does a Control file Contain ?
What is an anonymous block?
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
What is the difference between $oracle_base and $oracle_home?
How to write text literals in oracle?
What is Hash Cluster ?
structural difference between bitmap and btree index ?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
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 to delete an existing row from a table in oracle?
What is an oracle wallet?
What are temporal data types in oracle?