Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tridith

  1. tridith

    Tables left after DROP

    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
  2. tridith

    4 table query...maybe 5??

    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...
  3. tridith

    4 table query...maybe 5??

    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. :)
  4. tridith

    CASE Missing Keyword

    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" <...
  5. tridith

    4 table query...maybe 5??

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

    4 table query...maybe 5??

    Was there any other questions that you had SantaMufasa???
  7. tridith

    4 table query...maybe 5??

    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 -...
  8. tridith

    4 table query...maybe 5??

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

    4 table query...maybe 5??

    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 =...
  10. tridith

    4 table query...maybe 5??

    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...
  11. tridith

    CASE Missing Keyword

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

    Is This Statement Valid?

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

    Group By Date

    yippi. Thanks
  14. tridith

    Is This Statement Valid?

    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.
  15. tridith

    Is This Statement Valid?

    What could I do instead?
See more

Part and Inventory Search

Back
Top