Srini

How to Create TYPE Object in Oracle PLSQL

Here is sample PLSQL code to create internal variable using TYPE statement.

Srinimf’s Top 2021 Blog Posts

Here are Srinimf’s top blog posts. These are popular for the year 2021.

How to Write Lookup Query in PL/SQL

How to simplify lookup query in PL/SQL explained. You can use both cursor and Associative array for this purpose.

10 Frequently Asked Jenkins(2.0) Interview Questions

Here are the frequently asked interview questions on Jenkins. These help you know the clear difference between the CI/CD capabilities of Jenkins.

Python Identity Vs. Membership Operators

Here are the best examples of identical and membership operators. You will see here how to use and types of those operators.

Python Class: Here’s Logic to Print Student Details

Here is the python program here I used the Python class to display student details of first name, last name, and student id.

7 CICS Symbolic Map Field Extensions

Here are field extensions that generate during the CICS symbolic map. Developers can use them correctly if they know the meanings. Here is a list and their meanings.

grep: How to Find Empty Lines in a File

Here is the most useful command to get empty lines from a file using grep in Linux.

Here is Logic to Write UDF to Check Input is Number or not

Here is a sample function that you can write in PL/SQL of Oracle. This function’s purpose is to check input if it is a number or not.

How to Spell out Number Using Dictionary in Python

Here is a sample python program to spell out a number using dictionary data type. And it is helpful for interviews and project purposes.

How to Write Complex SQL Sub-query

Here is a sample sub-query. Here you will read records from two tables. Also explained how the query works.

How to Run Stored Procedure in SQL Developer

Here are steps of how to create a procedure in SQL developer and how to call it.