Decode function in Oracle; Example

 https://www.techonthenet.com/oracle/functions/decode.php

Run Python file on Visual Studio Code; Python

 

Right click on the file & select "Run Python File in Terminal" 

Connecting to Oracle DB from Python;

Make you cx_Oracle is installed on the machine;

if not do

> pip install cx_Oracle on windows command if working on Windows machine

import cx_Oracle

conn=cx_Oracle.connect('username/password@host:post/ServiceName')

print (conn.version)

Group access to linux user;

Create linux user 

sudo useradd VJ_test_user

Set Password for the user created

sudo passwd VJ_test_user

> VJ@123

Create a group 

sudo groupadd VJ_test_group

Add users to a group

sudo usermod -a -G VJ_test_group VJ_test_user

sudo usermod -a -G VJ_test_group VJapp

Give group access to the directory

chgrp -R VJ_test_group /home/VJ_test_user

Grant group access 

chmod g+rwX /home/VJ_test_user -R

Change owner of directory:

Change owner and group of directory- 

> chown -r username:groupname <Directory_Location>

Search text in Oracle DB; Returns all types of Oracle function where this text appears;

Select * from ALL_SOURCE  where TEXT LIKE '%Approval%'   

or 

Select * from dba_source where upper(text) like '%ENTER THE TEXT YOU WANT TO SEARCH HERE%'