Home » SQL & PL/SQL » Client Tools » INSERT INTO with GUI - insert record greyed out (Toad 10.5.1.3)
INSERT INTO with GUI - insert record greyed out [message #599652] Mon, 28 October 2013 01:11 Go to next message
rc3d
Messages: 171
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)?
Re: INSERT INTO with GUI - insert record greyed out [message #599658 is a reply to message #599652] Mon, 28 October 2013 01:26 Go to previous messageGo to next message
Maaher
Messages: 7041
Registered: December 2001
Senior Member
What kind of object is "exclude_xxx"?

MHE
Re: INSERT INTO with GUI - insert record greyed out [message #599666 is a reply to message #599658] Mon, 28 October 2013 01:51 Go to previous messageGo to next message
Littlefoot
Messages: 19335
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.
Re: INSERT INTO with GUI - insert record greyed out [message #599668 is a reply to message #599666] Mon, 28 October 2013 01:55 Go to previous messageGo to next message
Maaher
Messages: 7041
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
Re: INSERT INTO with GUI - insert record greyed out [message #599675 is a reply to message #599668] Mon, 28 October 2013 02:21 Go to previous messageGo to next message
Littlefoot
Messages: 19335
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.

./fa/11208/0/

[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 Go to previous messageGo to next message
rc3d
Messages: 171
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
)
Re: INSERT INTO with GUI - insert record greyed out [message #599678 is a reply to message #599668] Mon, 28 October 2013 02:24 Go to previous messageGo to next message
rc3d
Messages: 171
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?
Re: INSERT INTO with GUI - insert record greyed out [message #599679 is a reply to message #599675] Mon, 28 October 2013 02:27 Go to previous messageGo to next message
rc3d
Messages: 171
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.

./fa/11208/0/


thank you. Perfect
Re: INSERT INTO with GUI - insert record greyed out [message #603564 is a reply to message #599652] Tue, 17 December 2013 06:49 Go to previous message
gauravgautam135
Messages: 31
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.
Previous Topic: Setting of ORACLE_HOME & SID
Next Topic: package
Goto Forum:
  


Current Time: Wed Jul 30 22:20:59 CDT 2014

Total time taken to generate the page: 0.09183 seconds