Stack Overflow
Stack Overflow

Questions tagged [toad]

Toad is a database query tool from Quest Software. There are versions of Toad that can query Oracle, SQL Server, MySQL, PostgreSQL and more. It provides query editing & reporting, debuggers, performance analyzers and many other tools.

Toad is a database query tool from Quest Software. There are versions of Toad that can query Oracle, SQL Server, MySQL, PostgreSQL and more. It provides query editing & reporting, debuggers, performance analyzers and many other tools.

This tag should be used for questions regarding how to use Toad software.

1263 questions
-4
votes
1 answer

ORA-00907: missing right parenthesis when create table in toad

CREATE TABLE USERMASTER ( UserId NVARCHAR(30) NOT NULL PRIMARY KEY, UserPwd NVARCHAR(30) NOT NULL, UserName NVARCHAR(50), UserPosition NVARCHAR(30), UserAccessRights NVARCHAR(30), UserStatus integer(10), CreateDate…
Lst Patrick
  • 123
  • 6
  • 19
-5
votes
5 answers

how do i add or insert multiple rows in two columns, at the same time?

how do i add or insert multiple rows in two columns, at the same time? i am trying this insert into Gwish_bal(Account_code,Flag) values ( ('10192885','I'), ('10146883','I') ); and it is not working i keep getting ORA-00907: missing right…
J.Mike1914
  • 21
  • 2
-7
votes
2 answers

Convert Update statement to select statement

I'm struggling to convert the following update statement to a select statement. I am hoping you can help provide some tips on how to convert this. UPDATE inventory_part_tab SET planner_buyer = (SELECT hb.buyer_code FROM…
SolerPower
  • 23
  • 2
  • 6
1 2 3
…
84
85