Hi All
I would like to know the difference between using the Stored procedures in
DB Triggers and writing the code directly in the DB Trigger. Which would be
better to use and what r the advantages.
Rgds
Sathya
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET:
Try this out. thisqry is working well for hrs and mins. hop u modify this
qry get for hrs also
wishes
select
(((sysdate-startup_time)*60*24-mod((sysdate-startup_time)*60*24,60))/60)HRS
,
round(mod((sysdate-startup_time)*60*24,60))MIN from v$instance
Wishes
Sathyanarayanan
|+--
If ur upgrading from nt 5 to 2000 then he first opt should work. Just
install oracle on w2000 and start up the db coz the services are n nt. but
if ur goin in for a fresh install of w2000, it is better to create a fresh
db and import.
Alternatively u can create a db with the same config of existig
check out the status in v$sess
Regards,
Sathyanarayanan
|+--->
|| "Sergei" |
|||
|| |
|| 27/11/2002 |
|| 00:24|
|| Please |
Just check for the Oracle services in Control Panel-> Services.
ur Instance,TNS should be started. if not start these services and try
connecting.
Regards,
Sathyanarayanan
|+--->
|| john |
|| |
||
Thank u list for ur imm resp. It was the prob with numwidth.
Now I have set the num width to 25 and s working fine.
But whenever i stat the sql the default is set to 9. how do i change the
def numwidth??
Regards,
Sathyanarayanan
|+--->
|| "Arup Nand
some rights has to granted to the user n for setting up the repository u
may need to modify ur register entry for the mgmt svr. check out the
installation notes to the set the values of key in the registry.
Regards,
Sathyanarayanan
|+>
|| "Mike
Dear List
Have a look at the sql !!!
SQL> create table trnid
2 ( trn_id number(10));
Table created.
SQL> insert into trnid(trn_id) values('11');/* 10 1's inserted*/
1 row created.
SQL> insert into trnid(trn_id) values('1');/* 9 1's inserted*/
1 row created.
SQL> commit;
Comm