- Queries With Pl Sql Question 1 Show The Details About Employee Id 101 Answer Declare Eid Employees Employee Id Type 1 (117.74 KiB) Viewed 68 times
- Queries With Pl Sql Question 1 Show The Details About Employee Id 101 Answer Declare Eid Employees Employee Id Type 2 (117.74 KiB) Viewed 68 times
- Queries With Pl Sql Question 1 Show The Details About Employee Id 101 Answer Declare Eid Employees Employee Id Type 3 (117.74 KiB) Viewed 68 times
QUERIES WITH PL/SQL Question-1: Show the details about employee id 101. Answer: DECLARE Eid employees.EMPLOYEE_ID%type; Ename employees.EMPLOYEE_NAME%type; Eaddress employees.EMPLOYEE_ADDRESS%type; Eemail employees.EMAIL%type; Ephone employees.PHONE%type; Esalary employees.SALARY%type; BEGIN SELECT EMPLOYEE_ID, EMPLOYEE_NAME, EMPLOYEE_ADDRESS,EMAIL,PHONE,SALARY INTO Eid, Ename, Eaddress, Eemail,Ephone,Esalary FROM employees WHERE employee_id ='101'; dbms_output.put_line('Details of the employee 101 is: '); dbms_output.put_line('ID : 'Eid); dbms_output.put_line('NAME: '|| Ename); dbms_output.put_line('ADDRESS : '|| Eaddress); dbms_output.put_line('EMAIL : '| Eemail); dbms_output.put_line('PHONE :|Ephone); dbms_output.put_line('SALARY : ' Esalary); END; :
QUERIES WITH PL/SQL Question-1: Show the details about employee id 101. Answer: DECLARE Eid employees.EMPLOYEE_ID%type; Ename employees.EMPLOYEE_NAME%type; Eaddress employees.EMPLOYEE_ADDRESS%type; Eemail employees.EMAIL%type; Ephone employees.PHONE%type; Esalary employees.SALARY%type; BEGIN SELECT EMPLOYEE_ID, EMPLOYEE_NAME, EMPLOYEE_ADDRESS,EMAIL,PHONE,SALARY INTO Eid, Ename, Eaddress, Eemail,Ephone,Esalary FROM employees WHERE employee_id ='101'; dbms_output.put_line('Details of the employee 101 is: '); dbms_output.put_line('ID : 'Eid); dbms_output.put_line('NAME: '|| Ename); dbms_output.put_line('ADDRESS : '|| Eaddress); dbms_output.put_line('EMAIL : '| Eemail); dbms_output.put_line('PHONE :|Ephone); dbms_output.put_line('SALARY : ' Esalary); END; :