Recent content by tridith

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?