Oracle DBA Basics #03 - SQL Developer & SQLplus Conn - SQLPlus in Shell Script, Running SQL in nohup

preview_player
Показать описание
Connecting/Calling SQL-Plus from a Shell Script

Database connection using sqlplus using tools
--- TOAD,SQL Developer, OEM or any other tools

SQLPLUS
Connecting/Calling SQL-Plus from a Shell Script
Running SQL files from SQL-Plus
Running SQL files from SQL-Plus with sys user
Running script in backend

----------------------------------------------------------

#SQLPLUS #DBConnecion #SQLDeveloper #ShellScript #SQLinNohup #BackgroudScript

Please do follow me and support me on,

Skype: malluramadurg

Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Skype: malluramadurg
Рекомендации по теме
Комментарии
Автор

Hi - i have a scenario where i need to run sql statement multiple times through shell script(simple select statement like - select emp_id from emp where emp_status = active). Is it possible thru sh scripting to invoke sql query multiple times until my where condition is success. Imagine there are DB transaction updates happening to employee.

manikiran
Автор

Could you please upload more videos on Shell scripts using Oracle. Give me the link if already uploaded.

jagadeeshdora
Автор

Hi, I have connected to Oracle db using sqlplus command and connection got established. Now I'm trying to insert / update record from shell script but it's not working and not returning any error. only select statements are working

kabira__shaikh
Автор

Can you tell the cron job also in this

sudharshan_reddy_kakarla