Hello, I'm trying to write a simple select query USING TOAD for ORACLE that pulls information from a "system_store" table, where I need to find the real date and time stamp for columns " date_time_created" and "date_time_modified", including the "system_name" column. The date range for the query, aka datetime_created, is only for the year of 2008 to group any application from the column "system_type" that the name is "GM". Lastly, I would like to export the output it to an excel spreadsheet.
Can anyone help with it. It seems fairly easy, but I'm failing it, because I'm a beginner.
Thanks in advance.
Below is kinda of what I'm looking for...the query isn't correct, it's just an example:
Select system_name, date_time_created, date_time modified //////( would like the date and time stamp to show as ( example 06/14/2008 12:55 PM)
from system_store
where date_time_created = ???
and system_type='gm'
order by descending
then I would like to export to excel