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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Dmytro
  • Order by date
  1. Dmytro

    accurate date

    If you're on 8i, you may write java procedure, if not - try to use dbms_utility.get_time, but it returns 100th's of a second.
  2. Dmytro

    subquery

    select * from a,b where a.id=b.id and exists(select id from a where a.id=b.id group by id having count(*)<2)
  3. Dmytro

    Append Query

    UPDATE Agent SET Agent.worktype = (select tbl_Agent_List.worktype from tbl_Agent_List WHERE ((tbl_Agent_List.center = 'SAN') AND (Agent.agent_id = tbl_Agent_List.agentid))) where (substr(Agent.datetime,1,10) = SYSDATE - 1); It works if subqury returns not more then 1 row per Agent row. If...

Part and Inventory Search

Back
Top