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,
example
and following the select query will show the incremented value
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 :)