What is meant by an index?
No Answer is Posted For this Question
Be the First to Post Answer
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 to pass parameters to procedures in oracle?
What is a package in oracle?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
In the oracle version 9.3.0.5.0, what does each number shows?
How will you identify oracle database software release?
How a tablespace is related to data files?
what is the syntax of INSERT command?
What is the data type of dual table?
What is an oracle table?
what is the difference between data migration and production migration.
Why do we use coalesce function in oracle?