plsql怎么用字段查表明_在oracle中怎么通过字段名查询其所在的表
ora = //连接描述符名：ora
(description = //描述
(address = //网络地址之一
(protocol = tcp) //网络协议(tcp表示TCP/IP协议)
(host = 129.9.114.22) //服务器IP地址：129.9.114.22
(port = 1251) //服务器端口号:1251
)
(connect_data = //连接数据
(sid = ora7) //数据库标识名：ora7
(SERVER = DEDICATED)
(SERVICE_NAME = ora9i)
)
)
1、ORACLE备份数据到新表
create table poor.orderrequest_20171108 as select * from poor.orderrequest r WHERE r.ORDERREQUESTID=18859735;
select listagg(sickbedid, ',') within group(order by sickbedid) from concept.sickbed where ORGANIZATIONID=836248;
select wmsys.wm_concat(ii.EXTENSION) INTO v_sickbedids from concept.sickbed s, CONCEPT.SICKBEDII ii WHERE s.SICKBEDID=ii.SICKBEDID
2、在oracle中怎么通过字段名查询其所在的表
select c.owner, c.table_name, c.* from dba_tab_columns c where c.column_name like '%PROVIDE%';
3、Timestamp类型字段更新范例：
update POOR.OrderRequest set RowVersion = systimestamp, NumberVersion = NumberVersion + 1 where OrderRequestId in (83634);
update POOR.OrderRequest set RowVersion = to_timestamp('2018-04-08 21:20:42.439', 'yyyy-mm-dd hh24:mi:ss:ff'), NumberVersion = NumberVersion + 1 where OrderRequestId in (77133) and EncounterId in (12117);
commit;
USE JX_T30_DXS
select distinct OBJECT_SCHEMA_NAME(id) + '.' + object_name(id) from syscomments
where text like '%rowversion%' and text like '%OPENQUERY%' and text like '%POOR.ORDERREQUEST%' AND object_name(id) NOT LIKE '%删除%';
CREATE TABLE #tmpTable
(
OrderRequestID INT, NumberVersion INT, [RowVersion] DATETIME NULL
)
INSERT INTO #tmpTable(OrderRequestID, NumberVersion, [RowVersion])
SELECT * FROM OPENQUERY(syorcl, 'select r.orderrequestid, r.numberversion, r.rowversion from POOR.ORDERREQUEST r where OrderRequestId in (83634)');
select * from #tmpTable;
drop table #tmpTable;
3、更新事件内容调试时要注意清空ContentData为Null才会生效(调度会先把EventData序列化到ContentData)：
update ixs.Event set eventdata=''
, ContentData=null where Id = 17644781;
--判断字段是否全数字：
SELECT max(to_number(EXTENSION)) FROM PRPA.ENCOUNTERII where REGEXP_LIKE(EXTENSION, '(^[+-]?\d{0,}\.?\d{0,}$)');