## How to create table in PL SQL Procedure(Updated)

To unfold a bit on the other answers how to create table in pl SQL procedure. Yes, you must use dynamic SQL to produce a table or perform any other kind of DDL (data description language) operation in PL/ SQL. There are two commonly used methods to execute DDL from PL/ SQLFirst, “ roll your … Read more

## PLSQL program to calculate the gross salary of an employee

In this article, We will see how to calculate the gross salary of an employee using plsql program. What is Gross Salary? The workers who are paid for their services are offered gross payment as their CTC ( cost to company). Cost to the company is the quantum that the company will have to dodge … Read more

## CALCULATE THE NET SALARY Basic HRA and DA Using PLSQL

In this article, we will see how to CALCULATE THE NET SALARY Basic HRA and DA Using PLSQL Program. IF DA IS 30% OFF BASIC, HRA IS 10% OF BASIC AND PF IS 7% IF BASIC SALARY IS LESS THAN 8000, PF IS 10% IF BASIC SAL IS BETWEEN 8000 TO 160000. Net Salary Formula … Read more

## How to find area of circle using plsql program

Area of circle plsql program In this article, we will see how to find Area of circle using plsql program for a given number. In a similar way, you can also find the Area and Perimeter Of Rectangle in PLSQL. What is Circle: A circle closed Aeroplan geometric shape. In specialized terms, a circle is … Read more

## What are databases? Why do we need them?

What are databases and why do we need them? If you want to understand databases then don’t start with the features of database software. you need to go the other way. Databases are designed to solve a problem trying to understand what problems the database is solving. You have some data and therefore you need … Read more

Categories DWH

## How to exclude Saturday and Sunday using SQL query

Here are samples of Oracle SQL queries to exclude Saturday and Sunday using SQL Query. Suppose you’re querying a table to urge the info for a specific date range, and you would like to exclude the weekends. Below is an example. Exclude Weekends in Oracle SQL Using to_char(date, ‘DY’) Function The following SQL query will … Read more

## Sum of odd numbers using for loop in pl/sql

Sum of odd numbers using for loop in pl/SQL. In this article, we will see how to write a PL/SQL program to get the sum of odd numbers using for loop in pl/SQL. Here you can check the query with output. Sum of first odd number = 1 and the Sum of first two odd … Read more

## What is SQL Injection Attack? Updated Guide

What is SQL Injection Attack? It is one of the most common and SQL dangerous methods hackers can use to attack websites using the SQL injection attack method. We’ll talk about how to execute and mitigate web application attacks such as SQL injection, command injection, and cross-site scripting. SQL is used to operate queries and … Read more