PL/SQL in Shell ?
Hi everybody,
I would like to develop a shell script to kill user session via sever:
this my script, but it's not working … as i'm not very strong in shell, could anyone please have idea to help me to correct this shell script … Thank you so much in advance :
#!/usr/bin/ksh
ksh
export ORACLE_HOME=/softwares/oracle/product/19.0.0
export ORACLE_SID=CGT
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_PDB_SID=GLT
sqlplus -s / as sysdba
SET HEADING OFF;
SET FEEDBACK OFF;
SET PAGESIZE 0;
SET SERVEROUTPUT ON;
BEGIN
FOR sess IN (SELECT SID, SERIAL# FROM V$SESSION
WHERE USERNAME = 'SYSADM'