alongytl的专栏

google了好会,大部分都是count(*)了下得出来,突然发现了这个[code="java"]select NUM_ROWS,TABLE_NAME from dba_all_tables[/code]真是没话说了啊加个条件,就能得到想要的用户所有表记录数了[code="java"]select * from dba_all_tables t where t.owner='use...

前提是数据库上需要安装java虚拟机(JVM),使用下面的语句查看[code="java"]select * from dba_registry where comp_id = 'JAVAVM'[/code]为空,则未安装,请执行 $ORACLE_HOME/javavm/install/initjvm.sql安装.创建函数[code="java"]create or replace...

转自:虫二的专栏 [url]http://blog.youkuaiyun.com/xzknet/archive/2008/05/06/2404559.aspx[/url]Select * from …. Where [结果过滤条件语句]Start with [and起始条件过滤语句]Connect by prior [and中间记录过滤条件语句]一、Start with........

[code="java"]SELECT TRANSLATE('2KRW229abc','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz', '0123456789') FROM DUAL; [/code]执行结果:2229一、语法： TRANSLATE(string,from_str,...

数据库定义[code="java"]CREATE TYPE t_arr AS OBJECT(id NUMBER ,name varchar2(20));CREATE type t_arr_re as table of t_arr;[/code][code="java"]create or replace procedure test_array(v_cf...