What are the differences between blob and clob in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
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
What is a static data dictionary in oracle?
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 find out from the RMAN catalog if a particular archive log has been backed-up?
Define Normalization with example?
Describe Referential Integrity ?
How to update values in a table in oracle?
what are views?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
What are the uses of Rollback Segment ?
What privilege is needed for a user to connect to oracle server?