摘要:
配置内容方式1: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = db1) (PORT 阅读全文
摘要:
1:级联查询子树 SELECT code FROM students where valid_flag = 1 START WITH id IN (select t.id from students t where t.valid_flag = 1 AND t.code IN ('370100', 阅读全文
摘要:
源文:http://hanwangkun.iteye.com/blog/1195526 阅读全文
摘要:
1: Oracle SQL Developer 是非常强悍的开源的SQL开发工具, 可惜最近我才开始研究它, 刚安装好的Oracle SQL Developer 是不支持连接MySQL的, 需要从MySQL官网下载JDBC驱动forMySQL.Oracle SQL Developer官网下载地址:h 阅读全文
摘要:
原文:http://www.myexception.cn/eclipse/425836.html 设置步骤: 导航Package Explorer的右上角有一个黄色双向箭头图标,鼠标移动到上面提示“Link with Editor”,按下这个图标后,你在Editor打开任何文件,Package Ex 阅读全文
摘要:
var v_select = document.getElementById("selectA");var v_option = document.createElement("OPTION");v_select.options.add(v_option);v_option.innerHTML="n... 阅读全文
摘要:
1:业务表create table A_TEST_TRIGGER( ID VARCHAR2(255 CHAR) not null, SN VARCHAR2(255 CHAR))2:保存当前序列号的表:create table SEQUENCE_GENERATOR( KEY VARCHAR2(20) ... 阅读全文
摘要:
/etc/sysconfig/iptablesiptables -siptables -A INPUT -p tcp -m state --state new -m tcp --dport 443 -j ACCEPTiptables -A INPUT -p tcp -m state --state ... 阅读全文
摘要:
设置Oracle Administration Assistant for Windows开始->所有程序->Oracle - OraDb10g_home1->配置和移植工具-> Administration Assistant for Windows在“数据库”项下,对应的实例名,右键“启动/关闭... 阅读全文
摘要:
连接方式与普通的数据库不一样.connection.url 中使用了LOAD-BALANCE = yes 要不然会报错 username jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 11.172.0.71)... 阅读全文