孙俊强

摘要： F:\bea\wlserver_10.3\common\deployable-libraries\jsf-1.2.warF:\bea\wlserver_10.3\common\deployable-libraries\jstl-1.2.warF:\bea\workshop_10.3\common\deployable-libraries\wls-commonslogging-bridge.earF:\bea\workshop_10.3\common\deployable-libraries\wls-commonslogging-bridge.war 阅读全文

摘要： SYS@orcl> drop table dual;SYS@orcl> select * from dual;select * from dual *ERROR at line 1:ORA-00980: synonym translation is no longer validSYS@orcl> shutdow immediateSYS@orcl> startupORACLE instance started.Total System Global Area 171966464 bytesFixed Size 787988 bytesVariable Size 145 阅读全文

摘要： SYS@orcl> create tablespace testspace datafile 'D:\testdatafile' size 10MSYS@orcl> create table scott.testtable(id varchar2(16)) tablespace testspace;SYS@orcl> insert into scott.testTable(id) values(1234567);SYS@orcl> insert into scott.testTable(id) values(123456789);SYS@orcl> 阅读全文

摘要： sqlprompt的设置SQL*Plus提供了一组预定义变量,可以用于其他替换变量相同的方法使用它们.sys@ORCL> DEFINE -- 显示预定义的SQL*Plus变量列表sys@ORCL> set sqlprompt --设置预定义的SQL*Plus变量列表一、查看参数sys@ORCL> DEFINEDEFINE _DATE = "09-9月 -07" (CHAR) --当前日期DEFINE _CONNECT_IDENTIFIER = "orcl" (CHAR) --连接的数据库名DEFINE _USER = "SYS 阅读全文