• 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

    ITKE352,580 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:
  • Microstrategy(Reporting tool)

    Hi, I have to display the current year which are selected in the prompt and also the last year for the current year selaction in the report using Microstrategy.

    Maha15 pointsBadges:
  • PA: Error in main

    What does this mean?

    Ruthkowalski5 pointsBadges:
  • How to get answered prompt details on Report Service Document in Micro strategy 9.0?

    We are using prompted filters to restrict data display in Reports. when we are going to have formatting kind of stuff,we should use Report Service documents. For Example,if we have prompt named "Company Name".While executing report,this prompt can be answered.  Report Service document is created...

    Smpsj30 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:

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