Wednesday, February 8, 2017

Insert from dual table

SQL> create table pager(PAG_ID number,PAG_PARENT number,PAG_NAME varchar2(20),PAG_ACTIVE number) ;

Table created.

SQL> select * from pager;

no rows selected

SQL> insert into pager (PAG_ID,PAG_PARENT,PAG_NAME,PAG_ACTIVE)
  2            select 8000,0,'Multi 8000',1 from dual
  3  union all select 8001,0,'Multi 8001',1 from dual;

2 rows created.

SQL> select * from pager;

    PAG_ID PAG_PARENT PAG_NAME             PAG_ACTIVE
---------- ---------- -------------------- ----------
      8000          0 Multi 8000                    1
      8001          0 Multi 8001                    1

 
 
 

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...