SQL> select COLUMN_NAME,NUM_DISTINCT,DENSITY,NUM_NULLS,LAST_ANALYZED from dba_tab_columns where owner='&owner' and table_name='&tablename' order by 2 desc; Enter value for owner: JACAL Enter value for tablename: EM_E_COMMON old 1: select COLUMN_NAME,NUM_DISTINCT,DENSITY,NUM_NULLS,LAST_ANALYZED from dba_tab_columns where owner='&owner' and table_name='&tablename' order by 2 desc new 1: select COLUMN_NAME,NUM_DISTINCT,DENSITY,NUM_NULLS,LAST_ANALYZED from dba_tab_columns where owner='JACAL' and table_name='EM_E_COMMON' order by 2 desc

SQL> SELECT 0 FROM jacal.em_e_common E, JACAL.EM_E_DLDL WHERE "E"."G3E_FID"=&B1 AND "E"."REF_OID"=0 AND "E"."ISDELETED"=0 AND TO_NUMBER("E"."TYPE_CODE")=2279 AND "E"."OID"="EM_E_DLDL"."OID"; Enter value for b1: 10000 old 1: SELECT 0 FROM jacal.em_e_common E, JACAL.EM_E_DLDL WHERE "E"."G3E_FID"=&B1 AND "E"."REF_OID"=0 AND "E"."ISDELETED"=0 AND TO_NUMBER("E"."TYPE_CODE")=2279 AND "E"."OID"="EM_E_DLDL"."OID" new 1: SELECT 0 FROM jacal.em_e_common E, JACAL.EM_E_DLDL WHERE "E"."G3E_FID"=10000 AND "E"."REF_OID"=0 AND "E"."ISDELETED"=0 AND TO_NUMBER("E"."TYPE_CODE")=2279 AND "E"."OID"="EM_E_DLDL"."OID"