What is the difference between IS/AS while creating a procedure ?i.e Create or Replace procedure is/as .....
For example: I have 100's of tables and I need to take the data from database and export as a xml file.
How to write a query or procedure or function to retrieve all the tables from database where the table dont have any data (no rows).
Database has 100 tables and some of the tables dont have any data. I want to pullout those table names from database in Oracle.
Latest Answer: To created flat files, or read flat files in a procedure or function, the built-ins in the UTL_FILE package can be used. ...
Latest Answer: Normally use it as sql%type or sql%rowtype. But if you are using a cursor then use it cursorname%type or cursorname%rowtype. ...
Is there any way (other than recreating the sequence) to set the currVal and nextVal in a sequence to some value different from its actual value?
Latest Answer: By using wrapper class pl sql code can be protected. ...
Latest Answer: You can print the 'sqlcode' as followsException When others thendbms_output.put_line('error code is'||sqlcode)end; ...
In my table "temp" one column contain 1 to 10 range of values in between some numbers are missing. like belowTEMPcolumn112475so in this table i want search missing number from 1 to 10.so output should be 3689.how to get this o/p?
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
