DBMS seems to show me values that are replaced with # symbol. Below would be my record and the records that i was planning to retrive data from. The picture attached would be output from DBMS.
ACCEPT Worker_ID PROMPT 'PLEASE ENTER YOUR WORKER ID HERE: '
COLUMN Worker_ID FORMAT A4
COLUMN W_First_Name FORMAT A10
COLUMN W_Last_Name FORMAT A20
COLUMN W_Age FORMAT A2
COLUMN Salary FORMAT A10
COLUMN section_ID FORMAT A2
COLUMN section_Name FORMAT A12
TTITLE CENTER 'Worker's Basic Information & His/Her Section' SKIP 2;
SELECT w.Worker_ID, w.W_First_Name, w.W_Last_Name, w.W_Age, w.Salary, s.section_ID, s.section_Name
FROM Worker w JOIN Section s ON (w.Section_ID = s.section_ID)
WHERE w.Worker_ID = '&Worker_ID';
insert into Worker (Worker_ID, section_ID, W_First_Name, W_Last_Name,
W_Gender, W_Age, Date_of_Employment, W_Email, W_Phone_Num, Salary)
values (1152, 1, ‘Sidoney’, ‘Teenan’, ‘F’, 38, ’08-Feb-2014′,
‘[email protected]’, 601797286126, 29721);INSERT INTO Section VALUES(1, ‘Pilot’, ‘Pilots ensure safe flights,
navigate, and communicate.’);