How to write numeric literals in oracle?
What is index-organized table in Oracle?
What do you understand by database schema and what does it hold?
what are the advantages of running a database in archive log mode?
How to define a data field as not null?
How to find no of saturdays in a month using single sql ?
How remove data files before opening a database?
What is forall Statement ?
how do u setup a replication site?
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 create a new database in oracle?
when i run my query on yesterday it is fast but today it is slow why?
ABOUT IDENTITY?