[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select object_id
from dba_objects
where object_name = c_name
and object_type = c_type
and owner = c_owner;
, c_state => 'SELECTED');
select release_name
from fnd_product_groups
order by release_name;
htp.p('');
Line: 190
htp.p('');
Line: 216
select name
from sys.obj$
where obj# = n_object_id;
Line: 221
select name
from sys.con$
where con# = n_object_id;
Line: 230
select object_name
, object_type
, owner
from dba_objects
where object_id = n_object_id;
Line: 267
select object_name
, object_type
, owner
from dba_objects
where object_id = n_object_id;
Line: 295
select owner, object_type, count(object_name) object_count
from dba_objects
where object_name like c_name ESCAPE '\'
and object_type like c_type
and owner like c_owner
and status like c_status
group by owner, object_type
order by owner, object_type;
Line: 383
select owner, object_name
from dba_objects
where object_name like c_name ESCAPE '\'
and object_type like c_type
and owner like c_owner
and status like c_status
order by owner, object_name;
Line: 467
select OWNER
, OBJECT_NAME
, SUBOBJECT_NAME
, OBJECT_ID
, DATA_OBJECT_ID
, OBJECT_TYPE
, CREATED
, LAST_DDL_TIME
, TIMESTAMP
, STATUS
, TEMPORARY
, GENERATED
, SECONDARY
from dba_objects
where object_name = c_name
and object_type = c_type
and owner = c_owner;
Line: 487
select a.application_short_name
, a.application_id
, t.table_id
from fnd_tables t
, fnd_application a
where table_name = c_name
and t.application_id = a.application_id
order by a.application_short_name;
Line: 499
select a.application_short_name
, a.application_id
, t.view_id
from fnd_views t
, fnd_application a
where view_name = c_name
and t.application_id = a.application_id
order by a.application_short_name;
Line: 623
select etrm_pnav.get_object_name(robj#, 'RAW') table_name
, robj# object_id
, con# cons_id
from sys.cdef$
where obj# = n_object_id
and robj# is not null
order by etrm_pnav.get_object_name(robj#);
Line: 632
select etrm_pnav.get_object_name(obj#, 'RAW') table_name
, obj# object_id
, con# cons_id
from sys.cdef$
where robj# = n_object_id
order by etrm_pnav.get_object_name(obj#);
Line: 643
is select cc.column_name
from dba_cons_columns cc
where cc.constraint_name = cv_cons_name
and cc.owner = c_owner
order by cc.position;
Line: 775
IS select tab.table_name
, tab.tablespace_name
, tab.pct_free
, tab.pct_used
, tab.temporary
, tab.duration
from dba_tables tab
where table_name = c_name
and owner = c_owner
order by tab.table_name;
Line: 789
is select comments
from dba_tab_comments
where owner = c_owner
and table_name = c_name
and (table_type = 'TABLE'
OR table_type = 'VIEW');
Line: 799
is select ind.index_name
, ind.index_type
, ind.uniqueness
, ind.tablespace_name
, ind.pct_increase
, ind.pct_free
, ind.owner
from dba_indexes ind
where ind.table_name = cv_tab_name
and ind.table_owner = c_owner
order by ind.uniqueness desc, ind.index_name;
Line: 814
is select ic.column_name
, ic.column_length
from dba_ind_columns ic
where ic.index_name = cv_index_name
and ic.index_owner = c_owner
order by ic.column_position;
Line: 823
is SELECT COLUMN_EXPRESSION
FROM SYS.DBA_IND_EXPRESSIONS
where INDEX_OWNER = c_owner
and INDEX_NAME = cv_index_name
order by COLUMN_POSITION;
Line: 834
is select uc.constraint_name
from dba_constraints uc
where uc.table_name = cv_table_name
and uc.owner = c_owner
and uc.constraint_type = 'P'
order by uc.constraint_name;
Line: 844
is select uc.constraint_name
from dba_constraints uc
where uc.table_name = cv_table_name
and uc.constraint_type = 'U'
and uc.owner = c_owner
order by uc.constraint_name;
Line: 857
is select cc.column_name
from dba_cons_columns cc
where cc.constraint_name = cv_cons_name
and cc.owner = c_owner
order by cc.position;
Line: 1015
is select col.column_name
, col.data_type
, col.data_length
, nvl(to_char(col.data_precision), '
') data_precision
, nvl(decode(col.nullable, 'N', 'Yes'), '
') nullable
from dba_tab_columns col
where col.table_name = c_name
and col.owner = c_owner
order by col.column_id;
Line: 1029
is select comments
from dba_col_comments
where owner = c_owner
and table_name = c_tname
and column_name = c_cname;
Line: 1112
htp.p('SELECT '||col_rec.column_name);
Line: 1130
SELECT CONTAINER_NAME
, UPDATABLE
, REWRITE_ENABLED
, REWRITE_CAPABILITY
, REFRESH_MODE
, REFRESH_METHOD
, BUILD_MODE
, FAST_REFRESHABLE
FROM SYS.DBA_MVIEWS
where OWNER = c_owner
and MVIEW_NAME = c_name;
Line: 1144
is select comments
from dba_tab_comments
where owner = c_owner
and table_name = c_name;
Line: 1152
select LPAD(' ',5*(LEVEL-1)) || a.master tree_entry
from SYS.SNAP_REFTIME$ a
start with a.vname = c_name
connect by prior a.master = a.vname;
Line: 1209
SELECT TABLE_OWNER
, BASE_OBJECT_TYPE
, TABLE_NAME
FROM SYS.DBA_TRIGGERS
where OWNER = c_owner
and TRIGGER_NAME = c_name;
Line: 1241
SELECT TABLE_OWNER
, TABLE_TYPE
, TABLE_NAME
FROM SYS.DBA_INDEXES
where OWNER = c_owner
and INDEX_NAME = c_name;
Line: 1273
SELECT TABLE_OWNER
, TABLE_NAME
, DB_LINK
FROM SYS.DBA_SYNONYMS
where OWNER = c_owner
and SYNONYM_NAME = c_name;
Line: 1304
SELECT QUEUE_TABLE
, QUEUE_TYPE
, MAX_RETRIES
, RETRY_DELAY
, ENQUEUE_ENABLED
, DEQUEUE_ENABLED
, RETENTION
, USER_COMMENT
FROM SYS.DBA_QUEUES
where OWNER = c_owner
and NAME = c_name;
Line: 1349
SELECT TYPECODE
, ATTRIBUTES
, METHODS
, PREDEFINED
, INCOMPLETE
FROM SYS.DBA_TYPES
where owner = c_owner
and type_name = c_name;
Line: 1360
SELECT OWNER
, TYPE_NAME
, COLL_TYPE
, UPPER_BOUND
, ELEM_TYPE_MOD
, ELEM_TYPE_OWNER
, ELEM_TYPE_NAME
, LENGTH
, PRECISION
, SCALE
, CHARACTER_SET_NAME
, ELEM_STORAGE
, NULLS_STORED
FROM SYS.DBA_COLL_TYPES
where owner= c_owner
and type_name= c_name;
Line: 1382
SELECT OWNER
, TYPE_NAME
, ATTR_NAME
, ATTR_TYPE_MOD
, ATTR_TYPE_OWNER
, ATTR_TYPE_NAME
, LENGTH
, PRECISION
, SCALE
, CHARACTER_SET_NAME
, ATTR_NO
FROM SYS.DBA_TYPE_ATTRS
where owner = c_owner
and type_name = c_name
order by attr_no;
Line: 1400
SELECT OWNER
, TYPE_NAME
, METHOD_NAME
, METHOD_NO
, METHOD_TYPE
, PARAMETERS
, RESULTS
FROM SYS.DBA_TYPE_METHODS
where owner = c_owner
and type_name = c_name
order by method_no;
Line: 1417
SELECT PARAM_NAME
, PARAM_NO
, PARAM_TYPE_NAME
FROM SYS.DBA_METHOD_PARAMS
where owner = c_owner
and type_name = c_name
and method_name = c_method
and method_no = n_methno
order by param_no;
Line: 1432
SELECT RESULT_TYPE_NAME
FROM SYS.DBA_METHOD_RESULTS
where owner = c_owner
and type_name = c_name
and method_name = c_method
and method_no = n_methno;
Line: 1585
is select d_obj# object_id
, etrm_pnav.get_object_name(d_obj#, 'USER') owner
, etrm_pnav.get_object_name(d_obj#, 'ITEM') item
from sys.dependency$
where p_obj# = n_object_id
order by etrm_pnav.get_object_name(d_obj#);
Line: 1593
is select p_obj# object_id
, etrm_pnav.get_object_name(p_obj#, 'USER') owner
, etrm_pnav.get_object_name(p_obj#, 'ITEM') item
from sys.dependency$
where d_obj# = n_object_id
order by etrm_pnav.get_object_name(p_obj#);
Line: 1709
is select line
, text
from dba_source
where name = c_name
and type = c_type
and owner = c_owner;
Line: 1718
is select text
from dba_views
where view_name = c_name
and owner = c_owner;
Line: 1725
is select query
from dba_mviews
where mview_name = c_name
and owner = c_owner;
Line: 1732
is select description
, trigger_type
, triggering_event
, column_name
, referencing_names
, when_clause
, trigger_body
from dba_triggers
where trigger_name = c_name
and owner = c_owner;
Line: 1755
v_viewtext := replace(v_viewtext , 'SELECT ', 'SELECT ');
Line: 1807
is select line||': '||text text
from dba_source
where name = c_name
and type = c_type
and owner = c_owner;
Line: 1815
is select text
from dba_views
where view_name = c_name
and owner = c_owner;
Line: 1849
is select line
, position
, text
from dba_errors
where name = c_name
and owner = c_owner
and type = c_type
order by sequence;
Line: 1941
select count(table_name) app_count
from dba_tables
where owner = 'APPLSYS'
and table_name = 'FND_APPLICATION';
Line: 1947
is select username
from dba_users
order by username;
Line: 1962
'select decode(app.application_short_name, ''SQLAP'', ''AP''
, ''SQLGL'', ''GL''
, app.application_short_name) application_short_name
, tl.application_name
from fnd_application app
, fnd_application_tl tl
where tl.application_id = app.application_id
order by decode(app.application_short_name, ''SQLAP'', ''AP''
, ''SQLGL'', ''GL''
, app.application_short_name)';
Line: 2246
select line
, source
from sys.source$
where upper(source) like c_name
and obj# = n_object_id;
Line: 2254
select line
, source
from sys.source$
where line > (n_line - 5)
and line < (n_line +5)
and obj# = n_object_id;
Line: 2296
select line
, source
from sys.source$
where obj# = n_object_id;
Line: 2313
( select_line number(32)
, term_line number(32)
, status varchar2(16));
Line: 2318
v_select_stmt line_table;
Line: 2325
htp.p('The following lines contain the word ''select'', ''insert'', ''update'' or ''delete'':
');
Line: 2338
if ((upper(v_source(v_line)) like '%SELECT%')
or (upper(v_source(v_line)) like '%INSERT%')
or (upper(v_source(v_line)) like '%UPDATE%')
or (upper(v_source(v_line)) like '%DELETE%'))
and
ltrim(v_source(v_line), ' ') not like '--%'
then
v_stmt_count := v_stmt_count +1;
Line: 2346
v_select_stmt(v_stmt_count).select_line := v_line;
Line: 2347
v_select_stmt(v_stmt_count).term_line := v_line;
Line: 2348
v_select_stmt(v_stmt_count).status := 'VALID';
Line: 2355
if v_select_stmt(i).select_line < (v_prevline +1)
then v_select_stmt(i).status := 'INVALID';
Line: 2360
v_line := v_select_stmt(i).term_line;
Line: 2363
v_select_stmt(i).term_line := v_line;
Line: 2373
if v_select_stmt(i).status = 'VALID' then
htp.p('Line: '||v_select_stmt(i).select_line||'
');
Line: 2376
for j in v_select_stmt(i).select_line .. v_select_stmt(i).term_line loop
htp.prn(v_source(j));
Line: 2399
select owner, object_name
from dba_objects
where object_name like c_name ESCAPE '\'
and object_type like c_type
and owner like c_owner
and status like c_status
order by owner, object_name;