OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » INSERT INTO

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

INSERT INTO [message #213441]

Wed, 10 January 2007 15:47

pradkuamr
Messages: 29
Registered: November 2006

Junior Member

Hi

I am trying to insert a record into a table which is already populated. When I ran

insert into TABLE(BEGIN_DT,END_DT,CREATE_DT,VERSION_DT,LAST_UPDATE_DT) VALUES (SYSDATE,SYSDATE, SYSDATE, SYSDATE, SYSDATE)

it is highlighting on INSERT word

Report message to a moderator

Re: INSERT INTO [message #213443 is a reply to message #213441]

Wed, 10 January 2007 15:58

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Specify your insert as:

insert into <table_name> (BEGIN_DT,END_DT,CREATE_DT,VERSION_DT,LAST_UPDATE_DT)
 VALUES (SYSDATE,SYSDATE, SYSDATE, SYSDATE, SYSDATE);

Report message to a moderator

Re: INSERT INTO [message #213444 is a reply to message #213443]

Wed, 10 January 2007 16:03

pradkuamr
Messages: 29
Registered: November 2006

Junior Member

Its still highlighting Insert when I run it in TOAD

Report message to a moderator

Re: INSERT INTO [message #213446 is a reply to message #213444]

Wed, 10 January 2007 16:10

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You need to replace <table_name> with the actual name of your table. For example,

insert into mytable (BEGIN_DT,END_DT,CREATE_DT,VERSION_DT,LAST_UPDATE_DT)
 VALUES (SYSDATE,SYSDATE, SYSDATE, SYSDATE, SYSDATE);

Report message to a moderator

Re: INSERT INTO [message #213447 is a reply to message #213446]

Wed, 10 January 2007 16:12

pradkuamr
Messages: 29
Registered: November 2006

Junior Member

Hi

I did it already..still its highliting on INSERT
Just to remind you The table is already having some data

Report message to a moderator

Re: INSERT INTO [message #213448 is a reply to message #213447]

Wed, 10 January 2007 16:14

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Can you post the error message that you are receiving? The fact that the table already has rows in it is not an issue.

Report message to a moderator

Re: INSERT INTO [message #213450 is a reply to message #213441]

Wed, 10 January 2007 16:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

pradkuamr,
We are NOT standing behind you & can NOT see what you are doing!
Stating that "highlightlighting INSERT" is completely useless to us!
I suggest you stop using TOAD & start using SQL*Plus so you can then actually cut & paste the COMPLETE interaction with Oracle.

Report message to a moderator

Re: INSERT INTO [message #213479 is a reply to message #213450]

Wed, 10 January 2007 23:40

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Allright! Betting office is open!

I bet @OP is violating unique key constraint.

Report message to a moderator

Re: INSERT INTO [message #213487 is a reply to message #213479]

Thu, 11 January 2007 00:14

flyboy
Messages: 1903
Registered: November 2006

Senior Member

Quote:

Betting office is open!

I bet on NOT NULL constraint on column not specified in the INSERT statement.

Report message to a moderator

Re: INSERT INTO [message #213496 is a reply to message #213487]

Thu, 11 January 2007 00:32

Frank
Messages: 7901
Registered: March 2000

Senior Member

My bet will be on an invalid tablename. Extra odds: tablename is "table" or "Table".

Report message to a moderator

Re: INSERT INTO [message #213557 is a reply to message #213496]

Thu, 11 January 2007 04:51

ebrian
Messages: 2794
Registered: April 2006

Senior Member

I've gotta go w/ Frank on this one !

Report message to a moderator

Re: INSERT INTO [message #213559 is a reply to message #213557]

Thu, 11 January 2007 04:56

hari.choprala
Messages: 65
Registered: November 2006
Location: Mumbai

Member

even iam also go w/ Frank on this one !

Report message to a moderator

Re: INSERT INTO [message #213581 is a reply to message #213441]

Thu, 11 January 2007 05:52

Alien
Messages: 292
Registered: June 1999

Senior Member

Quote:

it is highlighting on INSERT word

TOAD does this when it finds the SQL-statement invalid. When the table name is not correct, Toad would highlight the tablename.

My guess is that he is trying to execute it as a single statement while it is not separated from other statements.
There is no ; or / in the original post neither.

Regards,

Arian

Report message to a moderator

Re: INSERT INTO [message #213588 is a reply to message #213581]

Thu, 11 January 2007 06:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Heheheheh! It seems that three of you are about to lose your wager!

Report message to a moderator

Re: INSERT INTO [message #213590 is a reply to message #213588]

Thu, 11 January 2007 06:26

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Ahhhh man...not fair...I'm not a TOAD user.

Guess the next wager needs to be if the OP will actually respond back ??

Report message to a moderator

Re: INSERT INTO [message #213593 is a reply to message #213441]

Thu, 11 January 2007 06:40

Alien
Messages: 292
Registered: June 1999

Senior Member

I bet he does. How else can I win the first bet? Cool

Report message to a moderator

Re: INSERT INTO [message #213597 is a reply to message #213593]

Thu, 11 January 2007 06:55

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

@Alien: your first guess might be a reason, but not the second one. In TOAD, statements don't have to finish with ; or / - <Shift + F9> will run them nonetheless.

So, don't hold your breath (yet)!

Report message to a moderator

Re: INSERT INTO [message #213598 is a reply to message #213581]

Thu, 11 January 2007 06:58

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Alien wrote on Thu, 11 January 2007 12:52

Quote:

it is highlighting on INSERT word

Depends on your settings in TOAD, Mines goes RED Wink

Report message to a moderator

Re: INSERT INTO [message #213600 is a reply to message #213598]

Thu, 11 January 2007 07:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

@tahpush: but that's not the question! So, what do you think, why @OP can't INSERT into his/her table?

Report message to a moderator

Re: INSERT INTO [message #213609 is a reply to message #213600]

Thu, 11 January 2007 07:38

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

i bet LF is right OP ...

Report message to a moderator

Re: INSERT INTO [message #213611 is a reply to message #213609]

Thu, 11 January 2007 07:52

Frank
Messages: 7901
Registered: March 2000

Senior Member

I bet I don't use TOAD, and I'll even raise myself!

Report message to a moderator

Re: INSERT INTO [message #213612 is a reply to message #213609]

Thu, 11 January 2007 07:58

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

His Toad version is read only access Razz

Report message to a moderator

Re: INSERT INTO [message #213629 is a reply to message #213612]

Thu, 11 January 2007 10:15

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Report message to a moderator

Re: INSERT INTO [message #213646 is a reply to message #213479]

Thu, 11 January 2007 12:36

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I don't know TOAD, so it is pure speculation, but maybe OP is just not connected to a database yet.
I am trying to come up with some pretty far fetched ideas as all the good ones are taken already.
I have a bad feeling we may never find the answer.

Report message to a moderator

Re: INSERT INTO [message #213729 is a reply to message #213646]

Fri, 12 January 2007 01:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that I'm fourth one who lost his wager ... inserting SYSDATEs will hardly violate unique key constraint (unless there's a trigger which truncates it).

Flyboy, Alien and Joy Division are the only ones left at the moment.

Report message to a moderator