Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks
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?
Latest Answer : SELECT TEXT FROM USER_SOURCE WHERE NAME='PROCEDURE/FUNCTION/PACKAGE/PACKAGEBODY'/ ...
Latest Answer : 1. cold backup2. hot backup3. import/export4. RMANRead oracle manual ...
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?
Is there any way to import the excel data in to oracle database without using the SQL loader, please let me know.
Latest Answer : Well,if you have less data ,you can just copy the data; for exampleselect * from table for update then open the lock, then copy the data from excel to the database; ...
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?