Articles

Introduction to PostgreSQL

by Prudhvi TejaPostgreSQL

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

by Prudhvi TejaPython

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

by Vinod SiramOracle DB Admin

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

by Prudhvi TejaPython

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

by TejaPython

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

by TejaPython

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

by TejaPython

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

by TejaPython

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

by Vinod SiramOracle DB Admin

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 »