Write a PL/SQL program with two variables for the first name and the last name. Print the full name with last name and first name separated by comma and a space.

Question

What will be an ideal response?

Answer 1

```
SQL> SET VERIFY OFF
SQL> DECLARE
2 last VARCHAR2(15) := '&s_last';
3 first VARCHAR2(15) := '&s_first';
4 BEGIN
5 DBMS_OUTPUT.PUT_LINE ('Full name: ' || last || ', ' || first);
6 END;
7 /
Enter value for s_last: SHAH
Enter value for s_first: NILESH
Full name: SHAH, NILESH

PL/SQL procedure successfully completed
```