随笔分类 -  oracle

oracle触发器--if else demo
摘要：1 CREATE OR REPLACE Trigger trig_solr_index_el_lesson 2 After Update of lessonid, lessonname, lessongoal, note, teachername, teacherid, classidname... 阅读全文
posted @ 2015-08-05 11:31 勿妄 阅读(7837) 评论(0) 推荐(0)
Oracle-属性查询
摘要：1. 查询表的部分字段属性select t.*, c.comments from user_tab_columns t, user_col_comments c where t.table_name = c.table_name and t.column_name = c.column_nam... 阅读全文
posted @ 2015-07-01 10:38 勿妄 阅读(438) 评论(0) 推荐(0)
oracle 本地使用命令导入数据到远程主机
摘要：第一步:装载oracle客户端第二部:配置tnsnames.ora.　db_172.21.1.7 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.1.7)(PORT = 1526)) (CONNECT_DATA = ... 阅读全文
posted @ 2015-04-20 10:07 勿妄 阅读(211) 评论(0) 推荐(0)
oracle函数
摘要：1.字符串操作1.1 substr(string,start,count)取子字符串,从start开始,取count个SQL>selectsubstr(13088888888,3,8)fromdual;SUBSTR(--------088888881.2 instr(C1,C2,I,J)在一个字符串... 阅读全文
posted @ 2015-02-28 09:46 勿妄 阅读(229) 评论(0) 推荐(0)