How to use subqueries in the from clause in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
how to find count rows in table without count function?
What is null value in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
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
what is the difference between oracle enterprise edition and oracle express edition?
What are the benefits of ordbms?
How view is different from a table?
What is a lookup table in oracle?
what is the syntax of ALTER command?
how to insert data into partitioned table partition done by Range partition
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 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?