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

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...