FilesExpand file tree

 master

/

example_create_sequence.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

25 lines (23 loc) · 1.34 KB

 master

/

example_create_sequence.sql

Copy path

Top

File metadata and controls

• Code
• Blame

25 lines (23 loc) · 1.34 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

-- +----------------------------------------------------------------------------+

-- | Jeffrey M. Hunter |

-- | jhunter@idevelopment.info |

-- | www.idevelopment.info |

-- |----------------------------------------------------------------------------|

-- | Copyright (c) 1998-2015 Jeffrey M. Hunter. All rights reserved. |

-- |----------------------------------------------------------------------------|

-- | DATABASE : Oracle |

-- | FILE : example_create_sequence.sql |

-- | CLASS : Examples |

-- | PURPOSE : Example SQL script that demonstrates how to create a sequence |

-- | number generator. |

-- | NOTE : As with any code, ensure to test this script in a development |

-- | environment before attempting to run it in production. |

-- +----------------------------------------------------------------------------+

DROP SEQUENCE user_id_seq

/

CREATE SEQUENCE user_id_seq

INCREMENT BY 1

START WITH 1000

NOMAXVALUE

NOCYCLE

/