Monday 10 November 2014

Create a SQL sequence in Oracle

Hello fellas,
Today I'm sharing my learning to how to create a sequence in Oracle from a SQL squery.
Just open a JDeveloper, followed by the SQL worksheet,

CREATE SEQUENCE sequence_name
  MINVALUE value
  MAXVALUE value
  START WITH value
  INCREMENT BY value
  CACHE value;

example


 and following the select query will show the incremented value


thank you :)

A Guide to Installing Oracle HR Schema on an Existing Docker Container

  Hi Reader, Today I want to share my learning on how to install Oracle HR schema on a existing docker container. Step 1: Download the verif...