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

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 56 1 / Create an account to join the discussion.
AmyHill
Follow / 31 Mar 2014 at 8:16pm / Oracle

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.

 

51 0 / 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 106 2 / Create an account to join the discussion.
ashish_jha
Follow / 19 Mar 2014 at 10:02am / Oracle

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.

48 0 / Create an account to join the discussion.
nitinpbhore
Follow / 11 Mar 2014 at 9:57am / Oracle

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

66 0 / 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.


96 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 149 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 120 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.

200 2 / Create an account to join the discussion.
edminor
Follow / 13 Jan 2014 at 8:05pm / Oracle
Latest post by on 16 Feb 2014 at 7:52pm

Help! How do I call a remote stored procdure from a stored procedure...

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

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?

175 1 / Create an account to join the discussion.
mary.hunt
Follow / 12 Feb 2014 at 1:54pm / Oracle

XSLT processor used in Toad Data Modeler

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

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?

80 0 / Create an account to join the discussion.
ashish_jha
Follow / 10 Feb 2014 at 6:27am / Oracle
Latest post by on 10 Feb 2014 at 8:41am

Size Of FRA

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

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.

Thanks

Ashish

115 1 / Create an account to join the discussion.
imtishal
Follow / 27 Jan 2014 at 12:10pm / Oracle
Latest post by on 27 Jan 2014 at 1:27pm

ORA-00604: error occurred at recursive SQL level %s

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

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.

 

 

368 1 / Create an account to join the discussion.
zbigniew.czesak
Follow / 24 Jan 2014 at 2:39pm / Oracle
Latest post by on 24 Jan 2014 at 2:59pm

Oracle QUEST and TOAD accounts

Expand content
Which version of Toad need Oracle accounts QUEST and TOAD. Are they still needed with Toad version 12?

Which version of Toad need  Oracle accounts QUEST and TOAD.

Are they still needed with Toad version 12?

Unanswered 142 1 / Create an account to join the discussion.
palmy12
Follow / 6 Jan 2014 at 2:00pm / Oracle
Latest post by on 7 Jan 2014 at 3:24am

Creating a new view from 2 tables but contains no data?

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

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
(
   URL,
   ORGANISATION,
   CATEGORY,
   SEARCH_1,
   SEARCH_2
)
AS
   SELECT DISTINCT,
   TABLE1.SERV_URL,
   TABLE2.ORGANISATION,
   TABLE1.SEARCH_1,
   TABLE1.SEARCH_2

FROM      TABLE1,
          TABLE2;

CREATE PUBLIC SYNONYM NEW_VW;
DROP PUBLIC SYNONYM NEW_VIEW_VW;
CREATE PUBLIC SYNONYM NEW_VIEW_VW;
GRANT SELECT ON NEW_VIEW_VW;
254 5 / Create an account to join the discussion.