• VMware

    Learn about VMware virtualization for its products like vsphere ESX and ESXi, vCenter Server, VMware View, VMware P2V and many more

  • Linux

    Step by step configuration tutorials for many of the Linux services like DNS, DHCP, FTP, Samba4 etc including many tips and tricks in Red Hat Linux.

  • Database

    Learn installation and configuration of databases like Oracle, My SQL, Postgresql, etc including many other related tutorials in Linux.

  • How to create a sequence which start with 1 and next value will be 0 and then next value is 1 and then 0 .. and so on ... is this possible ?

    SQL> CREATE SEQUENCE TEST_SEQ_A
               START WITH 1
               MINVALUE 0
               MAXVALUE 1
               INCREMENT BY -1
               NOCACHE
               ORDER
               CYCLE ;






    SQL> Insert into test(seq) values(TEST_SEQ_A.nextval);
    SQL> Select *from test;

    Output:
    1
    0
    1
    0
    1
    0....


    How to create a sequence which start with 1 and next value will be 0 and then next value is 1 and then 0 .. and so on ... is this possible ? How to create a sequence which start with 1 and next value will be 0 and then next value is 1 and then 0 .. and so on ... is this possible ? Reviewed by Tarun Tripathi on Sunday, January 14, 2018 Rating: 5

    No comments:

    Powered by Blogger.