Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
regexp_instr REGEXP_LIKE REGEXP_REPLACE REGEXP_SUBSTR
trim trim specified pad characters or bytes from a character or byte string
like %, _
like, case-insensitive
You can also
like any (pattern_1, pattern_2, ...)
like all …
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
index is for distribution data index does not have to be unique
primary key must be unique and non null
primary keys are automatically indexed
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
http://plsql4all.blogspot.com/2014/08/auto-increment-column-in-teradata.html http://stackoverflow.com/questions/21982004/how-to-generate-automatic-number-in-teradata-sql https://forums.teradata.com/forum/enterprise/auto-increment-column