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!

Search results for query: *

  1. cwong5

    Oracle Client Installation on W2k

    Usually Running the AutoRun file will fix that problem.
  2. cwong5

    Finding bad SQL's !!! urgent help plz !!!

    Hum. If you are executing over an ODBC connection, you can set it up to ask for return of query longer than a certain time. That's only if you are connecting via ODBC.
  3. cwong5

    Novice Oracle User needs Urgent Help

    My fav development tool for Oracle is TOAD. You can try it on <a href=&quot;http://www.toadsoft.com/&quot; target=&quot;new_win&quot;>http://www.toadsoft.com/</a>.
  4. cwong5

    Can't connect to Oracle 8i Personal Ed. from Developer

    Okay. I ran into that problem before using BEQUETH. My work around was to use TCP/IP, an djust put in the ip address of your box. Follow hemantpandya's instruction to use NET 8, but if it doesn't work, go back and use TCP/IP instead of BEQUETH (Local protocol). That solved it for me last time.
  5. cwong5

    How do I load data from a FLAT file into oracle??

    I usually use MS Access when I have to do such thing.
  6. cwong5

    date checking in a single select statement

    joereena, How do you want to show it? In an message box as the date is being saved? or in a different field? Chester
  7. cwong5

    Simple Trigger to update column... HELP!

    I want to thank everyone who helped me! And the least I can do is to post the final trigger for reference, in case anyone else is wondering! THANKS! CREATE OR REPLACE TRIGGER v_gcd before update or insert of int_filename on editorial for each row declare vcount number; begin select count(*)...
  8. cwong5

    Simple Trigger to update column... HELP!

    Okay. I am transferred the field I want ot update onto another table, and yet i am still getting the same error. Can anyone give me an example code? Thanks for everyone's help. I am going insane!
  9. cwong5

    Simple Trigger to update column... HELP!

    Oh, I am getting this error: ORA-04091: table HEMERA.EDITORIAL is mutating, trigger/function may not see it ORA-06512: at &quot;HEMERA.V_GCD&quot;, line 5 ORA-04088: error during execution of trigger 'HEMERA.V_GCD'
  10. cwong5

    Simple Trigger to update column... HELP!

    I am so so desperate of help. It's pretty simple by concept, but I can't seem to get it right. Okay 2 tables. Table A -> id, c1, c2, c3 Table B -> id, c1, c2, c3 I want a trigger that will populate c1 from table b when I insert or update the id in table a. So far, I have this: (what did I...

Part and Inventory Search

Back
Top