- 浏览: 27564 次
- 性别:
- 来自: 北京
-
最新评论
declare @aa varchar(80),----INFO列
@bb varchar(80)
set @aa ='你好12按时地方'
set @bb=''
while PATINDEX('%[0-9]%',@aa)<>0 /*每次循环找出一个数字*/
begin
set @bb = @bb+substring(@aa,PATINDEX('%[0-9]%',@aa),1)/*把找出来的数字进行相加*/
set @aa=substring(@aa,1,PATINDEX('%[0-9]%',@aa)-1)+
substring(@aa,PATINDEX('%[0-9]%',@aa)+1,len(@aa)-PATINDEX('%[0- 9]%',@aa)) /*把找出来的数字从原先的字符串中踢除出来,然后再循环找出更多的数字*/
end
select @bb/*要求得到的结果*/
发表评论
-
SQL
2012-02-15 18:01 7371.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 8101.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 886thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7651.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 809Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 7111.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7621.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 12371.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5801.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6511.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 747When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 593A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6841.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4411.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 8061.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5831. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6891.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 9161.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 663ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6501.utl_file_dir: indicate the di ...
相关推荐
- Bug # 4918539: ORA-ORA-06502 or ORA-01460 may occurs if a procedure is executed through the Run PL/SQL dialog box and a string with multibyte characters is assigned to one of the parameters. ...
Oracle存储过程是数据库管理系统Oracle中的一个重要特性,它允许开发者编写包含SQL语句和PL/SQL代码的可重复使用的程序单元。这些程序单元可以接受输入参数,处理数据,然后返回结果,甚至可以创建输出表。在C#编程...
CREATE OR REPLACE PROCEDURE get_paged_data ( p_start_row IN NUMBER, p_end_row IN NUMBER, CURSOR c_data RETURN data_table%ROWTYPE ) AS BEGIN OPEN c_data FOR SELECT * FROM ( SELECT t.*, ROW_NUMBER...
PROCEDURE get_paged_data(p_start IN NUMBER, p_end IN NUMBER, p_result OUT SYS_REFCURSOR); END pg_query; / CREATE OR REPLACE PACKAGE BODY pg_query AS PROCEDURE get_paged_data(p_start IN NUMBER, p_end...
using sql_id along with child number instead of hash value # ora webplan aca4xvmz0rzup/3 1 - hash_to_sqlid <sql_id> : get the sql_id of the cursor given its hash value - sqlid_to_hash <sql_id>: ...
[using \'CONNECT_STRING\'] 可以在服务器端,也可以在客户端建立,但必须注意,两台服务器之间 数据库必须可以互访,必须各有各自的别名数据库 18、查看数据库链路 select * from all_db_links; select * from...