Ask the Experts

Ask the Experts

Oracle and SQL

  • Ranking within a group

    How can I get the rank of a certain column without using the rank() function, just using a simple SQL query?  Continue Reading

  • Another FULL OUTER JOIN example

    I am trying to create a query which should return four columns. I would be glad to even have just three columns, since the total can be computed in the display table. So far I have a query which returns just two rows under the same column. Am stuck ...  Continue Reading

  • Latest version of each jobcode

    I am trying to retrieve information from a single table. The table contains job descriptions, about 500,000 rows. Each description has multiple rows. My subqueries work separately, but not together. Do you have any suggestions?  Continue Reading

  • Removing blank lines from a text file

    I want to upload a .txt file containing records in an Oracle table with the UTL_FILE package. There are blank lines between two records in many places, and with the script I'm running, whenever the procedure encounters a blank line it comes out of ...  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close