Re: Insert command
Date: Fri, 19 Aug 2011 17:53:07 +0200
On 19.08.2011 15:58, Tim Slattery wrote:
> We're in the midst of converting a system from Sybase to Oracle. This
> involves converting Sybase stored procedures to Oracle procedures and
> We have a Sybase SP that inserts a line into a table. The syntax of
> the "insert" statement is:
> insert into cases
> values(_at_ldbNumber, @num, @submission)
> The actual values list is much longer, but the interesting thing is
> that there is no list of columns. Apparently this is legal in Sybase.
This could even be standard SQL.
> When I run this insert statement in Oracle SQLDeveloper, I get
> ORA-00936: Missing Expression. Is this because there is no list of
> columns? Is that list required in Oracle but not in Sybase?
Wrote file afiedt.buf
1* create table cases ( a number(10), b number(20) ) SQL> / Table created.
SQL> insert into cases values (1, 2);
1 row created.
SQL> select * from cases;
Btw, this behavior is documented
Did you remove the at signs in the Oracle version of the SP?
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Fri Aug 19 2011 - 10:53:07 CDT