Anuj Singh Oracle DBA
Thursday, 20 October 2011
Oracle monitor user
›
@monitor_user.sql column name form a60 column sid form 999 column serial# form 999999 Heading "Serial" column logon_time format a1...
Wednesday, 19 October 2011
Oracle sqlplus TTitle date
›
How to print date on sqlplus report ? print date in report COLUMN report_date_col NEW_VALUE report_date col report_date_col noprint SELECT ...
Tuesday, 18 October 2011
Oracle Schema comment report
›
Oracle comment report Oracle comment set serveroutput on size 1000000 spool docdb.txt DECLARE l_unixdb_owner VARCHAR2(20) := UPPER('...
Oracle Object summary on schema
›
Oracle Object summary on schema Oracle Object list user wise Oracle Object summary on schema Object summary on user wise se...
5 comments:
Monday, 17 October 2011
Oracle outstanding alerts
›
Oracle outstanding alerts set linesize 200 set pagesize 1000 set trimout on set trimspool on Set Feedback off set timing ...
Oracle Scheduler info schedule.sql
›
@schedule.sql set pagesize 1000 set trimout on set trimspool on Set Feedback off set timing off set verify off prompt promp...
Oracle REVERSE fuction
›
SQL> select reverse('Anuj Kumar Singh') from dual ; Any Key...; REVERSE('ANUJKUM ---------------- hgniS ramuK junA
‹
›
Home
View web version