-
could someone take a look at this script and see what i may have missed. I keep getting an error. I'm in school now for dba.
SET ECHO OFF
SET VERIFY OFF
ACCEPT PID PROMPT 'PLEASE ENTER THE EMPLOYEE''S ID #: '
ACCEPT PLN PROMPT 'PLEASE ENTER THE EMPLOYEE''S LAST NAME: '
ACCEPT PFN PROMPT 'PLEASE ENTER THE EMPLOYEE''S FIRST NAME: '
ACCEPT PS PROMPT 'PLEASE ENTER THE EMPLOYEE''S SALARY: '
INSERT INTO MY_EMPLOYEE
VALUES (&PID, '&PLN', '&PFN', LOWER(SUBSTR('&PFN',1,1) || SUBSTR('&PLN',1,15)), &PS);
SET VERIFY ON
SET ECHO ON
-
check whether the number of columns in your table (my_EMPLOYEE ) is 5, if not write the DML as
Insert into my_employee (col1, col2, col3, col4, col5) values (val1, val2, val3, val4, val5) ;
If this is not the case, post the error message.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|