toad_开发者

Is it possible to write a java program from TOAD?

I am using TOAD for ORACLE application. I am playing around with data and tables. My manager has asked me to experiment if one can write a Java program from TOAD.[详细]

2023-04-12 10:26 分类：问答

SQL- Identify nullable values

I am relatively new to SQL queries. I 开发者_如何学运维have a large number of tables in my SQL Database ( over 1500 )[详细]

2023-04-09 23:59 分类：问答

Help managing many-to-one results for lookup

I didn\'t see this exactly asked, so I\'m hoping it wasn\'t. I have a table that has multiple columns with code variables and a table that has all lookup codes and de开发者_StackOverflow中文版script[详细]

2023-04-06 22:15 分类：问答

Oracle: interpreting Toad "Session Browser" data

It\'s composed by the following information: IO Waits Current Statement (explain plan) Open Cursor Access[详细]

2023-03-29 11:17 分类：问答

Toad for MySQL connection problems (Win 7 to Linux)

I have a MySQL instance running on a Linux box, and a Mac which also has Win7 (Bootcamp/VMWare)开发者_开发技巧. I can connect to the MySQL db from Navcat Lite for Mac with no problems, however, I pref[详细]

2023-03-28 12:23 分类：问答

How to get information about compile error in Oracle/TOAD

I\'m using TOAD to develop a stored function in an Oracle database. When I click the \"run as script\" button in TOAD, it tells me that the script was executed with 0 errors and 1 compile errors. Wher[详细]

2023-03-27 06:49 分类：问答

Debug DB2 stored proc

I am using IBM DB2 with Toad. I have a stored procedure that I need to debug.Any tutorial or videos on how to debug a stored procedure ? Echo statement won\'t work. One way would be to create a temp t[详细]

2023-03-21 10:31 分类：问答

Undesirable Double Quotes When Exporting a Tab Delimited File

When I export my SQL results into a tab delimited file, double quotes surround ahandful of my records. I don\'t know why this is. I am assuming it is because some of the record names have a special ch[详细]

2023-03-19 14:15 分类：问答

Toad not connecting to mysql remote server

I am using Toad on my windows machine to connect to mysql on the remote ubuntu linux server. And it is not connecting it. It says \"Can\'t connect to SSH server on \'\': No connection could be made be[详细]

2023-03-19 14:03 分类：问答