| Recent Answers |
 |
|
2008-07-03 Oracle - Performance of a Stored Procedure: Hi Binay, 1) You can check performance of the stored procedure by either of the 2 ways - - SQL_TRACE and TKPROF Info at http://download-east.oracle.com/docs/cd/A81042_01/DOC/server.816/a76992/ch14_str...
|
2008-07-03 Oracle - Index: Hi Binay, 1) You can check the query execution using EXPLAIN PLAN. More info at following site - http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96533/ex_plan.htm 2) You can change...
|
2008-07-02 Oracle - Oracle IMP utility: Good day Pankaj In order for you to perform the import, you will have to set the ORACLE_SID parameter to the database that you want to import the dump file. The syntax to do that is as follows...
|
2008-07-02 Oracle - SQL Loader: Hi Kavitha, The Filler option is used only when there is a column in the table, but no corresponding column in the data file. In your case it is exactly opposite. So you cannot use this. One alternative...
|
2008-07-01 Oracle - describe all tables in database: There is not a thing such that. What you can do is to make a script: SET HEAD OFF SPOOL D:\SCRIPTA.SQL select 'PROMPT ' || A.TABLE_NAME || CHR(13) || 'DESC ' || A.TABLE_NAME SCRIPT from cat...
|