What is the relation of a user account and a schema in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
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 define a sub function?
How to put more than 1000 values into an oracle in clause?
How to execute the package in oracle?
how to find out second largest value in the table
What are ddl statements in oracle?
What are the different types of record groups in oracle? Explain each of them
what is difference between where clause and having clause?
How do you handle duplicate records in a database?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
How to use in conditions in oracle?