Ask the Experts

Ask the Experts

Oracle and SQL

  • 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

  • "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

  • 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

  • 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

  • Copy a row to the same table

    I want to insert a new row in a table with the same row in the same table with a different primary key value. I think I can do it using a temporary table but is there any other way?  Continue Reading

  • Concatenate values separated with commas

    I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any function that could do that.  Continue Reading







  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...