CASE WHEN

Get DDL from ALL_SEQUENCES

by Ed Chen
August 2, 2021April 11, 2023

You don't have to export and import sequences by data pump, you can compose the creation statements by querying ALL_SEQUENCES: [oracle@primary01 oracle]$ vi compose_create_sequence.sql set… Read More »

Get DDL from ALL_SYNONYMS

by Ed Chen
July 31, 2021April 11, 2023

You don't have to export and import public synonyms by data pump, you can compose the creation statements by querying ALL_SYNONYMS:: [oracle@primary01 oracle]$ vi compose_create_or_replace_synonym.sql… Read More »

Oracle TO_DATE Example

by Ed Chen
September 21, 2019June 6, 2023

Oracle TO_DATE function can convert a string into a datetime value which is acceptable for computing or comparing values of datetime type. In other words,… Read More »

JavaScript is not enabled. Please enable it and reload the page.