Mastering the Oracle Stack, One Post at a Time.
Biju Let’s talk about a “developer” feature today. If you have a need to generate a column value [mostly primary key] based on a sequence, in pre-12c Oracle database we have to create a number data type column in the table, and use a sequence that is separately created. There is no restriction that the sequence … Read more
Oracle Database 12c has added a lot of features to the database and supporting tools. SQL*Plus is no exception. The login or invoking of SQL*Plus includes more command line options. As in the previous releases, the -H command line option shows the help information. By default SQL*Plus displays the last successful login time, similar to … Read more