Hi,
In Oracle(sql) I have created a table "empl" as
sql>create table empl(
2 empno number(6),
3 empname varchar2(10),
4 location varchar2(10)
5 );
The description of the table is like this
sql>desc empl;
Name Null? Type
----------------------------- -------- ----------
EMPNO NUMBER(6)
EMPNAME VARCHAR2(10)
LOCATION VARCHAR2(10)
Now when I am trying to insert the values(multiple rows continuosly with /) I tried the following statement which I think is correct.
sql> insert into empl values(
2 &empno,'&empname',&location');
but here it is giving an error saying
SP2-0552: Bind variable "EMPNO" not declared.
Correct me if I am wrong.
And when I am inserting single row with this statement
sql> insert into empl values(1234,'Name','India');
1 row created.
It is fine.
Please throw some light on this.
In Oracle(sql) I have created a table "empl" as
sql>create table empl(
2 empno number(6),
3 empname varchar2(10),
4 location varchar2(10)
5 );
The description of the table is like this
sql>desc empl;
Name Null? Type
----------------------------- -------- ----------
EMPNO NUMBER(6)
EMPNAME VARCHAR2(10)
LOCATION VARCHAR2(10)
Now when I am trying to insert the values(multiple rows continuosly with /) I tried the following statement which I think is correct.
sql> insert into empl values(
2 &empno,'&empname',&location');
but here it is giving an error saying
SP2-0552: Bind variable "EMPNO" not declared.
Correct me if I am wrong.
And when I am inserting single row with this statement
sql> insert into empl values(1234,'Name','India');
1 row created.
It is fine.
Please throw some light on this.