• Finding which columns contain data in a table

    I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table 1 has Columns Col1, Col2, Col4 being...

    TedGiles5 pointsBadges:
  • SQL statement exceeding 2000 characters in Oracle Graphics Builder

    In Developer 6i Graphics Builder, i am not able to write query exceeding 2000 character. i think it is restriction in this version. If I want to write query exceeding 2000 then please suggest me what to do.

    44063860 pointsBadges:
  • How to perform Unique check in PL/SQL

    Hi Experts, I need to perform a Unique check on existing record in table X for combination of field in my PL/SQL block before inserting new record into Table XX Table XX for combination of the following field list (X_ID, St1, St2, City, CP, PS, XNAME, C_ID) AND DISPLAY MODE = 0 How can i do this...

    Inprise610 pointsBadges:
  • How to test whether the Database tables designed to avoid deadlock occurence?

    I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do?...

    Saimadhu455 pointsBadges:
  • Querying in Hyperion

    In my limit row one of the limitations is grayed out but still has a value entered - will this data be returned when I process the query?

    Mane00185 pointsBadges:
  • Oracle9i Release 1.0.2.2.2a Application Server Install – Enterprise Edition

    I am installing the Forms and Reports Server component only first. But it hangs when it get to 100% and it is saying "Installing Oracle9i Application Server 1.0.2.2.2a" It hangs after prompting a blank command line and it seems it is trying to run something. Here is the last line on the...

    Stecjohn15 pointsBadges:
  • Referential integrity and AS/400

    Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy

    Shaddy20 pointsBadges:
  • Oracle Reports 9i

    I am new to Oracle reports, I am working on 9.0.4 version, I have configured OC4J, but when I run forms its shows Oracle application services installed successfully, and once I click ok it comes with a blank screen and status bar of the IE says its still loading. Please help me out.

    OracleRep5 pointsBadges:
  • How can I join 3 tables using JOIN keyword

    Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT ... WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!

    Inprise610 pointsBadges:
  • Oracle Installation

    Ho w to Install Oracle in Xp Operating System?

    Jayapaul35 pointsBadges:
  • Oracle Statspack

    I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I'd turn is off at 5pm the next day. I did not turn it off and...

    Jwwolff10 pointsBadges:
  • run oracle 9i with Windows Server 2003 Domain Controller

    sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like SQL....

    Swapnesh15 pointsBadges:
  • Database offline vs Database stopped vs Database network disconnected?

    How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Discoverer user assignment

    I have thirty+ new users i have to assign various reports to. What is the best way to handle this task? Is there a copy function so i can copy the existing user to the new user if they can access the same reports?

    QAQA65 pointsBadges:
  • Crystal Reports data

    I've written a report in CVrystal 8.5 that pulls the timestamp from an event table. A record in the event table is added each time a user logs into Oracle. I want to pull only the most recent record for each user and was wondering if there is an easy way to do that. Is there a MAX formula to get me...

    Jwwolff10 pointsBadges:
  • Oracle ERP single signon using Active Directory

    We are on Oracle 9i and will like to implement a solution to allow Oracle ERP users to signon using Microsoft Active Directory. Thanks Thanks

    Morounfolu15 pointsBadges:
  • SQL Query

    Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ---------- ---------- -------- 1 3 01-12-08 1 2 01-12-08 2 3 01-12-08 2 2 01-12-08 3 6 05-12-08 4 10 05-12-08...

    Mariane10 pointsBadges:
  • How to push the Database into deadlock state?

    Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.

    Saimadhu455 pointsBadges:
  • can we install oracle10g client version and oracle 10g server on the same machine? will it work fine?

    can we install oracle10g client version and oracle 10g server on the same machine? will it work fine? If there will any problem so what will the problem? Please any one explain me. Thanks in advance. It's urgent please

    Rajesh00825 pointsBadges:
  • SQL select

    SELECT obj.object_type FROM apps.opt_log_issue log, discov.opt_changed_database_objects obj WHERE --(UPPER(log.resolution(+)) like '%'||obj.object_name||'%' -- and trunc(log.resolution_date(+)) - trunc(to_date(substr(obj.last_ddl_time,1,11),'dd-mon-yy')) <=5 -- and trunc(log.resolution_date(+))...

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

Following