• 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:
  • Connecting and disconnecting Oracle sessions through Oracle forms

    How to  connect and disconnect oracle sessions through oracle forms?(suppose I need to validate user whose corrently loged on.)   email to :anandan.muthukannan@tcs.com

    Connectanddisconnect5 pointsBadges:
  • Calling Oracle Functions from Crystal

    We're stuck on Crystal 8.5 and have a need to call an Oracle function.  That part is solved.  The issue is that it calls it for every record returned in the recordset.  Does anyone know how to limit the call to once?  It doesn't appear to make any difference in where we place the call; the...

    MWToine5 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:
  • oracle 9i it is possible we creates some files or inserting values in that particular tables?

    In Oracle 9i it is possible we creates some files or inserting values in that particular tables? how can data stored in database files? when after few days if we want to see that files it will see that ? It is executing that files? where it stored in that table it is some specific folder will...

    Varsha500950 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:
  • UPK Developer 3.5.1

    When I click on the Save As the drive is just / Where is that pointing to? Can I change the path somehow?

    UPKNewbee25 pointsBadges:
  • Connecting databases in Oracle9i

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

    Varsha500950 pointsBadges:
  • Oracle DECODE and SSMA

    Does the SSMA or SQL Server Migration Assistant actually have a custom DECODE function that can be used in SQL Server? I've installed SSMA and can't find that function in the sysdb database. I assumed there was such a function based on a blog posting made by Kevin Kline.  If there is a function...

    Dirk5 pointsBadges:
  • SQL or How to find out Oracle COLUMNS containing value

    SQL or How to find out Oracle COLUMNS containing value "0" in a table. Suppose we have 20 columns in a table lets say 'T1' having column like C1, C2, C3, ----- upto C20, and we have to know in how many column zero or any other user specific value is present. Lets say in C1, C5, C7 there is/are zero...

    Maheshmamu20 pointsBadges:
  • Scheduled job for Oracle 9 returning ORA-01858

    We have an Oracle 9.2.0.1.0 database and get the ORA-01858: a non-numeric character was found where a numeric was expected error. Our production jobs are a series of stored procedures which are set up to run automatically by being called through another stored procedure, the Scheduler. While the...

    OracleATE190 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:
  • connect remote oracle 11g server in VB6.0

    how to connect remote oracle 11g server in vb6.0 without installing oracle client in local machine

    ITKE346,360 pointsBadges:
  • Best practices of RAID configuration of StorEdge HDS 9960 and Oracle 10g R2

    Hello, What are the best practices of RAID configuration of HDS 9960 storage and Oracle. Currently we are using now Mirroring RIAD 1+0 with 4 disks (2+2). will the second option of Mirroring 4+4 give us better performance than 2+2 disks? Thanks in advance. P.S. the Oracle instance is OLTP.

    Donpatrona5 pointsBadges:
  • I found FRM-92101 in oracle application server. Please help me to resolve this problem

    We are having 10 As middle tier Whenever we open the form always found the erro FRM-92101

    Bakre5 pointsBadges:
  • hi can anybody tell me how to combine these two queries

    1. SELECT count(*) AS Cnt1 FROM tsau_pre_msges WHERE ( (EXTRACT (DAY FROM Jms_timestamp)-EXTRACT (DAY FROM ins_time))*24*60 + (EXTRACT (HOUR FROM Jms_timestamp)-EXTRACT (HOUR FROM ins_time))*60 + EXTRACT (MINUTE FROM Jms_timestamp)-EXTRACT (MINUTE FROM ins_time) ) BETWEEN 1 AND 5 It will count...

    RizwanSharief30 pointsBadges:
  • How to create MDI FORM in d2k?

    How to create MDI FORM in d2k

    Howtocreatemdiform15 pointsBadges:
  • Do you think Oracle will close SUN during 2010?

    It seems that SUN is Kaput, do you think Oracle will Close Sun division during 2010?

    Olopez5 pointsBadges:
  • Sponsor Post: Fear the Cloud? Migration Pros and Cons (on-demand chat from 6/29/2010)

    Organizations need to able to quickly recover failed servers and their data in the event of an outage. Deploying a server recovery solution can save a company tens of thousands of dollars in lost productivity and lost business. This live chat on June 29th from 1-3 pm EST provides an exclusive...

    EmNichs3,250 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