filmov
tv
| SQLCL Commands (Part 1) |
Показать описание
Please subscribe my channel and don't forget to hit the bell icon to get the latest videos
Some SQLCL(SQL Command Line) Commands introduced in 12C
----------------------------------------------------------------------------------------------------------
(1)DDL
(2)INFORMATION/INFO
(3)CTAS --CREATE TABLE AS
DDL EMP;
SELECT DBMS_METADATA.GET_DDL('TABLE','EMP') FROM DUAL;
DESC EMP;
INFO EMP;
CTAS EMP EMP_NEW
Phone No- 8018319781
Some SQLCL(SQL Command Line) Commands introduced in 12C
----------------------------------------------------------------------------------------------------------
(1)DDL
(2)INFORMATION/INFO
(3)CTAS --CREATE TABLE AS
DDL EMP;
SELECT DBMS_METADATA.GET_DDL('TABLE','EMP') FROM DUAL;
DESC EMP;
INFO EMP;
CTAS EMP EMP_NEW
Phone No- 8018319781