Why do you use stored procedures and state some of its disadvantages?
No Answer is Posted For this Question
Be the First to Post Answer
How can I get column names from a table in oracle?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
How to estimate disk space needed for an export job?
What is Database Trigger ?
What is connection pooling in oracle?
what is the difference between first normal form & second normal form?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What is an Index ?
How to execute a stored program unit?
What is cluster Key ?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?