Oracle

Oracle Community

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!

Community Discussion

rtheron
Follow / 11 Jul 2014 at 6:09pm / Oracle
Latest post by on 29 Jul 2014 at 6:48pm

Default tnsnames.ora file location config

Expand content
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...

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/11.2.0.4.0/network/admin

and my .bash_profile configures relevant environment variables as:

export ORACLE_HOME=$HOME/Applications/oracle/product/instantclient_64/11.2.0.4.0/
export PATH=/usr/local/bin/athena:$ORACLE_HOME/bin:$PATH
export DYLD_LIBRARY_PATH=$ORACLE_HOME/lib

165 4 / Create an account to join the discussion.
ashish_jha
Follow / 19 Mar 2014 at 10:02am / Oracle
Latest post by on 26 Jul 2014 at 5:12pm

RAC Testing

Expand content
In our production we have setup RAC Can anyone Please share steps to test RAC settings.

In our production we have setup RAC

Can anyone Please share steps to test RAC settings.

156 1 / Create an account to join the discussion.
nitinpbhore
Follow / 11 Mar 2014 at 9:57am / Oracle
Latest post by on 26 Jul 2014 at 1:07pm

DB link between Oracle 8i and 11g

Expand content
Hi 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...

Hi

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.

Regards,

Nitin

341 1 / Create an account to join the discussion.
AmyHill
Follow / 31 Mar 2014 at 8:16pm / Oracle
Latest post by on 26 Jul 2014 at 12:59pm

Retain leading zeros for declared variables using cursor and fetch...

Expand content
Greetings, 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: undef mmy_schema; undef BeginDate; undef EndDate; DECLARE -- declare...

Greetings,

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:

undef mmy_schema;

undef BeginDate;

undef EndDate;

DECLARE -- declare variables and cursors

startDt  VARCHAR2(10) := '&&BeginDate';

stopDt VARCHAR2(10) := '&&EndDate';

mmy_schema varchar2(200) := '&&mmy_schema'

policyNo   &&mmy_schema..TableName.fieldname%TYPE;  

---------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.

 

163 1 / Create an account to join the discussion.
Orangeblood26
Follow / 13 Jun 2014 at 5:43pm / Oracle
Latest post by on 26 Jul 2014 at 12:50pm

Oracle RDB Driver connection and using variables

Expand content
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...

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.

Unanswered 107 1 / Create an account to join the discussion.
Dharmendra Verma
Follow / 24 Jun 2014 at 5:28pm / Oracle
Latest post by on 24 Jun 2014 at 5:31pm

Invitation to connect on LinkedIn

Expand content
From Dharmendra Verma Software Engg. at Infokall Pune Area, India I'd like to add you to my professional network on LinkedIn. ...
 
LinkedIn
 
 
 
 
From Dharmendra Verma
 
Software Engg. at Infokall
Pune Area, India
 
 
 
 
 
 
 

I'd like to add you to my professional network on LinkedIn.

- Dharmendra

 
 
 
 
 
 
 
You are receiving Invitation to Connect emails. Unsubscribe
© 2014, LinkedIn Corporation. 2029 Stierlin Ct. Mountain View, CA 94043, USA
 
99 1 / Create an account to join the discussion.
balavenkat
Follow / 17 Jun 2014 at 6:43am / Oracle
Latest post by on 18 Jun 2014 at 10:41am

TOAD - Introduction

Expand content
Hello All 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...

Hello All

          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.

Regards

BalaV

191 3 / Create an account to join the discussion.
x2suggs
Follow / 21 May 2014 at 10:14am / Oracle
Latest post by on 21 May 2014 at 11:25am

Stored procedures and triggers

Expand content
Hello all. Can someone tell me where I can find information and/or documentation on using stored procedures and triggers that can be activated from a client-side application. I could add a record from...
Hello all. Can someone tell me where I can find information and/or documentation on using stored procedures and triggers that can be activated from a client-side application. I could add a record from the client-side or something of that nature but I don't really have any experience writing procedures or triggers.
Thanks in advance... Glenn
Answered 168 1 / Create an account to join the discussion.
dorianpc
Follow / 6 May 2014 at 7:57pm / Oracle

Why is Rename Identifier greyed out?

Expand content
Guys, 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.

Guys,

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.

Unanswered 118 0 / Create an account to join the discussion.
Milton.Villegas
Follow / 8 Apr 2014 at 9:25pm / Oracle
Latest post by on 9 Apr 2014 at 3:03pm

Toad 12 and Toad db2. we found that both oracle and db2 wont work...

Expand content
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...

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?

Unanswered 146 1 / Create an account to join the discussion.
Maheshdba
Follow / 20 Mar 2014 at 8:19am / Oracle
Latest post by on 20 Mar 2014 at 12:50pm

All users DB login information

Expand content
Hi All, We are using Oracle 10g and we enabled the auditing, NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_sys_operations boolean TRUE audit_syslog_level...

Hi All,

We are using Oracle 10g and we enabled the auditing,

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_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.

Thanks !

Unanswered 193 2 / Create an account to join the discussion.
ellen maas
Follow / 27 Feb 2014 at 11:03pm / Oracle

RE: [Probable SPAM] Re: PL/SQL question: How to access a node in a...

Expand content
I’ll try them both – thanks. (And don’t let this keep you awake!) Ellen From: Norm [TeamT] [mailto:bounce-NormTeamT@toadworld.com] Sent: Thursday, February 27, 2014 5:02 PM To: oracle@toadworld...
I’ll try them both – thanks. (And don’t let this keep you awake!)
Ellen
 
From: Norm [TeamT] [mailto:bounce-NormTeamT@toadworld.com]
Sent: Thursday, February 27, 2014 5:02 PM
To: oracle@toadworld.com
Subject: [Probable SPAM] Re: [Toad World - Oracle Discussion Forum] PL/SQL question: How to access a node in a VARRAY of VARRAYs
 
Reply by Norm [TeamT]
Alternatively, you might need to use:

Gv_base(1)(1) to get 'C' etc.

Cheers,
Norm. [TeamT]
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Oracle notifications altogether.
Toad World - Oracle Discussion Forum

Flag this post as spam/abuse.


172 0 / Create an account to join the discussion.
ellen.maas
Follow / 27 Feb 2014 at 4:42pm / Oracle
Latest post by on 27 Feb 2014 at 11:01pm

PL/SQL question: How to access a node in a VARRAY of VARRAYs

Expand content
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...

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;

Unanswered 366 2 / Create an account to join the discussion.
ryanshe
Follow / 25 Feb 2014 at 6:59pm / Oracle

How to connect to a Sharepoint site to retrieve data from a list

Expand content
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...

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?

Unanswered 195 0 / Create an account to join the discussion.
younus_dba
Follow / 14 Feb 2014 at 8:54pm / Oracle
Latest post by on 17 Feb 2014 at 5:36pm

Refresh of Database using Toad

Expand content
Hi folk, 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...

Hi folk,

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.

374 2 / Create an account to join the discussion.