Ramesh Kumar

About  It is a python script that sends WhatsApp messages automatically from the WhatsApp web application. It can be configured to send advertising messages to customers. It read data from an excel sheet and sends a configured message to people. Demo Video clip on youtube of the script execution.  Youtube Prerequisites In order to run the python script, your system must have the following programs/packages installed and the contact number should be saved in your phone (You can use bulk contact number saving procedure of email). There is a way without saving the contact number but has the limitation to send the attachment. Python Selenium Web Driver Google Chrome Pandas Xlrd Approach User scans web QR code to log in to the WhatsApp web application. The script reads a customized message from excel sheet. The script reads rows one by one and searches that contact number in the web search box if the contact number found on WhatsApp then it will send a configured message otherwise ...

About  It is a basic python calculator that can perform basic arithmetic operations like addition, subtraction, multiplication. Approach User enter number (single digit or n character) to perform a specific operation like 1, 2, 3, 4, and n (n is to cancel calculation operation) are valid. Taking two numbers as inputs and used branching if elif else to perform a particular section. Using functions add(), subtract(), multiply() to perform specific task after given data to the system. Code # Program make a basic calculator # Author @inforkgodara # Function adds two numbers def add(first_number, second_number): return first_number + second_number # Function subtracts two numbers def subtract(first_number, second_number): return first_number - second_number # Function multiplies two numbers def multiply(first_number, second_number): return first_number * second_number # Function divides two numbers def divide(first_number, second_number): return first_number / second_num...

About  The set operators are used to combine the results of two component queries into a single result. Queries containing set operators are called compound queries. Setting up sample tables We created two new tables departments and employees for the demonstration using Sample-tables.sql script. The SQL script is under followed. -- Create DEPARTMENTS table CREATE TABLE DEPARTMENTS ( DEPARTMENT_ID NUMBER(2) CONSTRAINT DEPARTMENTS_PK PRIMARY KEY, DEPARTMENT_NAME VARCHAR2(14), LOCATION VARCHAR2(13) ); -- Create EMPLOYEES table CREATE TABLE EMPLOYEES ( EMPLOYEE_ID NUMBER(4) CONSTRAINT EMPLOYEES_PK PRIMARY KEY, EMPLOYEE_NAME VARCHAR2(10), JOB VARCHAR2(9), MANAGER_ID NUMBER(4), HIREDATE DATE, SALARY NUMBER(7,2), COMMISSION NUMBER(7,2), DEPARTMENT_ID NUMBER(2) CONSTRAINT EMP_DEPARTMENT_ID_FK REFERENCES DEPARTMENTS(DEPARTMENT_ID) ); -- Insert data into DEPARTMENTS table INSERT INTO DEPARTMENTS VALUES (10,'ACCOUNTING...

About  A join is a query that combines rows from two or more tables, views, or materialized views. Oracle Database performs a join whenever multiple tables appear in the FROM clause of the query. The select list of the query can select any columns from any of these tables. If any two of these tables have a column name in common, then you must qualify all references to these columns throughout the query with table names to avoid ambiguity. Oracle supports inner join, left join, right join, full outer join and cross join. You can join a table to itself to query hierarchical data using an inner join, left join, or right join. This kind of join is known as self-join. Setting up sample tables We created two new tables with the same structure for the demonstration using Sample-tables.sql script. The SQL script is under followed. -- Create BALLOON_A table CREATE TABLE BALLOON_A (     ID INT PRIMARY KEY,     COLOR VARCHAR2 (100) NOT NULL ); -- Create BALLOO...