PYTHON Introduction Program: A program is a set of instructions that can be executed by the computer to perform a specific task. Purpose of using programs: 👉 To get accurate results. 👉 To get output very fast. We can write the programs using both the… Read More
CONTROL FLOW Decision making statements in programming languages decide the direction of the flow of program execution based on the given conditions. Python supports if, Elif used to decide the flow of execution. If statement: It is the basic decision-making statement, in this the code… Read More
Python – Datatypes 👇👇👇👇 Please check the below link for the full document 👇👇👇👇 https://www.ktexperts.com/wp-content/uploads/2022/12/datatypes.pdf Author : Teja LinkedIn : https://www.linkedin.com/in/teja-sai-nadh-reddy-tatireddy-048882201 Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates KTExperts is… Read More
PYTHON INTRODUCTION WHAT IS PYTHON Python is a high-level, interpreted, interactive and object-oriented scripting language developed by Guido Van Rossum. Python is a powerful, flexible and easy to use scripting language. FEATURES OF PYTHON: Free & Open Source Python language is freely available at the… Read More
Dear Readers, In this article, we will see the following Install Python Boto3 On AWS EC2. Steps to Follow : Logging to AWS Account Launch Linux Server Connect to Linux EC2 Instance by Using Putty Install Python Package Install Boto3 Package Verify boto3 Package … Read More
Dear Readers, In this article, we will see the following Comparison between Python and Shell Script for sending email for the set of SQL commands. Python and Shell Script for sending email for the set of SQL commands: Shell Script:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
#!/bin/bash #Script to perform testing ## Environment variables TODAY=`date +%d-%b-%Y-%H:%M:%S` export ORACLE_HOME='/u01/app/oracle/product/12.1.0.2' export ORACLE_SID='prod' export ORACLE_BASE='/u01/app/oracle' export PATH=$PATH:${ORACLE_HOME}/bin export MAILIST='ktexperts@gmail.com' export LOG='/tmp/test_mig.log' #Function step1 function step1 { echo " " >> $LOG echo "Started Step 1" >> $LOG echo " " >> $LOG echo "Test email " >> $LOG sqlplus vinod/vinod <<START >>$LOG prompt updating records in EMP table select * from emp where deptno=20; prompt update emp set sal=sal+500 WHERE deptno=20; update emp set sal=sal+500 WHERE deptno=20; prompt select * from emp where deptno=20; select * from emp; START echo " " >> $LOG echo "----- END OF Step1 ------" >> $LOG } #Function to trigger email function mailog { cat ${LOG} | mailx -s "${TODAY} - TEST Mail" ${MAILIST} } #Script execution is here > $LOG if [ "$#" -eq 0 ] then step1 mailog else $1 mailog fi |
Output:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
updating records in EMP table SQL> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17-DEC-80 4800 20 7566 JONES MANAGER 7839 02-APR-81 6975 20 7788 SCOTT ANALYST 7566 19-APR-87 7000 20 7876 ADAMS CLERK 7788 23-MAY-87 5100 20 7902 FORD ANALYST 7566 03-DEC-81 7000 20 SQL> update emp set sal=sal+500 WHERE deptno=20 SQL> 5 rows updated. SQL> select * from emp where deptno=20 SQL> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17-DEC-80 5300 20 7566 JONES MANAGER 7839 02-APR-81 7475 20 7788 SCOTT ANALYST 7566 19-APR-87 7500 20 7876 ADAMS CLERK 7788 23-MAY-87 5600 20 7902 FORD ANALYST 7566 03-DEC-81 7500 20 |
Python Script:… Read More
How to Install Ansible in Amazon Linux Machine Dear Readers, In this article,we will see Install Ansible in Amazon Linux Machine. Steps to Follow Launch Ansible Machine. Connect to Ansible Linux EC2 Terminal through Putty. Switch to root user. Update Server Packages. Install the ansible.… Read More
