You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Oracle great and have the most points for this month!
NOTE: This forum is for non-product questions and discussions on the Oracle database platform. Please post Toad-family product questions in their respective product forums. Thanks!
Hi, I'm wondering if there is a Linux version of toad, because I'm actually running with wine emulator, but would be very faster and reliable to have a native version of this spectacular database tool
this post as spam/abuse.
I have a function where I have a VARRAY that is a collection of VARRAYs, and Oracle lets me define that. However, I can't figure out how to reference it to get to the values. It appears that the only option for the index is a single integer, which only gets me to one of the "nested" VARRAY nodes, but not into that inner VARRAY to access the value of one of its nodes.Here is the (pared-down) PL/SQL pseudo code. I have a variable that is a straight VARRAY (gv_self), which I am able to use with a simple integer to reference the element I want to fetch. But what is the syntax to access an element of a VARRAY that itself is an element of a VARRAY (gv_base)? I can't find any documentation or code examples that illustrate this and am thinking it can't actually be done:CREATE FUNCTION f_func(parm_c_factor NUMBER)RETURN VARCHAR2 IS xref_desc VARCHAR2(30); TYPE reverses_vv IS VARRAY(2) OF VARCHAR2(30); TYPE line_vr IS VARRAY(2) OF reverses_vv; gv_self reverses_vv := reverses_vv('A', 'B'); gv_base line_vr := line_vr(reverses_vv('C', 'D'), reverses_vv('E', 'F'));BEGIN CASE WHEN x THEN xref_desc := gv_self(parm_c_factor + 1); -- returns 'A' or 'B' WHEN y THEN xref_desc := gv_base(??); -- needs to return 'C', 'D', 'E', or 'F' END CASE; RETURN xref_desc;END;
I don't know very much about Sharepoint but was asked to import data from a site in our organization. I saw a tutorial for SQL server and it mentions putting in the URL under the options to connect to the Sharepoint site. Can anyone tell me how to do this with an Oracle database using Toad version 10.6?
could you explain me how to refresh production database schema's tables to test database shema using toad.
our requirement to refresh some production users tables from production database to test database schema periodically for example
I have two user proddta,prodctl in production database which have got around 30 tables so i need to transfer data(refresh) to Test database user testdta,testctl periodically (every month)
i would appreciate if you tell me step by step process.
Help! How do I call a remote stored procdure from a stored procedure in Oracle? I have a need to execute a remote stored procedure in Sybase that has a result set. This remote stored procedure will be called from a local stored procedure with my Oracle database. Is this possible?! If so, who do I do it?
What XSLT processor is used in Toad Data Modeler? I was hoping to use xsl:result-document but it does not appear to be supported?
I try to create connection to Oracle database 10.2 using toad 220.127.116.11, but I get this error.
I can TNSPING my database & SQLPLUS work fine.
Can anybody help me resolve this error?
My Data Size is 450 GB and I have taken 250 GB space for Index Tablespace and 20 to 30 % extra space would make my Database size of 1 TB,
Please advise what should be my FRA size.
I am configuring the oracle database 10g with spotlight 9.6. I am using the user wizard. I have am getting this ORA-00604: error occurred at recursive SQL level %s.
Please help to resolve this issue.
Which version of Toad need Oracle accounts QUEST and TOAD.
Are they still needed with Toad version 12?
The view has been created with the following statement. It all seems to work but there is no data there - do I need to specify the string?? Not sure what I'm doing here??
CREATE OR REPLACE FORCE VIEW NEW_VIEW_VW
CREATE PUBLIC SYNONYM NEW_VW;
DROP PUBLIC SYNONYM NEW_VIEW_VW;
CREATE PUBLIC SYNONYM NEW_VIEW_VW;
GRANT SELECT ON NEW_VIEW_VW;
I have written a trigger statement which updates my z table upon logging onto my dev system.
But i get the below error
File: E:\pt85109b-retail\peopletools\src\pssys\stmupd.cppSQL error. Stmt #: 2291 Error Position: 0 Return: 1843 - ORA-01843: not a valid month ORA-06512: at "SYSADM.Z_LOGIN2", line 7 ORA-04088: error during execution of trigger 'SYSADM.Z_LOGIN2' Failed SQL stmt:UPDATE PSOPRDEFN SET LASTSIGNONDTTM = TO_TIMESTAMP(:1,'YYYY-MM-DD-HH24.MI.SS.FF') WHERE OPRID = :2
This is my CODE
CREATE OR REPLACE TRIGGER SYSADM.z_LOGIN2AFTER UPDATE OF lastsignondttmON SYSADM.PSOPRDEFNREFERENCING NEW AS New OLD AS OldFOR EACH ROWDECLARE Mutating EXCEPTION; PRAGMA EXCEPTION_INIT (Mutating, -4091); errorm VARCHAR2 (2000);BEGININSERT INTO SYSADM.PS_FZAP_AUDIT_SOX (oprid, oprdefndesc,lastsignondttm, fzap_reason_cd,dbname,lastupdoprid,lastupddttm) select distinct :new.oprid,:new.oprdefndesc,:new.lastsignondttm,' ',' ',:new.lastupddttm,:new.lastupdopridfrom sysadm.psroleuser bwhere b.roleuser = :new.opridand (b.rolename = 'FAS Change Admin' or b.rolename='PeopleSoft Administrator');EXCEPTION WHEN Mutating THEN errorm := SQLERRM; -- DBMS_OUTPUT.PUT_LINE('prompt 13'); --INSERT_LOG('Error at Level '||LOG_LEVEL||' with error message '||errorm); WHEN NO_DATA_FOUND THEN NULL;-- DBMS_OUTPUT.PUT_LINE('prompt 14');END;
NOTE : Compiled the trigger , it says trigger created with no compilation error.
Is there any option of change management in toad so that we can track the DDL and DML changes and compare past changes.
This was originally posted into the Toad for Oracle community, but I was redirected here as I was told this was a more general SQL question:
I'm working on a query that will return multiple values for a record into 1 record. Here's the situation:Table 1
Description Update ID
As one can see, the link between the 2 tables above is Description Update ID = ID.
Select Inserted TextFrom table 2where id in (select Description Update ID from table 1 where Operation ID = 1)
The above query will return 3 records (ABC DEF 123) as expected. What I am trying to get is a query that will return 1 record with all the data from that field. So if I wanted results for the same Operation ID, I would like it displayed as below:
ABC, DEF, 123
For some background, this particular type of operation I'm trying to report on for the users has 3 fields that must be filled with data. Even though table 1 does not show a third record for Operation ID = 2, each of the records will have these 3 fields that must be filled in. I would like these fields to be mapped into one record. The query above is actually part of a much larger query that is already pulling information from other tables. As an alternative or even better solution, can the 3 values be displayed on 1 record as 3 separate columns??
Thanks to all for their help and assistance in solving this.