Need syntex help - simple

[lcan]

I am converting this SQL statement from Access to Oracle. Can you help me?

SELECT [814_24].DTM02_376 AS [Move Out Date], Count(*) AS [814-24 Count]
FROM 814_24
GROUP BY [814_24].DTM02_376
ORDER BY [814_24].DTM02_376;

 

[karluk]

Some of the other forum members know Access better than I do, however it looks to me as if this statement will run virtually unchanged in Oracle. The only modifications you have to make are to replace the Access table and column names with their Oracle names. Other differences include eliminating brackets and avoiding prefixing column names with table names - the correct prefix is the schema name.

SELECT Oracle_name_of_DTM02_376 AS Move_Out_Date, Count(*) AS 814_24_Count
FROM Oracle_name_of_814_24
GROUP BY Oracle_name_of_DTM02_376
ORDER BY Oracle_name_of_DTM02_376;