— toad 12.5.0.84
create sequence s;
CREATE TABLE t
( x INT DEFAULT s.NEXTVAL PRIMARY KEY,
y VARCHAR2 (30));
insert
into t ( x,y ) values ( default,‘Hello’ );
– the above blows toad oout of the water.
– works great in sqlplus
It works fine for me. Can you be more specific what happens when you try it?
Wonder if 12.5.0.90 which has a newer drop of the parser and is why it works ???
It’s possible. My qp5.dll is dated 4/6/2014.
This parses and formats fine since at least the beginning of 2013 (5.249).
After bombing out and restarting toad, it has not happened again.
J
From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Sent: Wednesday, May 21, 2014 16:01
To: toadoraclebeta@toadworld.com
Subject: RE: [Toad for Oracle - Beta Discussion Forum] problem in 12c with default keyword in insert
RE: problem in 12c with default keyword in insert
Reply by John Dorlon
It works fine for me. Can you be more specific what happens when you try it?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag
this post as spam/abuse.
The information contained in this e-mail and in any attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. This message has been scanned for known computer viruses.