I've got a query string, such as 'select * from TABLENAME', or a 'select a.* from TableA a, TableB b where a.id = b.id'.
If I create a Record Group based on that query string, is there a way ...
I am using Toad Version 7.3.0
I am always getting the error, "ORA-01460: unimplemented or unreasonable conversion requested"
How can I eliminate this and export data from tables.
I'm trying to set up a 'development' user that can see all tables/views/etc in the production database, but at the same time I'm trying to limit the privileges granted to this user. The way I...
I want to insert SYSDATE in to a DATE field when ever there is an insert or update, can some one tell me the best method to do that
Does anyone knows of a freeware tool for SQL Optimization like TOAD Quest SQL OPTIMIZER.
My main database is Oracle 9i
Thanks in advance
I have tried a lot to fix this, but not much has seemed to work. I am working with TOAD on an Oracle database server. I believe it is version 8 or 9. My freeware version of TOAD expired. I was...
In TOAD's SQL Editor, can I force a query timeout or do a pause or break in a query I'm trying to run if it takes too long? I'm trying to stop queries that take too long without having to CTR...
I am using TOAD to connect to an Oracle 8.5 instance. TOAD has been working like a charm, until a few days ago when I must have been pressing on a button somewhere by mistake, and now in the S...
I have a cursor in a report that needs to rank the results per column. My column is a variable supplied by the user. The code is as follows...
DECLARE
v_srt_by1 varchar2(12) := n...
my coworkers and i are absolutely stumped on this one. we had a table in existence for over a year that we performed the same PL/SQL procedure on many times. recently we added two new column...
Hello, could someone help me and tell if there is a possibility to set records (also can be blocks), but in fact all records displayed in oracle form doesn't matter how many related data block...
Hi expert,
I have a database on an Oracle 8 server. Now I want to do a BASIC request using Oracle SQL*Plus Version 8.0.5.0.0 on my PC (Win2K). Here the query:
SELECT FP.EMPL_EXPERIENCE...
I have following coed. It compiles but at runtime it gives me:
FRM-30085
Unable to adjust form for output.
My code:
declear
b_copy boolean;
Begin
b_copy := WebUtil_File.Copy_File('c...
Is there a way to export few tables into separated delimited files using Toad using a single script? I do not want to use the export data in toad as i would have to export a few times dependin...
I get the following error 'Multiple-step operation generated errors. Check each status value.' when trying to read a date field from a recordset. The data has been selected from an Oracle dat...
HI,
I want to upload data from .xls file to a database table. I am using Oracle 8i.
The .xls file is in Office 2000 format.
What are the different ways of uploading the file. I kn...
I am just getting started with PL/SQL Developer, and I have just loaded Oracle Personal 9i.
I have a lot of past experience with Oracle but not sure how to get the engine running.
I'm mo...
I was trying to insert data from a XML file into oracle table using XSU. Can any one give any tips or pointers for this?
-------------------------------------------------------
I'm using t...
Hi all..
need help for frm-40200
I executed query using do_key('execute_query) in oracle form.
after it display the value, I need to create a button that allows update the items.
But it ...
I want to pass the database schema name to my script that creates a package, how can I do this...?
Thanks Ian
I WORK TO DO NEXT IN A ORACLE 8.1.6 RELEASE RUNNING IN HP-UX VIA SQLPLUS:
ALTER USER COON0MTR IDENTIFIED BY PRUEBA;
AND THE SYSTEMS ANSWERS:
alter user coon0mtr identified by prueba
*
...
Hi,
i'm using Oracle Forms Builder 6i to connect to mySQL 3.23.49 via
Oracle Open Client Adapter for ODBC 6.0.5.35.0
Now I have a problem of controlling which form to commit if more tha...
Hey Guys -
I have a varchar2 I am doing concatenation on. It's declared as
aTemp VARCHAR2(9000);
After repeated concatenations such as...
aTemp := aTemp || 'something';
aTemp :=...
TOAD Sql Monitor for Oracle, latest version, throws exception "Error 2 installing monitor for the service process" during connection to any service. Turning on the logging does not help - n...
i have a q: in sql*loader in TOAD
i have comma delimited text file like this with first row as column headings
aNo, fn, ln, dno,
1,e,f,10
2,r,g,90
my table columns in in oracle ar...
