• To display not exit data in oracle

    in my table there a,b,c,d are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose b & c are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for that month as 0...

    Deb4u50 pointsBadges:
  • Standby Database Server

    I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don't know how a user can connect to the standby server when the primary has failed. This is my connection string "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =...

    Girma30 pointsBadges:
  • ordering dates in Oracle

    how to order the months and year in descending order from a table?suppose there are 2 culomns one contains month and another contains year.then how to show them in an order like jan-2001,feb-2001,mar-2001.........like this. plz suggest some answer for this.

    Deb4u50 pointsBadges:
  • Need query to retrieve data from a given date in Oracle 10g

    i have some data to retrive from one table based upon certain condition.when ever i will query to retrive data [strong]it will return all the data based upon the date range.suppose i will enter 22-jul-2010 then the query should return from the year july-2010 to may be 2011 or 2021.upto the last...

    Deb4u50 pointsBadges:
  • Connecting databases in Oracle9i

    Can u tell me how to connect database files in oracle 9i software

    Varsha500950 pointsBadges:
  • Oracle Help?What is the DB dependencies related to object sequencing for DB builds

    What is the DB dependencies related to object sequencing for DB builds?

    SpockII5 pointsBadges:
  • How to connect to database inside VMWare from the web applications

    Hi All, I have VMWare in my desktop which contains the Oracle database. And in general my desktop is in network with the server having web based applications. Now I want to fetch the data from this VMWare database in my application. Can we establish JDBC connection from the application to this...

    Swatigaur25 pointsBadges:
  • Large number rounding in Oracle 10g

    Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code.  When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some...

    Techguys90 pointsBadges:
  • Suggestions for modern replacement of AS/400

    We are looking to retire our AS/400 machine, what is a suitable replacement? Our aging AS/400 machine is on its last legs. What modern system is a good fit? We have Oracle data on it for our front end server. Everything is backed up to tape library.

    ITKE346,470 pointsBadges:
  • Importing sound Class

    hi, My technical environment is: Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i. I created a sound.java file using Oracle9i JDeveloper, I compile it and the result is: " Compiling... D:Dev9ijdevWorkspaceWorkspace5soundsrcoracleformsfdSound.java Successful compilation: 0 errors, 0...

    FormsBuilderOracle10 pointsBadges:
  • Database auditing

    Hi everybody? I do have a shema named PRACTICE with its own table named EMPLOYEES. The table has fields: empid,fname,sex and age. Their data types are varchar2,varchar2,varchar2 and number respectively. The fields also held values LA,Lensa,F and 21 respectively. Being on the sys schema, I defined a...

    Girma30 pointsBadges:
  • Oracle 10g Database Housekeeping

    i've been asked to work on database housekeeping, i don't know what i should do? please advice

    DB10g15 pointsBadges:
  • SQL Server 2008 R2 provides direct integration with Oracle Database

    Does SQL server 2008 provide direct integration with the databases built-in within an oracle DB?

    ITKE346,470 pointsBadges:
  • I would like to install Oracle database on OS X MacBook

    I have looked in the Oracle Technet site for a version of Oracle suitable for OS X.  I downloaded Oracle 10.2.0.4.0 because it said that it was compatible with Mac OS X.  However, when I attempted to install the application, nothing happened.  Upon closer look, the documentation seem to point to...

    JavierS45 pointsBadges:
  • How does profile limit for PASSWORD_REUSE_MAX works

    How does the profile limit for PASSWORD_REUSE_MAX works for Oracle Enterprise Database 9i ? Suppose we set PASSWORD_REUSE_MAX to 5 in a profile for a user. Now this user tries to change his password, then at that point how does Oracle engine checks if the new password the user is giving matches to...

    Maxmachine5 pointsBadges:
  • Problem in connection oracle lower version client with oracle database

    Problem in connection oracle lower version client with oracle database.

    Webtechsolutions55 pointsBadges:
  • multiple instances of an Oracle database

    how can i create multiple instances on one oracle database on my machine

    Bassgui5 pointsBadges:
  • high-values low-values (microfocus COBOL in Oracle/Linux environment)

    Successfully remediated 80+ programs from mainframe env to run in microfocus cobol against Oracle DB in Linux env. I have one pgm that is moving high and low values to output header trailer records per requirement. Leading 9 bytes of each record. My problem is that when it ran on the mainframe I...

    Zcr00245 pointsBadges:
  • What steps are involved when source DB is a Oracle and target db is SQL Db?

    How to test  when source DB is a Oracle and target db is SQL Db? What  to test  in particular when source DB is a Oracle and target db is SQL Db? I have worked on when both the target DB  and Source Db was SQL Server.How is it different when Source Db is ORacle and Target DB is SQL Server....

    Mayurkhe295 pointsBadges:
  • Oracle DB import/export

    hi everybody! I'm using oracle 10g db. I do have an oracle instance with user name aa and password aa. And also I do have another oracle instance with user name bb and password bb. I want to import a data base from aa into bb. I know that bb has to have accesses atleast what aa has. With these...

    Girma30 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