摘要:
我使用的Eclipse版本是3.7(Indigo)通过Eclipse的help选项,点击“Install New Software...”弹出安装对话框,点击add按钮,在Location里输入http://download.eclipse.org/technology/m2e/releases/1.3然后就可以选择安装。如下图所示:这里如果m2e的版本选择是的1.4,则会报错:Cannot complete the install because one or more required items could not be found. Software being installed:. 阅读全文
摘要:
一、字符函数1、upper:将每个字母变为大写返回。select upper('aBc') from dual得到:ABC2、lower:将每个字母变为小写返回。select lower('aBc') from dual得到:abc3、initcap:将每个单词的第一个字母大写,其它字母变为小写返回。select initcap('hello wOrld') from dual得到:Hello World4、concat:连接两个字符串。select concat('a','B') from dual得到:aBse 阅读全文
摘要:
1、查看dblink:select * from dba_db_links2、创建dblink的用户需要有创建dblink的权限,授权语句:(public是可选的)grant create [public] database link to myAccount;3、创建语句:create public database link dblinkname connect to username identified by password using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = datab 阅读全文