Search results for query: *

Purge [Oracle SQL] purge table name-of-table purge index name-of-table purge recyclebin purge dba_recyclebin purge tablespace name-of-tablespace purge tablespace name-of-tablespaces user name-of-user

Oh, here is the query that I ended up with. SELECT @Session.cust_database~."cust_trucks"."truck_name", "p"."lat" as "Latitude", "p"."lon" as "Longitude", "p"."date_time", trunc("p"."date_time") as THEDAY, "p"."location3distance" / 1000 as "location3distance", "p"."location3" FROM...

Hey Carp, seems to be working, I wish this damn database had some real data in it so I could test my queries. Thanks for the query, I will be back soon with another one for ya. I think it will be a 4 table query too. :)

Beilstwh, yours doesnt work either...you are missing "end" hehee, but I got it working. Thanks for ur post. SELECT QATECH_DATASTORE."cust_trucks"."truck_name", "a"."date_time", "a"."speed", "a"."heading", trunc("a"."date_time") as THEDAY, (case when "a"."heading" <...

ahhh, vacation would be nice, hope you are having a good time. talk to you soon.

Was there any other questions that you had SantaMufasa???

1.) careless 2.) Loaction is a number, (ex: 43). There is actually location3distance and location3, location3distance is the number and locaion is a word that represents the name of a city. With both together it would read, "43 km From Toronto" 3.) In the end I want to display - Truck Name -...

oops, I forgot the question mark after I wrote that, what I meant to say was Got it figured out??

Oh ya, My Manager tried to explain this a little to me, here is what she wrote down. select <all needed fields> from cust_positions CP where asset_type_id = 2 and Asset_id in ( truck id from user list) inner join on Cust_position_detail CPD on cp.oid = cpd.position_id where detail_type_id =...

I don't know if I will be able to describe this very well, I hardly understand it...who am I kidding, I don't understand it. On the page that I have to make selections from that are used to build the query are. StartDate, EndDate, List of trucks, drop down with sensor names populated from...

I was missing the "END" at the end....hahaha

in select cases cant you only do equals? I need it to work with a range of numbers

yippi. Thanks

Well If what I originally posted isnt a valid statement, I want to do something that VBScript can do that would be valid following the same direction of my original post.

What could I do instead?

Oh, @Data.heading is a number that is suppose to be between 0 and 360

IIF("@Data.heading~" <= "22.4", "N", IIF("@Data.heading~" <= "67.4", "NE", IIF("@Data.heading~" <= "112.4", "E", IIF("@Data.heading~" <= "157.4", "SE", IIF("@Data.heading~" <= "202.4", "S", IIF("@Data.heading~" <= "247.4", "SW", IIF("@Data.heading~" <= "292.4", "W", IIF("@Data.heading~" <=...

The query I need, I suspect will be very close to the one below. The query below returns a total of distance traveled between 2 dates for each truck. So if I select 2 dates that span a week, it will return the total distance traveled over the week for each truck. The new query that I am trying...

worked great carp. Thanks!! Waat me to start a new post for the 2nd query??

I decided to post the other query too...lol It will be very close to the one above. It will return (Truck Name, Date from report, and Distance traveled on the report date) From the page I will be able to select 2 dates (StartDate, EndDate) with these dates I will display all the trucks total...