thiscodeWorks - Organizing the best of code online

List view

apex_application.g_print_success_message := 'Success message';

#changecolumn #toadchangecolumn #oraclechangecolumn #toad #oracle #sql #sqlchange

Change column name in toad, oracle

ALTER TABLE your_table_name
RENAME COLUMN old_column_name TO new_column_name;

#addcolumn #sqladdcolumn #sql #add #oracle #toad

Add column in toad for oracle

ALTER TABLE DIL_POMST
ADD DELIVERY_BY NUMBER;

#oracle #linux

enable firewall port on oracle linux

sudo firewall-cmd --zone=public --permanent --add-port=8080/tcp
sudo firewall-cmd --zone=public --permanent --add-port=1935/tcp
sudo firewall-cmd --reload

#bash #docker #oracle

Linux/Docker: Oracle install 19c (II) on docker

#Copy the image

$ docker pull doctorkirk/oracle-19c

#Create local directory

$ mkdir -p /your/custom/path/oracle-19c/oradata
$ cd /your/custom/path/
$ sudo chown -R 54321:54321 oracle-19c/

#Run the Container

docker run --name oracle-19c \
  -p 1521:1521 \
  -e ORACLE_SID=[ORACLE_SID] \
  -e ORACLE_PWD=[ORACLE_PASSWORD] \
  -e ORACLE_CHARACTERSET=[CHARSET] \
  -v /your/custom/path/oracle-19c/oradata/:/opt/oracle/oradata \
doctorkirk/oracle-19c

#Charset: WE8MSWIN1252(*default), AL16UTF8, US7ASCI
#* If omitted in docker run , the default characterset for this build will be WE8MSWIN1252.

Custome Success Message in Process

Change column name in toad, oracle

Add column in toad for oracle

enable firewall port on oracle linux

Linux/Docker: Oracle install 19c (II) on docker

Save snippets that work with our extensions