Have a look at LPAD

-

LPAD

 Syntax: LPAD( var, padded_length ,x )

 Parameters:
var -> String/Date Type/Number
x -> String/Date Type/Number

 Return Type: String Value

 Use Case
(i) If manager wants to know the salary of the employee in the neat format.


 select first_name,lpad(salary,5,'*') from employees;

(ii) If the manager is interested in knowing the initials of the countries in which its organization has presence.
select lpad(upper(country_name),2) from countries;


Comments

Post a Comment

Popular posts from this blog

Let's learn Right Outer Join!

-
Image
RIGHT OUTER JOIN (i)  HR Manager wants all the employees’ details regardless of whether they have past Job-history or not. If employee has a job-history then manager also wants job-history details. Manager to data analyst: Bring me the details of employees along with the details of their job history if employee has one. Data analyst runs below query to fetch the required data. SELECT * FROM JOB_HISTORY JH RIGHT OUTER JOIN EMPLOYEES E ON E.EMPLOYEE_ID= JH.EMPLOYEE_ID;   (ii) HR manager wants details of departments regardless of department having manager or not. If department has manager then HR manager also wants the details of manager.  Manager to data analyst:  Bring me the details of departments along with the details of manager of the department. Data analyst runs below query to fetch the required data. SELECT * FROM EMPLOYEES E RIGHT OUTER JOIN DEPARTMENTS D ON D.MANAGER_ID= E.EMPLOYEE_ID;
Read more

Let's learn Cross Join!

-
Image
CROSS JOIN HR manager to data analyst: Bring me the every possible combination of department ids and job ids along with the details for both. Data analyst runs below query to fetch the data.  SELECT * FROM DEPARTMENTS, JOBS; 
Read more

Learning the Natural Join

-
Image
NATURAL JOIN Usage:  HR Manager to data analyst: Bring me the details of employees and the details of corresponding departments. Data analyst runs below query to fetch the required data. SELECT * FROM EMPLOYEES NATURAL JOIN DEPARTMENTS;
Read more