Table Scripts [message #1208] |
Thu, 11 April 2002 06:44 |
AbySmith
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
Hi,
I maintain a batch file to create all tables in my database.
However when i run the file at some places table creation may fail. From the spool file or the screen output i am unable to decide which table's create failed.
I would like to insert an message before every create for e.g. "Creating Table 1" to solve the above problem.
On Unix Systems, i have seen the usage of
!echo "Creating Table 1".
However on Windows platforms it does not work.
I have tried dbms.output.put_line with negative results.
Can anybody suggest a better alternative.
Rgds,
Aby
|
|
|
Re: Table Scripts [message #1209 is a reply to message #1208] |
Thu, 11 April 2002 07:30 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
in windows u can use @echo or from ur sql script u can use prompt.
----------
C:>a.bat
createing table 1
createng table 2
------------------
a. bat contains
C:>type a.bat
----------------
@echo createing table 1
@echo createng table 2
-----------------
or in sql script use
-------------
prompt Sample script
prompt creating table q
create table q
(id number);
prompt create table m
create table m
(id numbers);
prompt create table n ....
prompt create table p
---------------------
|
|
|