Category: SQL

https://leetcode.com/problems/combine-two-tables/

SELECT
    firstname,
    lastname,
    city,
    state
FROM person LEFT JOIN address 
ON person.personid = address.personid;

cd /Users/azmiratania/.sqldeveloper/20.4.1 
vi product.conf
SetJavaHome /Library/Java/JavaVirtualMachines/jdk1.8.0_291.jdk/Contents/Home

Extract a substring from a string

SELECT SUBSTR("SQL Tutorial", 5, 3) AS ExtractString;

https://www.w3schools.com/sql/func_mysql_substr.asp

SUBSTR(MA.REFERENCE_ID, 1, 8) = SUBSTR(EA.REFERENCE_ID, 1, 8)

SELECT bank_name, decode(bank_id, 001, 'SBI', 002, 'ICICI', 003, 'dena', 'Gateway') result FROM banks;

decode(
bank_id, 
001, 'SBI', 
002, 'ICICI', 
003, 'dena', 
'Gateway')

IF bank_id = 001 THEN
   result := 'SBI';
 
ELSIF bank_id = 002 THEN
   result := 'ICICI';
 
ELSIF bank_id = 003 THEN
   result := 'Dena';
 
ELSE
   result := 'Gateway';
 
END IF;