Musta

How do i change date format in the database

:?: how to delete all the tables in the a user at a time?

Hi. In Toad, I can select a user/role, right click, and select "Create script", and it creates a SQL script of the user/role definition. I find this handy if I only want the user/role definition and not want to export/import any data. Does anyone know how to obtain/create/export a user/role …

I have a school problem, I'm not going to try and hide it. This is for Oracle9i: [URL="http://www.daniweb.com/techtalkforums/thread70629.html#"]SQL[/URL] class. The question we have to write a code for is: Create a list of customers that will display the characters 'NOT REFERRED' if the customer was not referred by another customer. …

I'm not entirely sure If this is going in the correct location. What I want is to set up my database so that it will updated every hour. I'm a little unsure on how to tackle this problem. Does oracle actually support this type of updating, and if not, would …

i have to call a stored procedure that shoud return all data in a table. so how to create procedure and how to return data from procedure. kindly send me a small example program .........