Backup Packages and Procedures Usually, source codes of programming unit should be version-controlled by the developer team. Mostly, they use Git, CVS or SVN to… Read More »How to Backup PL/SQL Codes in Oracle
Here I introduce a trigger which can log logon information on specific schemas. It will kill their sessions if they are not from specific subnet.… Read More »How to Kill Session in Logon Trigger
ORA-31693 Got ORA-31693 when import data with schema mode. [oracle@test ~]$ impdp system/password schemas=hr,oe,sh content=data_only table_exists_action=truncate network_link=system_link_orcl ... ORA-31693: Table data object "OE"."ORDER_ITEMS" failed to… Read More »How to Resolve impdp Error ORA-31693 with ORA-39116
According to MySQL documentation:MySQL :: MySQL 5.7 Reference Manual :: 12.5.2 Regular ExpressionsREGEXP is not case sensitive, except when used with binary strings.It seems to… Read More »Is REGEXP (or RLIKE) Always Case Insensitive?