Search results for query: *

Could anyone tell me how I would transform multiple rows into multiple columns in oracle, assuming that i did NOT know the total number of outgoing columns (i.e. it's flexible). So turning a list like this: NAME OCCUPATION MATT BUILDER JEFF BUILDER GEORGE BUILDER CHRIS PLUMBER...

Hi there - in Oracle SQL - does anyone know how to take a string and split it into multiple columns, where the number of distinct strings, and therefore output columns, is variable? For example; Name: Matt Rundle John Smith Warren Hubert Jones Martine Louise Jane Smith would go to...

Hello there - could anyone help me with a quick question on string aggregation. Is it possible to write some SQL on the fly (i.e. not PL/SQL) that would aggregate multiple rows into one column. For example imagine a table called people, with columns name and city; how would I amend the query...

Can anyone tell me how to count the number of times a character appears in a string, using jet SQL? Any suggestions welcome! Thanks Matt

Hi there I'm trying to create an anagram solver and have written the following code. It basically prompts for a string and then matches individual chars in that string to chars in words in a simple dictionary (just in a normal table). I can get it to work but to ensure no additional letters...

Hi there - anyone know how to create a new table in Access named after the value of a field in another table? The latter table would only be one record in any circumstance. E.g., table with ID value = 123456 would be referenced to create a new table called "123456_" etc... Any tips greatly...

I'm after a way of getting a query in SQL (Access) to look at a range of classifications, and then taking the top 5 largest number of items [in this case] against that classification. For example; for a table holding data on products in a record store, you might want to ask it "Tell me the top...

Hi Can anyone help? I'm trying to find the latest date from a field along with the unique identifier against that instance. So, I have a list of release dates, barcodes all sharing the same artist name; how would I extract the barcode, release date (and artist name) for the record with the...