| Syntax [message #10533] |
Wed, 28 January 2004 20:59  |
Shashikant R.
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
|
if semicolon is missing in an insert statement within a script , does oracle give error or it ignores it ?
|
|
|
|
| Re: Syntax [message #10536 is a reply to message #10533] |
Wed, 28 January 2004 22:27  |
resy
Messages: 86
Registered: December 2003
|
Member |
|
|
No.
if it is inside a script
there is no need of semicolon, instead the last line of
the statement should be '/'
for eg:
test.sql
insert into supplier
values('22','dffd','dfdf')
/
insert into supplier
values('33','dffd','dfdf')
/
if im executing this
SQL> @test.sql
1 row created.
1 row created.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
