1.连接配置路径一般在 oracle\product\11.2.0\= dbhome_1\network\admin下的tnsnames.ora文件:
此处需要非常注意空格,曾经因为空格问题连接失败,可复制粘贴服务端的配置
例子:
nocqb_155 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.41.155)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nocqb)
)
)
2.远程连接失败如果监听有异常,修改服务端与tPrnsnames.ora同级的listener文件:
如:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = nocqb)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = nocqb)
)
(SID_DESC =
(GLOBAL_DBNAME = noccase)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = noccase)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.41.155)(PORT = 1521)
)
)
ADR_BASE_LISTENER = C:\app\Administrator
1.创建表:
create table myBook(
bookid number(10) not null,
bookname varchar2(40),
author varchar2(40),
bookprice number(4,2),
contraint book1_pk primary key(bookid));
2.自连接主要用来显示上下级或者层次关系的
3.oracle的字段名默认大写,如果表中的字段小写,那么在用到这个字段的时候必须加上""
4.oracle安装数据库实例时85%进度出现监听问题,可以关掉防火墙,杀毒软件,lsnrctl stop然lsnrctl start,
若还没解决,在环境变量中加入ORACLE_HOSTNAME = localhost,重启机器即可解决
5.查找日期类型:select * from TRACK_FLIGHT_LOG where csrq = to_date('2015-12-02','yyyy-mm-dd');
6.plsql不登陆进入:sqlplus /nolog