|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions How do I find out the time taken by oracle to execute the sql statement or a procedure? Is it possible by firing a select? Hi, Here we are using Reports 6i, how to get report output format in ppt or doc,is there direct print option instead of generating it into pdf or rtf.pls let me know and give me the proper example View Question | Asked by : jayaram Latest Answer : SELECT TEXT FROM USER_SOURCE WHERE NAME='PROCEDURE/FUNCTION/PACKAGE/PACKAGEBODY'/ ... Read Answers (2) | Asked by : vid We are facing one problem one of session is aborting after updating 2~3 lakhs records which is taking around 1hr and still there are 2lakhs to update. we are running again this starts updating from scratch of the reocrd.If i use enable recovery option will the record updates from the 200001 or from 1st reocrd and will i save the time by using this option? Read Answers (1) | Asked by : Rajkumar bachu Latest Answer : 1. cold backup2. hot backup3. import/export4. RMANRead oracle manual ... Read Answers (1) | Asked by : RENGANATHAN.R How do you decide on whether to use a Procedure or a Function for a particular task ?Is it possible to get the last 10 rows of a table? If Yes How? What will happen if you dont use Replace option in a Procedure when first creating it for first time? Latest Answer : No problm. It successfully creates the procedure.But once it created ,if u modify it and compail without REPLACE ,it will give an error ... How to take a Table Name as Parameter in Procedure? How to call a procedure in SQL*Loader? How to debug stored procedure in Oracle?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
