What Is a Sequences
What Is a Sequences?
✍: fyicenter.com
Sequences are used for generating sequence numbers without any overhead of locking. Drawback is that after generating a sequence number if the transaction is rolled back, then that sequence number is lost.
2007-04-15, 5017👍, 0💬
Related Topics:
What Are TTITLE and BTITLE
What Are TTITLE and BTITLE? TTITLE and BTITLE are commands to control report headings & footers. 2007-04-15, 5532👍, 0💬
What Are Character Functions
What Are Character Functions? Character Functions are INITCAP, UPPER, LOWER, SUBSTR and LENGTH. Additional functions are GREATEST and LEAST. 2007-04-15, 5169👍, 0💬
In What Order Different Parts of SQL Statements Are Executed
In What Order Different Parts of SQL Statements Are Executed? Where clause, Group By clause, Having clause, Order By clause and Select. 2007-04-15, 5129👍, 0💬