notes:-
sql command text -1
SQL Commands:
------------
1. DDL(Data definition language)
(i) create
(ii) alter
(iii) rename
(iv) modify
(v) add
(vi) truncate
(vii) drop
2. DML(Data manipulation language)
(i) insert
(ii) update
(iii) delete
(iv) merge
3. TCL(Transaction control language)
(i) commit
(ii) rollback
(iii) savepoint
4. DCL(Data control language)
(i) grant
(ii) revoke
5. DQL(Data query language)
(i) select
sql*plus, sql developer, toad, plsql developer
SQL*Plus: Release 11.2.0.2.0 Production on Mon Jun 5 09:19:43 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> conn system/system
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn sys as sysdba
Enter password:
Connected.
SQL>
SQL> alter user system identified by system;
User altered.
SQL> conn system/system
Connected.
SQL>
SQL> connect
Enter user-name: system
Enter password:
Connected.
SQL> cl scr;
SQL> CREATE TABLE EMPLOYES
2 (EMPNO NUMBER(4),
3 ENAME VARCHAR2(10),
4 SALARY NUMBER(6),
5 JOB VARCHAR2(10),
6 DEPTNO NUMBER(2));
Table created.
SQL> DESC EMPLOYES;
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPNO NUMBER(4)
ENAME VARCHAR2(10)
SALARY NUMBER(6)
JOB VARCHAR2(10)
DEPTNO NUMBER(2)
SQL> ALTER TABLE EMPLOYES
2 RENAME COLUMN EMPNO TO ENO;
Table altered.
SQL> DESC EMPLOYES;
Name Null? Type
----------------------------------------- -------- ----------------------------
ENO NUMBER(4)
ENAME VARCHAR2(10)
SALARY NUMBER(6)
JOB VARCHAR2(10)
DEPTNO NUMBER(2)
SQL> ALTER TABLE EMPLOYES
2 MODIFY ENAME VARCHAR2(20);
Table altered.
SQL> DESC EMPLOYES;
Name Null? Type
----------------------------------------- -------- ----------------------------
ENO NUMBER(4)
ENAME VARCHAR2(20)
SALARY NUMBER(6)
JOB VARCHAR2(10)
DEPTNO NUMBER(2)
SQL> ALTER TABLE EMPLOYES
2 ADD AGE NUMBER(2);
Table altered.
SQL> DESC EMPLOYES;
Name Null? Type
----------------------------------------- -------- ----------------------------
ENO NUMBER(4)
ENAME VARCHAR2(20)
SALARY NUMBER(6)
JOB VARCHAR2(10)
DEPTNO NUMBER(2)
AGE NUMBER(2)
SQL> ALTER TABLE EMPLOYES
2 MODIFY AGE NUMBER(3);
Table altered.
SQL> DESC EMPLOYES;
Name Null? Type
----------------------------------------- -------- ----------------------------
ENO NUMBER(4)
ENAME VARCHAR2(20)
SALARY NUMBER(6)
JOB VARCHAR2(10)
DEPTNO NUMBER(2)
AGE NUMBER(3)
SQL> ALTER TABLE EMPLOYES
2 DROP COLUMN DEPTNO;
Table altered.
SQL> DESC EMPLOYES;
Name Null? Type
----------------------------------------- -------- ----------------------------
ENO NUMBER(4)
ENAME VARCHAR2(20)
SALARY NUMBER(6)
JOB VARCHAR2(10)
AGE NUMBER(3)
SQL> RENAME EMPLOYES TO EMPLOYES33;
Table renamed.
SQL> DESC EMPLOYES;
ERROR:
ORA-04043: object EMPLOYES does not exist
SQL> DESC EMPLOYES33;
Name Null? Type
----------------------------------------- -------- ----------------------------
ENO NUMBER(4)
ENAME VARCHAR2(20)
SALARY NUMBER(6)
JOB VARCHAR2(10)
AGE NUMBER(3)
SQL>
0 comments:
Post a Comment