How many objectname will be created for a single table drop
function? Why 'flashback' query giving error "ORA-38312:
original name is used by an existing object" while getting
the table?
No Answer is Posted For this Question
Be the First to Post Answer
how to retrieve 1st and last row of table without using group functions??
How to connect to a remote server?
How to handle a single quote in oracle sql?
difference between bind variable and variable
What is oracle host variable?
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.
Can a Tablespace hold objects from different Schemes ?
How to rename an existing table?
Can group functions be mixed with non-group selection fields?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to call a stored function in oracle?
Can I create users through internet explorer in oracle 10g?