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 SkipVought 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: VSU
  • Order by date
  1. VSU

    accessing MS sql data from oracle

    Read : Oracle8i Distributed Database Systems. Release 2 (8.1.6). Part Number A76960-01. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76960/hs_conce.htm
  2. VSU

    PL/SQL Error for UTL_FILE

    ... WHEN UTL_FILE.INVALID_OPERATION THEN UTL_FILE.FCLOSE_ALL(); -- 1. Close all files and 2. RAISE user exception RAISE_APPLICATION_ERROR(-20102, 'UTL_FILE: INVALID OPERATION.'); -- RETURN; -- Not needed 'cause unhandled user exception will stop program execution. Check UTL_FILE_DIR...
  3. VSU

    Oracle

    ... raise_application_error(-20000,'sdfdfds'); ^^^^^^ ... User exception codes have to be between -20000 and -20999.
  4. VSU

    Pl/Sql Built-in packages

    You have no execution privilege on SYS.DBMS_LOCK package. Connect to database as user SYS Then GRANT EXECUTE ON dbms_lock TO my_user;
  5. VSU

    Practicing SQL

    It 'cause exists MGR IS NULL SELECT worker.ename FROM emp worker WHERE worker.empno not in (SELECT manager.mgr FROM emp manager WHERE mgr IS NOT NULL) ^^^^^^^^^^^^^^^^^^^^^
  6. VSU

    Can Oracle query Foxpro?

    http://otn.oracle.com/doc/oracle8i_816/server.816/a76960/part3.htm#435958 Oracle8i. Distributed Database Systems. Release 2 (8.1.6). December 1999. A76960-01 Part III.Heterogeneous Services Concepts and Administration)
  7. VSU

    Compilation Error

    Concatenation operator is '||'. Not '+'. CREATE TRIGGER ins_uomconv_trig BEFORE INSERT OR UPDATE ON uom_conversion FOR EACH ROW DECLARE as_xml VARCHAR2(255); as_from_uom VARCHAR2(20); as_to_uom VARCHAR2(20); as_tab_name VARCHAR2(50); as_oper VARCHAR2(20); BEGIN as_from_uom :=...
  8. VSU

    Oracle Book

    Scott Urman. Oracle PL/SQL Programming. (Oracle Press)
  9. VSU

    Can Oracle query Foxpro?

    Yes. Using Oracle Heterogeneous Services What is Heterogeneous Services? =============================== Heterogeneous Services (HS) is an integrated component within the Oracle8i database server, and provides the generic technology for accessing non-Oracle systems from the Oracle database...
  10. VSU

    Update table from another with linked fields

    -- Variant #1 UPDATE policy SET (policy.cov_cod, policy.des_txt, policy.chg_by, policy.chg_dte) = (SELECT new_cod, new_des, chg_by, chg_dte FROM tempmjb1 WHERE policy.acc_num = tempmjb1.acc_num AND policy.cov_maj = tempmjb1.cov_maj AND policy.cov_cod = tempmjb1.cov_cod...

Part and Inventory Search

Back
Top