2011-06-17

--notepad

select * from user_dependencies;

using the query you can get the structure of the object.

SELECT * FROM ALL_SOURCE WHERE NAME LIKE 'BASP0099';

-- why I can not get the procedure

SELECT * FROM all_dependencies WHERE upper(NAME) LIKE '%formInputArr%';

-- search the spbx4001 command

cd $TBA_PROD_ROOT;
find . -name spbx4001*

result : not getting the valid result.

16:09 status getting better

-- practice the local compiling

-- how to get the English version about local compiling

-- 拳不离手

-- function : get all tables and store them into a variable and output the count of it.
set serveroutput on
declare
v_stmt varchar2(3000);
v_tab varchar2(100):='USER_TABLES';
begin

v_stmt :='declare'||
' type v_tab_table_type is table of '||v_tab||'%ROWTYPE;'||
'v_tab_table
  v_tab_table_type;'||
'begin'||
'  select * bulk collect into v_tab_table from '||v_tab||';'||
'  dbms_output.put_line(v_tab_table.count);'||
'end;'
;

execute immediate v_stmt;

end;

set serveroutput on
declare
v_stmt varchar2(3000);
v_tab varchar2(100):='USER_TABLES';
v_test varchar2(100):='test';
begin

v_stmt :='declare'||
' type v_tab_table_type is table of '||v_tab||'%ROWTYPE;'||
'v_tab_table
  v_tab_table_type;'||
'begin'||
--'select * bulk collect into v_tab_table from '||v_tab||';'||
' dbms_output.put_line('||'chr(39)||test||chr(39)||);'||
'end;'
;

execute immediate v_stmt;

end;

debug

delimit [di'lɪmɪt]
[词典释义]vt. 1. 划定...的界限;限定
[网络释义]1.定界定义 2.划定界限 3.定界，划界

-- about the tech online call

--

oversight : 失察

-- test the sql

set serveroutput on

declare

type v_row_table_type is table of USER_TABLES%ROWTYPE;

v_row_table v_row_table_type;

begin
 

select * bulk collect into v_row_table from USER_TABLES;

dbms_output.put_line(v_row_table.count);

end;

declare
v_stmt varchar2(1000);
begin
 

v_stmt :='select * from USER_TABLES ';

execute immediate v_stmt;

end;

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25951437/viewspace-700158/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25951437/viewspace-700158/