script:
set feedback on sql_id
select * From employees
where employee_id = 100;
run as a script
version : 25.3.2
set feedback on sql_id
select * From employees
where employee_id = 100;
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DAT JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- ------------------------- ------------------------- -------------------- -------- ---------- ---------- -------------- ---------- -------------
100 Steven King SKING 515.123.4567 03/06/17 AD_PRES 24000 90
1 row selected.
SQL_ID: amkqwss9x7mad
version: 25.4.0 and newer:
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DAT JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID----------- -------------------- ------------------------- ------------------------- -------------------- -------- ---------- ---------- -------------- ---------- ------------- 100 Steven King SKING 515.123.4567 03/06/17 AD_PRES 24000 90
