• 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

    ITKE345,950 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:
  • 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:
  • SQL Explorer Not Connected

    Hi all My OS is WIN 7 , Oracle Server Installation (10g Express Edition) is Sucessful Oracle 10g Client Installation is sucessful ODBC connection is Sucessful. But SQL Expolrer - not connected Error is General SQL Error. Microsoft [ODBC Driver Manager] Driver is SQLallocHandle on SQL_HANDLE_ENV...

    Yes115 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