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!
Could help me understand what parts of oracle and db2 are required for the toad to work, we will try to include that parts with the toad
Customer visualized applications for the vdi
error "oracle and db2 cannot be visualize"
do you have any idea if toad can be visualize?.
Cannot find any info on this and this is all have from customer, any ideas or suggestions?
I have an sql stmt I need to modify to retain leading zeros and I'm not sure how to modify it. Here is the code:
DECLARE -- declare variables and cursors
startDt VARCHAR2(10) := '&&BeginDate';
stopDt VARCHAR2(10) := '&&EndDate';
mmy_schema varchar2(200) := '&&mmy_schema'
---------THIS poliycNo IS THE VARIABLE I WANT TO RETAIN LEADING ZEROS....HOW??? IT IS A VARCHAR2(10BYTE) data type in the schema.
The cursor is defined after this, with FETCH and loop stmts.
We are using Oracle 10g and we enabled the auditing,
NAME TYPE VALUE------------------------------------ ----------- ------------------------------audit_sys_operations boolean TRUEaudit_syslog_level stringaudit_trail string DB
But we are not getting all users login information in DBA_AUDIT_TRAIL and sys.aud$.
There are information for some users but not for all users. Is it mean that other user are not audited.
How do we find user list which are currently audited.
In our production we have setup RAC
Can anyone Please share steps to test RAC settings.
My requirement is to create DB link between Oracle 8i and 11g.
as mentioned in interopertability matric connectivity between 8i to 11g is not supported, workaround is to create one intermidiate database of 10g .
is there any other workaround like can ODBC or JDBC (JDBC thin driver) connectivity is possible between 8i and 11g.
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?
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;