• Passing array as output parameter through procdure/function

    Any suggestions on implementing a procedure that passes an array as output parameter and using this as an input to a second procedure and manipulating it?

    PRASAD550 pointsBadges:
  • Novell EDirectory synching with Oracle Internet Directory 10G using Novell IDM2 (previously DirXML)

    Any of you guys have any experience on this? Any tips or probably a step-by-step guideline to follow going about this?

    Rdocena0 pointsBadges:
  • Support of Oracle 8 and 9i

    We currently support several systems running Oracle 8 that are upgrading to 9i. From a support perspective, can someone help me identify any key differences that might need special attention the my Oracle 8 experience does not cover? Thank you.

    Guido770 pointsBadges:
  • Tools for Oracle database admin, and also Design and Development

    I was out of the Oracle world for three years (using 7.4?), and now knee deep in alligators with little time to review market offerings. I am using Oracle Enterprise Manager for 9i and very happy with it. An Embarcardero vendor has contacted me a couple of times, but I've had little time to...

    Candyrob0 pointsBadges:
  • Database groups in Ireland

    Do you know of any associations in Ireland that specialize in Database work, such as an Oracle Users Group?

    Pegasusdba0 pointsBadges:
  • ORA-01436 error

    We are trying to use connect by ..prior feature of oracle. Having said that we had used this type of queries and now we are facing this loop error for connect by prior. Any suggestions.

    PRASAD550 pointsBadges:
  • RAC and parallel server

    What is difference between RAC and parallel server?

    667983690 pointsBadges:
  • Peoplesoft DBA

    I may have an opportunity for a Peoplesoft DBA job. I've done a wide gamut of Oracle DBA work at a major university for the last 10 years and am looking for a challenge. I don't know what skills this kind of position would require or allow one to develop. This is my main concern. Would it provide...

    Jrmills0 pointsBadges:
  • Getting duplicate records

    I have looked onto the web for finding duplicate records. However most the queries given finds one of the duplicate records. Our requirement is to find both (or multiple) duplicate records from a table. We are using Oracle 9i. Regards

    PRASAD550 pointsBadges:
  • Adding column to an exiting primary key

    We have a table which already has a primary key. We want to make this have a composite primary key with another column. Is there any other way to do this without dropping the primary key and recreating a composite PK. Thanks in advance.

    PRASAD550 pointsBadges:
  • remotely managing database securly

    If I want to work at one place and be able to manage the Oracle 8i database remotely and securly at another place, what should I do or set up? Thanks

    667983690 pointsBadges:
  • Using Record Type

    We have a table with 70 columns and everyday we move data from thsi table to its history table which is basically same in structure. The daily table has about 4 million records that is tranferred to the history table. To move data from this daily table to the hostory table we are using bulk collect...

    PRASAD550 pointsBadges:
  • Duplicate records

    What is the best way to detect duplicate records within a large database where the primary key is different?

    Squirls0 pointsBadges:
  • DISTINCT or work-around

    Greetings from Vijay, Consider table B as below with columns b1 and b2. Table B B1 B2 ========== 1 abc 2 xyx 3 abc 4 efg 1 xyx 3 abc 4 car 5 edf Query 1 ========= select distinct b2 from B Output : ====== B2 ============ abc car edf efg xyx Explain Plan: Query 1 ===================== Operation...

    Vijaysai0 pointsBadges:
  • Default values in Oracle packaged procedures

    What is the best way to conceal default packaged procedure parameter values? I thought of this way: Make default values NULL in the specification Make default values whatever you want them to be in the package body. Wrap (encrypt hex) package body. I need this in order to obfuscate the use of this...

    NOCOPY0 pointsBadges:
  • NLS Parameters, Character Set Selection for Saudi Arabia

    HI, I need to create a data warehouse in Saudi Arabia, on Oracle 9.2.0. The database will store almost everything in English, but will need to store Arabic names in Arabic, and will need to handle both gregorian and hijri date formats and display them correctly. This same database may later need to...

    Abkeyte0 pointsBadges:
  • Privileges for DBA role

    In an Oracle database I have a user with DBA as the default role. But I had to grant explicitly via "grant SELECT on ..." to this user to allow it to select from DBA_ROLE_PRIVS and DBA_USERS. Since the DBA role grants all system privileges WITH ADMIN OPTION, why is it necessary to grant...

    170519660 pointsBadges:
  • upgrade from 8i to 9i or 10g

    This question might be a bit early for some, but at the end of the year 8i on windows goes off support. We will be looking at upgrading soon after. I would also expect that 10.2 might be on the horizon at that point. One would hope that would be a stable release. I would be interested to hear if...

    Laura550 pointsBadges:
  • Oracle Internet Directory

    Has anybody successfully synchronized OID with a third-party LDAP?

    Dbgomi0 pointsBadges:
  • Oracle Collaboration Suite

    Is anyone using or planning to use OCS?

    Paulwb0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.