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!
I prefer to use the oracle net services connection type, but I have to specify the location of the tnsnames.ora on my MAC each time I add a new database connection, is there a way to let toad know automatically where this file is located?
Mine is located in ./Applications/oracle/product/instaclient_64/220.127.116.11.0/network/admin
and my .bash_profile configures relevant environment variables as:
export ORACLE_HOME=$HOME/Applications/oracle/product/instantclient_64/18.104.22.168.0/export PATH=/usr/local/bin/athena:$ORACLE_HOME/bin:$PATHexport DYLD_LIBRARY_PATH=$ORACLE_HOME/lib
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.
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.
I'm currently working out of Toad Data Point 3.2 and have made a connection to a Oracle RDB Driver through ODBC connection within the Toad product. I am trying to "declare" a variable (see example below) but keep receiving an error. My issue is I'm trying to write a query to pull a set of data by limiting on a "where" clause, the data type of the field is a date field.
Example of my quick test code that is receiving an error (remember I'm connected to a ODBC connection to a Oracle RDB Driver):
declare @dt_timeframe date
the above gives me a syntax error, any guidance helps. Thanks.
I'd like to add you to my professional network on LinkedIn.
Am completely new to TOAD..!! so can anyone please explain in general how and what for TOAD is used for ? Please explain from step 1 of getting introduction to TOAD,
or do suggest any materials to know about TOAD.
P.S : And am interested in learning about TOAD, i work with pl/sql and sql.
Can someone explain to me why "Rename Identifier" is greyed out in Toad, when I am trying to refactor my code?
I want to do just one rename for my whole code.
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?
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.
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.