Thursday, August 21, 2025

Print with separator

 

print("2025", "09", "21", sep="-")  


output :

2025-08-21

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Tuesday, July 22, 2025

WTP in python - Traffic Light Simulator

 # Traffic Light Simulator

# Input a color (red, yellow, green) and print the corresponding action:


# Red → Stop

# Yellow → Get Ready

# Green → Go


light_type=input("Please enter the light type (red, yellow, green ) : ")



if(light_type=="red"):

    print("Stop")

elif(light_type=="yellow"):

    print("Get Ready")

elif(light_type=="green"):

    print("Go")

else:

    print("wrong input")

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

WTP in python - Login System

 # Login System

# Ask for a username and password. 

# If both match predefined values, print "Login successful", else show appropriate error messages.

#username : abc

#password : 123



user=input("Please enter username: ")

password= input("Please enter the password:  ")


if(user=="abc" and password == "123"):

    print("Login successful")

elif(user != "abc" and password != "123"):

    print("both Incorrect Username and Password ")

elif (user != "abc"):

    print("Username is not correct ")

else:

    print("password is incorrect ")

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Oracle 19c to PostgreSQL 15 Migration: Step-by-Step Production Guide (Ora2Pg + DMS)

Production-oriented migration approach for a complex Oracle 19c to PostgreSQL 15 workload , covering assessment, schema and code conversion,...