I have a Java application running against an Oracle 9i database. The database has a trigger to create an audit record, which tracks changes to the base record. The trigger utilizes current_timestamp. When I modify the base record with the Java application, the audit record reflects GMT. However, if I use Toad and update the base reco...
How can I get the scripts of Stored procedures, Views, Functions, Triggers in toad for oracle? ...
Hi, We are planning to migrate our DB to Oracle.We need to manually check each of the embedded SQL is working in Oracle as few may follow different SQL rules.Now my need is very simple. I need to browse through a file which may contain queries like this. String sql = "select * from test where name="+test+"and age="+age; There are near...
Im sure this is pretty simple but I just cant seem to find the option. My Toad MySql install only seems to allow me to have one "Viewer" window open and hence its impossible to view multiple tables - or have a window open for each table Im working with. Does anyone know how to change this? ...
I created the global temp table. when I execute the code as an individual scripts it works fine. but when I execute it as a single script in TOAD then no record was created. there was just an empty global temp table. eg. CREATE GLOBAL TEMPORARY TABLE TEMP_TRAN ( COL1 NUMBER(9), COL2 VARCHAR2(30), COL3 DATE ) ON COMMIT PRESERVE ROWS / ...
Hi, below is the stored proc I wrote: create or replace procedure test005 as begin CREATE GLOBAL TEMPORARY TABLE TEMP_TRAN ( COL1 NUMBER(9), COL2 VARCHAR2(30), COL3 DATE ) ON COMMIT PRESERVE ROWS / INSERT INTO TEMP_TRAN VALUES(1,'D',sysdate); INSERT INTO TEMP_TRAN VALUES(2,'I',sysdate); INSERT INTO TEMP_TRAN VALUES(3,'s',sy...
sqlplus command line utility is working fine but i need to copy commands edit them rerun them command prompt is little bit of a hindrance for that matter ..i have downloaded the sql instant client 32 bit and don't know how to proceed further in the installation of it. ...
Hi, I need to figure how much time passed between 2 times. For example: (14:00:00 - 13:15:00) * 24 = .75 I need this to later on convert KW to KWh, but that's not the point. I can not find out how to do this in PL/SQL. My date/time fields look like this in the DB: 1/23/2010 21:00:00 I would appreciate any suggestions. Steve ...
I have a function that takes as one of it's arguments a VARRAY of pl/sql Objects. How do I execute this stored procedure and bind the resultset that it returns to a data grid in TOAD for Oracle? ...
I'm looking for a way to export saved usernames/passwords from Toad for Oracle (9.5.0.31). It doesn't have to be in a usable format for importing - even a plaintext format would be fine. I believe the passwords are stored encrypted in CONNECTIONPWDS.INI, but from what I've read, that file doesn't transfer from one machine to another. ...
On TOAD for oracle, there is a bar at the bottom where your active windows (be it an sql editor, schema browser or SQL modeller window) are displayed. I have just moved office and it now only displays the active window and none of the other windows... any of you toad guru's know how to get it to display all the windows? Toad version 7....
I create tables with using TOAD Create Table GUI. I want to create autoincrement key. I don't want to write sql of it. Is there any way to do this on GUI screen? ...
I've got an SQL-table with some million entries and I tried to query how much entries are older than 60 days (Oracle 11.2.0.1.0). For this experiment I used 3 different versions of the select-statement: (The cost-value is given by TOAD for Oracle V. 9.7.2.5) select count(*) from fman_file where dateadded >= (select sysdate - 60 from d...
Is there a way in TOAD or some other tool to monitor queries being executed by your web app? I'd like to examine the explain/execution plans for the web app queries. I'm debugging why the webapp queries are slower than when run from sqlplus. ...
How to connect to MySQl db on linux server using toad? what i should give on host? i get the error Can't connect to MySQL server on 'tinywall' (10061) ...
Heyho, I've gotta write a Procedure which Inserts a resultset from a select-statement into a table. A co-worker of mine did something similar before to copy values from one table to another. His statement looks like this: CREATE OR REPLACE PROCEDURE Co-Worker( pId IN INT ) AS BEGIN INSERT INTO Table1_PROCESSED SELECT * FROM...
Heyho, I'm trying to set a Procedure like: Create or Replace Procedure MyProcedure1( x in number default 1, y in number default 1 ) AS Begin If x = 1 then MyProcedure2; EndIf; If y = 1 then MyProcedure3 EndIf; End MyProcedure1; MyProcedure3 must be done after MyProcedure2 is completely done, because it needs some values which are set...
We have a table with a 'price' field of type NUMBER(20,7).. In TOAD I do this: update mytable set price = 1234567890123.1234567; Then I do this select: select price, to_char(price) from mytable PRICE TO_CHAR(PRICE) 1234567890123.12 "1234567890123.1234567" Question is, why does TOAD truncate the result when displayi...
Hey folks, I've got this procedure: CREATE OR REPLACE PROCEDURE CONV1( pDate IN VARCHAR2, pYear OUT number, pMonth OUT number, pDay OUT number ) AS lDate DATE; BEGIN lDate := to_date(pDate, 'DD.MM.YYYY HH24:MI:SS'); pYear := to_number(to_char(lDate, 'YYYY')); pMonth := to_number(to_char(lDate, 'M...
I've got a table like this: ID | Val1 | Val2 --------------------- 1 | 1 | 2 2 | 1 | 3 3 | 2 | 1 4 | 2 | 3 5 | 3 | 1 6 | 3 | 2 now my problem is, that 1 - 2 means the same like 2 - 1 (look @ ID 1 and ID 3 for example) and I want to eliminate all entries where value 1 - value 2 ...