oracle
一. docker 模式下进入数据库 [email?protected]:~$ sudo docker ps -a sudo: unable to resolve host jiang CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES f096e625bcd3 oracleinanutshell/oracle-xe-11g "/bin/sh -c ‘/usr/sb…" About an hour ago Up About an hour 22/tcp,8080/tcp,0.0.0.0:1521->1521/tcp compassionate_lamport [email?protected]:~$ sudo docker exec -it f096e625bcd3 /bin/bash sudo: unable to resolve host jiang [email?protected]:/# 二. 1. 打开终端窗口并执行oraenv?命令以设置环境变量。 2. 执行以下语句以系统管理员身份连接到数据库: sqlplus sys / <password> as sysdba; 3.默认情况下,HR模式已锁定。执行以下语句以解锁HR模式。 ALTER USER hr IDENTIFIED BY hr ACCOUNT UNLOCK; # 演示用户 4.行以下命令以连接到HR?模式: connect hr/hr SQL> connect hr/hr
Connected.
5.?DESCRIBE命令提供了一个指定的表或视图的描述。表和视图的描述包含以下信息:
语法:DESC [RIBE] <table?> 执行以下命令以查看EMPLOYEES表的说明: DESCRIBE EMPLOYEES; SQL> desc employees Name Null? Type ----------------------------------------- -------- ---------------------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME NOT NULL VARCHAR2(25) EMAIL NOT NULL VARCHAR2(25) PHONE_NUMBER VARCHAR2(20) HIRE_DATE NOT NULL DATE JOB_ID NOT NULL VARCHAR2(10) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(2,2) MANAGER_ID NUMBER(6) DEPARTMENT_ID NUMBER(4) 三.表操作 查询表 1. select 语句 语法:SELECT {* | [DISTINCT] column | expression [alias],...}? 1). 查询表的所有数据 SELECT * FROM departments; // SQL> SELECT * FROM departments; DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID ------------- ------------------------------ ---------- ----------- 10 Administration 200 1700 20 Marketing 201 1800 30 Purchasing 114 1700 ? 2).??SELECT?语句中指定列名来显示表中的特定数据列 select JOB_ID,JOB_TITLE FROM jobs; SQL> select JOB_ID,JOB_TITLE FROM jobs; JOB_ID JOB_TITLE ---------- ----------------------------------- AD_PRES President AD_VP Administration Vice President 2. 限制数据 1. where 修改SELECT语句。执行以下查询以将行数限制为DEPARTMENT_ID 60: SELECT * FROM departments WHERE department_id = 60; 2.order by 排序子句 SELECT LAST_NAME,JOB_ID,HIRE_DATE FROM employees WHERE JOB_ID=‘SA_REP‘ ORDER BY HIRE_DATE; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |