Merge Statement Example in Orcale

merge [ hints ] into table-name-1 | view-name-1 [ alias-1 ]
using table-name-2 | view-name-2 | subquery [ alias-2 ]
on ( condition )
[ merge-update-clause ] [ merge-insert-clause ] [ error-logging-clause ];
 

 create table table_dest (
  id number primary key,
  txt varchar2(20)
);

insert into table_dest values (1,'one');
insert into table_dest values (3,'three');
insert into table_dest values (5,'five');

commit;

create table table_source (
  id number primary key,
  txt varchar2(20)
);

Read More

Sequence Example 3

 Create sequence emps_seq start with 501 increment by 10

SQL>
SQL> create sequence emps_seq
  2 start with 501
  3 increment by 10;

Sequence created.

SQL>
SQL> drop sequence emps_seq;

Sequence dropped.

SQL>
SQL>


Note:-Please comment and reply me.

Read More

Sequence Example 1

SQL> CREATE SEQUENCE supplier_seq
  2 MINVALUE 1
  3 MAXVALUE 999999999999999999999999999
  4 START WITH 1
  5 INCREMENT BY 1
  6 CACHE 20;

Sequence created.

SQL>
SQL> select supplier_seq.nextval from dual;

  NEXTVAL
----------
  1

SQL> select supplier_seq.nextval from dual;

  NEXTVAL
----------
  2

SQL> select supplier_seq.nextval from dual;

  NEXTVAL
----------
  3

SQL> select supplier_seq.nextval from dual;

  NEXTVAL
----------
  4

SQL>
SQL> drop sequence supplier_seq;

Sequence dropped.


Note:- Please comment and reply me.

Read More

Sequence Example 2

SQL> create sequence deptno_seq
  2 start with 50 increment by 10;

Sequence created.

SQL>
SQL> select deptno_seq.nextval, deptno_seq.currval
  2 from dual;

  NEXTVAL CURRVAL
---------- ----------
  50 50

SQL>
SQL> select deptno_seq.currval
  2 from dual;

  CURRVAL
----------
  50

SQL>
SQL> select deptno_seq.currval, deptno_seq.nextval
  2 from dual;

  CURRVAL NEXTVAL
---------- ----------
  60 60

SQL>
SQL>
SQL> drop sequence deptno_seq;

Sequence dropped.


Note:-Please comment and reply me.

Read More