toad Questions
4
Solved
When I try to insert a value which has '&' in TOAD I get a prompt for a substitution variable.
So when I try:
insert into x values('hello & world');
it throws a prompt for substituting...
9
Solved
I tried to execute an SQL INSERT with Toad for oracle:
INSERT INTO GRAT_ACTIVITY
(UUID, IP_ADRESS, SEND_MAIL, DATE_CREA, DATE_UPD, CREATOR, CENTER, ETAT, REQUEST)
VALUES('555-vgd9-pllkd-5513', '...
15
Is there a workaround for
'ORA-01795: maximum number of expressions in a list is 1000 error'
I have a query and it is selecting fields based on the value of one field. I am using the in clause and ...
10
Solved
I use TOAD 10.2.1.3 under Windows7 and get the following error:
Cannot find OCI DLL: C:\Oracle\Product\11.2.0\oci.dll
that is strange because exact in the same path I can find oci.dll.
That is 6...
7
Solved
Whenever I read a csv file in R (read.csv("file_name.csv")) that was exported using toad, the first column name is preceded by the following characters "ï..". Also, opening the csv file in excel or...
4
Solved
I need to search through all of the stored procedures in an Oracle database using TOAD. I am looking for anywhere that the developers used MAX + 1 instead of the NEXTVAL on the sequence to get the ...
Meerschaum asked 17/2, 2011 at 19:48
6
Solved
My question is based on:
Finding table with two column names
If interested, please read the above as it covers much ground that I will not repeat here.
For the answer given, I commented as follows:...
11
How can I get the scripts of Stored procedures, Views, Functions, Triggers in toad for oracle?
3
Solved
How can I change the color of TOAD data grid? It seems that I have changed it somehow by mistake and I can not find a way to revert the colors to original one. This is a sample of color that I am c...
Honig asked 12/3, 2014 at 18:43
5
Solved
I am using toad for oracle client.
In which the session disconnects after some time.
How to make it enabled at all time.
5
Solved
I have a SQL script that is being executed in TOAD. Currently, I have it laid out with just statement after statement, thusly:
select such-and-such from somewhere;
delete other-thing from somewhe...
9
Solved
I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error:
ORA-12170: TNS:Connect timeout occurred
What are the possible reasons why I kept on...
7
I'm using Toad 8.6 and when I try to add new records using the Schema Browser, Data tab, my 'insert record' is grayed out. So, I installed the 9.6 version and the same problem persists.
See the gr...
Impressive asked 25/9, 2009 at 9:12
10
Solved
I have some 800-1200 INSERT statements generated from an excel sheet. I want to run these in TOAD - Oracle db.
If I press F9, it runs only one line and F5 gives me syntax issue and do not seem to ...
3
I am using Oracle 11g with Toad 12.5.1.1 and the output grid only shows me 500 rows at a time.
Is there a way to make toad display all the results at a time or is there a way to find the number of...
Sthilaire asked 13/11, 2014 at 21:28
4
Solved
This code compiles, but in TOAD it won't show the "hi wo" output
CREATE OR REPLACE PROCEDURE AdelTest IS
tmpVar NUMBER;
BEGIN
DBMS_OUTPUT.ENABLE(100: in INTEGER);
DBMS_OUTPUT.PUT_LINE('hi wo')...
2
I have a defined a new stored procedure but get a error while calling it,
CREATE OR REPLACE PROCEDURE SCOTT.getempsal(
p_emp_id IN NUMBER,
p_emp_month IN CHAR,
p_emp_sal OUT INTEGER)
AS
BEGIN
...
Jiffy asked 1/2, 2013 at 4:12
1
We want to get some missing functionality into Toad for Oracle. The goal is to add a menu entry that allows to access and modify the text in the editor.
Is there some documented plugin interface (...
3
Solved
I've been creating packages for Oracle db using PL/SQL and i'm trying to find a good way to debug a PL/SQL package without using the "put_line" command, does anyone have some good tips on how to su...
6
I want to move to a new PC and take my Toad connections with me because I have a few and don't want to retype them all.
5
Solved
I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from PSASOFDATE; returns 11/15/2012, but I want only 2012. How can I get only the year? I know the YE...
Crinkle asked 19/11, 2012 at 14:6
4
Solved
On the DBMS Output window for Toad v11, how can you change the DBMS Output font and color? I've looked all over in the options but I'm unable to find where it's possible it change this. It's way to...
Bijouterie asked 15/3, 2012 at 16:24
3
Solved
I installed both the 32 and 64-bit Oracle 11g drivers. I search my PC looking for files with the name "tnsnames.ora" and found 3 in the following locations:
1. C:\Oracle\product\11203_32bit\CLIENT...
11
Solved
I have a problem with TOAD for Oracle 9.1 running on Windows 7 32-bit, described as follows:
I have Oracle OraClient10g 10.0.2 installed on my PC, and I need to use Toad 9.1. When I try to log int...
4
Solved
In toad's older version i can easily able to format the query in
Toad's Query editor by
right click > Format Code.
But in newer version of Toad 7 i can't able to find this Format option. ...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.