ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 2011-06-17

2011-06-17

原创 Linux操作系统 作者:ansir_itpub 时间:2011-06-17 18:06:25 0 删除 编辑

--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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 新的人生的开始
下一篇: 养生之道
请登录后发表评论 登录
全部评论

注册时间:2011-06-17

  • 博文量
    43
  • 访问量
    16347