Saturday, February 25, 2017

Create table by Select Statement in oracle

Enter user-name: test/test@fstar

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> desc fhrd.emp_shft
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 EMP_ID                                             VARCHAR2(6)
 AT_DT                                              DATE
 SHFT                                               VARCHAR2(1)

SQL> create table emp_shft as select * from fhrd.emp_shft;

Table created.

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/