Can the default values be assigned to actual parameters?
What is transport network substrate (tns) in oracle?
What are the advantages of Views ?
How do I spool to a csv formatted file using sqlplus?
What are inner join and outer join?
what are pseudocolumns?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
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 do you store pictures in a database?
WHAT IS ecc 6.0
How to change user password in oracle?
How to delete a column in an existing table?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.