Is insert autocommit in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How many categories of data types?
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.
Why do you create or replace procedures rather that drop and recreate.
What is an oracle database table?
Write a trigger example in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to grant create session privilege to a user in oracle?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
How to convert character types to numeric types?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
How to import one table back from a dump file?