Forum: Oracle  Aug 23rd, 2007 |
| Replies: 1 Views: 5,858 Re: How to create script of a user/role
Every transaction you do in toad, you can see a scripr for it..
while if you are looking to create your own script this you need to be clearer.
The Export utility can create a dump file for a full... |
| Forum: Oracle Aug 23rd, 2007 |
| Replies: 5 Views: 2,827 Re: Question
I prefare the Red and green color...
SELECT INITCAP(lastname), INITCAP(firstname),
NVL(TO_CHAR(referred),TO_CHAR(0009999)) FROM customers |
| Forum: Oracle Aug 23rd, 2007 |
| Replies: 2 Views: 1,329 |
| Forum: Oracle Aug 23rd, 2007 |
| Replies: 4 Views: 2,408 Re: deleting the tables
You have two options:
---------------------------------------
1) Create a script
set lines 200;
set pages 10000;
spool c:\DROP_TABLES.txt;
select 'DROP TABLE '||table_name||';'
from all_tables
... |
| Forum: Oracle Aug 23rd, 2007 |
| Replies: 6 Views: 9,203 Re: Change date format
The Alter session is a temporary solution, that makes your session only appears with the format specified..
If you want to create a report or a query or a script that always appear with a specific... |
| Forum: Oracle Aug 23rd, 2007 |
| Replies: 3 Views: 2,066 Re: Urgent HELP ME --- i am new to ORACLE
--------------------------------------------------
Assume :
table_name1 is a table with a,b,c are fields in it.
table_name2 is a table with l,m,n are fields in it.
proc_name insert from... |
