Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE emp;
- CREATE TABLE emp AS SELECT * FROM employees;
- ALTER TABLE emp ADD stars VARCHAR2(50);
- Set Serveroutput on
- Declare
- Asterisk emp.stars%type:=NULL;
- Sal emp.salary%type;
- empno emp.employee_id%TYPE:=NULL;
- salarys emp.salary%Type;
- Begin
- Select employee_id, round (salary/1000), stars, salary
- into empno, Sal , Asterisk,salarys
- From emp
- Where employee_id=176;
- for i in 1..50 loop
- if Sal = i and i between 1 and 9
- then
- update emp set stars =substr(lpad (Sal,i+1,'*'),1,i);
- elsif Sal=i and i between 10 and 50
- then
- update emp set stars =substr (lpad(Sal,i+2,'*'),1,i);
- end if;
- end loop;
- commit;
- end;
- /
- Select employee_id, salary, stars
- From emp
- Where employee_id=176
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement