- 浏览: 25995 次
- 性别:
- 来自: 北京
最新评论
from string get number data using pl/sql or sql
- 博客分类:
- oracle
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 6841.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7561.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 848thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7091.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 767Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6591.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7181.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11221.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5361.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6181.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 708When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 557A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6551.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4131.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7611.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5401. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6581.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8691.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 626ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6101.utl_file_dir: indicate the di ...
相关推荐
PL/SQL 基础,一个不错的 PL/SQL 参考手册。内容预览: ---- 第一章 PL/SQL 简介 ---- 1. Oracle应用编辑方法概览 1) Pro*C/C++/... : C语言和数据库打交道的方法,比OCI更常用; 2) ODBC 3) OCI: C语言和...
these are low-level packages that you can use to enhance your development -- for example, string parsers, a list manager, and an interface to PL/SQL tables. ············
32位版本的 PLSQL 正式版。...Test Window bind variable scan function could fail when using q'<string>' expressions Table.column highlighting did not always work within if-then-else statements
1.丰富的数据类型,从number 到string,从复杂的record到table,以及集合类型等。 2.显示的可读性强的块状结构,可以增强我们维护plsql程序。 3.条件,循环语句,包括if---else,3 个loop循环(简单loop,for...loop...
1、string–>number string类型 *1 即可变成 number类型 2、number–>string number类型 +’‘ 即可变成 string 类型 [removed] function screenInfo() { var str = '012.8372'; var s = 0; str = str...
string sql; string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|ASPNET20Book.mdb;Persist Security Info=True"; System.Data.OleDb.OleDbConnection ...
js加签一般都没有问题,我就是加签之后上传的问题弄了两个礼拜,最后弄清楚了。 以下是数据上报海关方法,我用的是.net的web方式: 1.添加三个引用,见dll文件夹。 2.加载我写的类:两个cs文件(放...//data是数据实体
Mybatis中执行String类型的自己拼写的sql,不执行配置文件中的sql mybatis sql connection mybatis中使用sql,不实用配置文件中的sql实例
(7)PL/SQL进阶分页过程 62 (8)PL/SQL进阶例外 62 (9)视图 62 22.数据库管理+表的逻辑备份与恢复 63 23.数据字典和动态性能视图 67 24.oracle的卸载 69 25.尚学堂SQL简单讲解 70 Oracle常用函数 73 (1)trunc(for date...
Large Data Editor did not show in Single Record View in the SQL Window Selection > Uncomment would remove /* and */ in string constants Window List did not conform to the “Short Text” setting for ...
string tableName)//返回DataSet///5.public DataView GetDataViewValue(string sql) //返回DataView///6.public DataTable GetDataTableValue(string sql)//返回DataTable///7.public void ExecuteNonQuery(string...
4. 准备SQL语句String sql = "insert into test values('rose','f')";//相当于在我们的sql window中写下sql语句 5. 命令对象执行语句int count = st.executeUpdate(sql); //注意 delete insert update 返回的是受...
using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Model { public class Bookmodel { /// /// 图书编号 /// </summary> public string bianhao { get; ...
using System.Data; using IBM.Data.DB2; namespace Person.Data { /// /// 连接DB2数据库类 /// </summary> public class DBConnectDB2 : DBConnect { /// /// 公共连接连接符 /// </summary> public ...
int fe_get_data();//取出数据 void fe_crete_update();//创建修改文件 void fe_setchange_data(char *fdname,char *data);//要修改的字段的数据 |fdname 要修改的字段名 |data要修改的数据 void fe_execute_...
std::string Get();//GET访问网页 std::string Post(const char* chPostData);//POST访问网页 std::string GetHead();//获取请求头 void SetHead(std::string strHead){m_strHead=strHead;}//设置请求头
Function string GetIp(string name) Library "GetNet.dll" //得到本机IP地址 Function string GetLocalIp() Library "GetNet.dll" //通过ip得到域名 Function string GetName(string ip) Library "GetNet.dll" //...
string sqlString = "select count(*) from Users where name='"+name+"' and pass='"+pass+"'"; object obj = SqlHelper.ExecuteScalar(SqlString,CommandType.Text, sqlString); if(obj!=null && obj.ToString...
- 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. ...
postgres pl/python 安装需要的plpython2.so文件和extension文件夹