Answer Posted / jyoti ranjan samal
Store procedure can invoke DDL&DML statement and can return
value.
2.You can also execute one procedure to another procedure.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to view the data files in the current database?
Why does for update in oracle 8 cause an ora-01002 error?
How to define an external table with a text file?
What is a server parameter file in oracle?
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?
Explain coalesce function?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Describe the types of sub query?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is the recommended interval at which to run statspack snapshots, and why?
What is merge statement used for?
Why do we use coalesce function in oracle?
What are the types of trigger in oracle?
what are bitmap indexes? How does they work?
What privilege is needed for a user to connect to oracle server?