Interested to Buy Any Domain ? << Click Here >> for more details...
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
- 0 Answers
- 966 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is Index Cluster ?
What is the difference between sharding and replication?
How to convert characters to dates in oracle?
Explain how are indexes update?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is the best way to do multi-row insert in oracle?
Display Odd/ Even number of records?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
How remove data files before opening a database?
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.
Oracle General 
