Articles

OPERATORS IN PYTHON

OPERATORS IN PYTHON Operator: It is defined as a symbol which is responsible for a particular operation between two operands. Python supports different types of operators: 1.Arithmetic Operators               2.Assignment Operators            3.Logical Operators                    4.Comparison Operators            5.Bitwise Operators                    6.Identity Operators                    7.Membership Operators              Arithmetic Operators: They are… Read More

Installation of PostgreSQL

Installation of PostgreSQL As PostgreSQL is an open source, we can download it from official website (www.postgresql.org) by following below steps: Go to official website >> Click on Download >> Choose your System OS >> Click “Download the installer” Select latest version (15.2 present) of… Read More

Introduction to MongoDB

Introduction to MongoDB MongoDB is an open and free NoSQL database management system. It is a document oriented database, i.e. it will store all the data in semi-structured Binary JSON like documents. Features of MongoDB Document Object Data Model: MongoDB stores the data as Binary… Read More

Introduction to PostgreSQL

Introduction to PostgreSQL • PostgreSQL (pronounced as post-gress-Q-L) is a high demand open-source object relational database management system (ORDBMS). It was developed by a worldwide team of volunteers. It is not controlled by any private entity so, it is available for free. • PostgreSQL uses… Read More

FUNCTIONS IN PYTHON

FUNCTIONS IN PYTHON FUNCTION :   A function is a block of code that executes only when it is called. Data can be passed to functions as parameters. A function can return the result or output the result. In python a function can be created or… Read More

Table/index movement using pl/sql procedure

Table/index movement using pl/sql procedure CREATE TABLESPACE AWS_DATA01 DATAFILE ‘+DATA’ size 10G ##################### PRE-VALIDATIONS ################## 1) Gather all below data into a SQL log file for future validations spool TABLE_INDEX_REORG_REBUILD_PREVALIDATIONS.log set echo on set linesize 300 col index_name for a30 col degree for a10 col… Read More

LOOPS IN PYTHON

LOOPS IN PYTHON Python language provides three types of loops, They are : while loop for loop nested loop Loop : It is a sequence of statements that will be repeated continuously until a certain condition is met. While Loop : It is used to… Read More

Control Flow In Python

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

Variables in Python

Variables in Python Identifiers: Identifiers are used to identify an entity uniquely in a program at the time of execution. Examples: class names, function names, variable names etc. Variable:Variable is a name given to a memory location that is used to hold a value. Ex:… Read More

Python – Datatypes

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

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

Datapump export and import from Source PDB to Target PDB

Datapump export and import from Source PDB to Target PDB. Source : SQL> alter session set container=OGGDB1PDB; Session altered. SQL> select username from dba_users where oracle_maintained=’N’; USERNAME ——————————————————————————– PDBADMIN HR SQL> select table_name from dba_tables where owner=’HR’; TABLE_NAME ——————————————————————————– REGIONS LOCATIONS DEPARTMENTS JOBS EMPLOYEES JOB_HISTORY… Read More

More Latest News »