What is system tablespace?
No Answer is Posted For this Question
Be the First to Post Answer
What is raw datatype in oracle?
How to do a full database export?
What is an oracle wallet?
How to define a variable to match a table column data type?
What are ACID properties in databases?
How to set up autotrace for a user account?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
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 any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
what is the difference between rollback & commit? can a foreign key has null value?
What are the numeric comparison operations?