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

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...