Hi friends,
Is there a way to avoid typing @ for the execution of every sql script in the database. Maybe playing around with the login.sql or something.
I am bored of typing shift+@ every execution of running any of my scripts(i have nearly 3000 scripts) :(. May sound like a request from a lazy guy , but still can anyone please suggest some solution.??
like instead of
14:12:04 sa@TESTDB> @active
Client last
SID SER# LOGON_AT USERNAME OSUSER MACHINE PID MODULE PROGRAM SQL_ID call et
------ ------ --------------- ---------- ---------- ------------ -------- -------------------- ---------- ------------- -------------
225 1 17-jun 07:00 oracle tkxti019 4543 oracle@tkxt 55h 11m 43s
224 1 17-jun 07:00 oracle tkxti019 4651 oracle@tkxt 55h 11m 43s
223 1 17-jun 07:00 oracle tkxti019 4708 oracle@tkxt 55h 11m 43s
something like below is needed
14:12:05 sa@TESTDB> active
Client last
SID SER# LOGON_AT USERNAME OSUSER MACHINE PID MODULE PROGRAM SQL_ID call et
------ ------ --------------- ---------- ---------- ------------ -------- -------------------- ---------- ------------- -------------
225 1 17-jun 07:00 oracle tkxti019 4543 oracle@tkxt 55h 11m 43s
224 1 17-jun 07:00 oracle tkxti019 4651 oracle@tkxt 55h 11m 43s
223 1 17-jun 07:00 oracle tkxti019 4708 oracle@tkxt 55h 11m 43s
Thanks,
Kunwar