OraFAQ Forum: Client Tools » INSERT INTO with GUI

Home » Other » Client Tools » INSERT INTO with GUI - insert record greyed out (Toad 10.5.1.3)

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

INSERT INTO with GUI - insert record greyed out [message #599652]

Mon, 28 October 2013 01:11

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

Hi

I wish to make this simple statement with Toad GUI

INSERT INTO EXCLUDE_xxx
     VALUES ('xxx',
             'xxx',
             'xxx',
             'xxx',
             SYSDATE);

Insert record is greyed out. Howto insert new rows with Toad (click click)?

Attachment: INSERT_TOAD.JPG
(Size: 96.48KB, Downloaded 1858 times)

Report message to a moderator

Re: INSERT INTO with GUI - insert record greyed out [message #599658 is a reply to message #599652]

Mon, 28 October 2013 01:26

Maaher
Messages: 7065
Registered: December 2001

Senior Member

What kind of object is "exclude_xxx"?

MHE

Report message to a moderator

Re: INSERT INTO with GUI - insert record greyed out [message #599666 is a reply to message #599658]

Mon, 28 October 2013 01:51

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

Senior Member
Account Moderator

I don't see a problem here; SELECT * returned the result, and one of these rows is grey. So what? If it wasn't inserted into EXCLUDE_xxx, it would't be displayed at all.

Report message to a moderator

Re: INSERT INTO with GUI - insert record greyed out [message #599668 is a reply to message #599666]

Mon, 28 October 2013 01:55

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I believe you misread the question, Littlefoot: the OP wants to use the "plus" sign to insert a new record. Does this work:

Select rowid
     , os_fqdn
     , os_os
     , application
     , engineer_user_id
     , created
From   <yourtable>

MHE

Report message to a moderator

Re: INSERT INTO with GUI - insert record greyed out [message #599675 is a reply to message #599668]

Mon, 28 October 2013 02:21

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

Senior Member
Account Moderator

Obviously, I misread it; I *think* I understand it now, though: I wouldn't insert data in "Data grid" part of the "Editor" window - try with "Schema browser" instead.

/forum/fa/11208/0/

Attachment: toad_insert.png
(Size: 18.08KB, Downloaded 3137 times)

[Updated on: Mon, 28 October 2013 02:23]

Report message to a moderator

Re: INSERT INTO with GUI - insert record greyed out [message #599676 is a reply to message #599658]

Mon, 28 October 2013 02:22

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

Maaher wrote on Mon, 28 October 2013 01:26

What kind of object is "exclude_xxx"?

MHE

CREATE TABLE ESSDB.exclude_xxx
(
  OS_FQDN           VARCHAR2(120 BYTE),
  OS_OS             VARCHAR2(60 BYTE),
  APPLICATION       VARCHAR2(60 BYTE),
  ENGINEER_USER_ID  VARCHAR2(20 BYTE),
  CREATED           DATE                        DEFAULT sysdate
)

Report message to a moderator

Re: INSERT INTO with GUI - insert record greyed out [message #599678 is a reply to message #599668]

Mon, 28 October 2013 02:24

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

Maaher wrote on Mon, 28 October 2013 01:55

I believe you misread the question, Littlefoot: the OP wants to use the "plus" sign to insert a new record. Does this work:
Select rowid
     , os_fqdn
     , os_os
     , application
     , engineer_user_id
     , created
From   <yourtable>
MHE

thank you. That works. Is there an easier solution?

Report message to a moderator

Re: INSERT INTO with GUI - insert record greyed out [message #599679 is a reply to message #599675]

Mon, 28 October 2013 02:27

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

Littlefoot wrote on Mon, 28 October 2013 02:21

Obviously, I misread it; I *think* I understand it now, though: I wouldn't insert data in "Data grid" part of the "Editor" window - try with "Schema browser" instead.

thank you. Perfect

Report message to a moderator

Re: INSERT INTO with GUI - insert record greyed out [message #603564 is a reply to message #599652]

Tue, 17 December 2013 06:49

gauravgautam135
Messages: 33
Registered: December 2013

Member

rc3d wrote on Mon, 28 October 2013 01:11

Hi

I wish to make this simple statement with Toad GUI
INSERT INTO EXCLUDE_xxx
     VALUES ('xxx',
             'xxx',
             'xxx',
             'xxx',
             SYSDATE);
Insert record is greyed out. Howto insert new rows with Toad (click click)?

If you are looking into inserting data in any of your table in TOAD via click procedure:

You can write down your table in editor and press F4 to open table structure. There click "data" tab to see your data and then "+" plus sign there to insert new row.

Or you have large number of column and your new row is different in only one column from existing one, then you can select that existing row from data tab and then right click there. Choose "Duplicate Row" there. Change your desired column of duplicate row.

Note: Please maintain primary key definition while doing this.

Report message to a moderator

Previous Topic:	Setting of ORACLE_HOME & SID
Next Topic:	package

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 11 22:43:23 CDT 2024