Musta

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 format then go with TO_CHAR()

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 where owner = 'SCOTT'; -- change the SCOTT to the owner of the tables you need to drop. spool off; --------------------------------------- @c:\DROP_TABLES.txt; -- to run the script …

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 schema, as in : user, his roles and privileges and …

I prefare the Red and green color... SELECT INITCAP(lastname), INITCAP(firstname), NVL(TO_CHAR(referred),TO_CHAR(0009999)) FROM customers

Can you be clearer in [COLOR="Red"][U][B]"UPDATING"[/B][/U][/COLOR] every hour??!

-------------------------------------------------- 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 table_name1 to table_name2, showing the list. --------------------------------------------------- CREATE OR REPLACE PROCEDURE proc_name AS x number; y varchar2(30); z date; CURSOR c IS SELECT a,b,c …