What is use of %TYPE Attribute Is used to declare a variable according to: A database column definition Another declared […]
Author: Bhavesh Lakhani
PL/SQL Variable
Use of Variables Variables can be used for: Temporary storage of data Manipulation of stored values Re-usability Example: SELECT first_name, […]
Oracle row count for all tables in schema
Oracle row count for all tables in schema select owner, table_name, num_rows, last_analyzed from all_tables; Output:
Using SQL LOADER in Oracle to import CSV file
Loading data using SQL Loader Scenario: Suppose we have some legacy system(Main Frame) and now we want to transfer data […]
Query to find 3rd minimum salary in SQL
Select first_name,last_name,salary from employees order by salary asc; Query to find 3rd minimum salary SELECT first_name,last_name,salary from employees e1 where […]
How to find 3rd Max salary in SQL
Select first_name,last_name,salary from employees order by salary desc; SELECT first_name,last_name,salary from employees e1 where 3 =(Select COUNT(DISTINCT salary) from employees […]
Query to find 2nd max salary
Select first_name,last_name,salary from employees order by salary desc; Query to find 2nd maximum salary SELECT MAX(salary) FROM employees WHERE salary […]
Query to Find Duplicate value in SQL
Employee table
PL/SQL introduction
PL/SQL Stands for “Procedural Language extension to SQL” Is Oracle Corporation’s standard data access language for relational databases Seamlessly integrates […]
Node js Environment set up
Download Node js from below Link and Install it. https://nodejs.org/en/ Setting environment variable for node js Checking node version […]
