How to create a stored function in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Give the advantages and disadvantages of clusters.
What is max rowid in oracle?
what is candidate key & super key
What is the use of oracle?
How does the on-delete-cascade statement work?
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?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
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 is a package ? What are the advantages of package ?
What are the major difference between truncate and delete?
How to use like conditions in oracle?