• January 26, 2006 26 Jan'06

    Select * from loc

    Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as above? Firstly I don't want to use any advanced feature of Oracle 9i. Is it possible using plain SQL ...  Continue Reading

  • January 26, 2006 26 Jan'06

    A closer look at the Oracle-Sun deal

    Oracle CEO Larry Ellison and Sun Microsystems Inc. CEO Scott McNealy got together recently at Oracle headquarters for a town hall style meeting during which they announced a "newly reinvigorated" partnership between their two firms. Under the deal, ...  Continue Reading

  • January 25, 2006 25 Jan'06

    "Select star" with column reformatting

    Let's say I have a data table that has columns A-Z and column C is for Date-Time. I want to see all of the columns in my table. When I do a "Select * from datatable" the return is the standard DD-Mon-YY. My question is, can I still use a Select *...  Continue Reading

  • January 25, 2006 25 Jan'06

    Which Oracle products are best for our large Web-based application?

    We would like to develop a big Web-based application for our business, which can be accessed by around 10 million people with good performance, stability and easy maintenance. We are expecting huge database connections. We would like to use Oracle ...  Continue Reading

  • January 25, 2006 25 Jan'06

    How to insert Arabic data in Oracle?

    How to insert Arabic data in Oracle 9i?  Continue Reading

  • January 25, 2006 25 Jan'06

    Settings for two instances on same machine

    I have two instances (Oracle 8.0.6) on the same Sun Solaris (5.7) machine. I could not connect the instances at the same time. How do I set my machine? What will the listener settings be?  Continue Reading

  • January 25, 2006 25 Jan'06

    Shut down database manually or automatically?

    I have Oracle 9i installed on Windows 2000 Server. I have to shut down the server daily when leaving the office. Do I have to shut down the database manually daily, or will it be shut down with Windows? If it will be shut down automatically with ...  Continue Reading

  • January 25, 2006 25 Jan'06

    ORA-12514 error when connecting through SQL*Plus

    I get the error "ORA-12514: TNS listener could not resolve service_name in connect descriptor" when I try to connect from the command line with SQL*Plus. When I try to connect to the database with other tools (e.g., Toad ), everything works just ...  Continue Reading

  • January 25, 2006 25 Jan'06

    Count consecutive years

    I am struggling with writing a query to count consecutive years from the current year. I do not want to use a cursor. There is no requirement for the dates to be 365 days apart, just that they have different years. Any thoughts would be appreciated.  Continue Reading

  • January 25, 2006 25 Jan'06

    Select columns as rows

    I have a table with four fixed columns, which have to be converted as rows in the SQL output.  Continue Reading