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!

  • Congratulations Wanet Telecoms Ltd 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 CD12

  1. CD12

    Problems with Synonyms

    Thank you karluk, your information brought me on the right track, now it is working. CD12
  2. CD12

    Problems with Synonyms

    Hi, I have a table on a different database than my main database and via a database link and synonym I can access it from my main database in sqlplus, by e.g. SELECT count(*) FROM table_on_secondary_db; As soon as I try to access it within a Begin - End block, like: DECLARE counter...
  3. CD12

    Advantage of NAME_IN

    Hi, the advantage of NAME_IN('Block.Item') is that you can use it in PLSQL-Libraries the notation of :Block.Item would cause an compilation error. Another advantage is (together with the COPY function) you can use dynamic variables, e.g. you have in your form items called name_1, name_2,... you...
  4. CD12

    Concatenation Problem

    Information: On the page http://sqlzoo.net, there under Functions you can find how functions are used in MySQL, Oracle, SQL Server, Access and Postgres.
  5. CD12

    Help speeding up a Complex Query

    Do you have an index on ID? If not it would also help to fasten your query.
  6. CD12

    Help speeding up a Complex Query

    I don't know if this will work foryour data base, it did work on my Oracle data base. Insted of a cursor and loop I just used an update statement: UPDATE tablename t1 SET t1.ItemID = DECODE( t1.ItemID, null, ( SELECT MAX(t2.ItemID) FROM tablename...
  7. CD12

    SQL SUM Function

    Try: SELECT SUM( Payment ) FROM ( SELECT DISTINCT e.description, SUM(a.hectares) Area, b.rate, SUM(a.HECTARES * b.RATE) Payment, c.occ_id FROM G_FIELD_AREA_ZONATION a, G_PAYMENT_RATE b...
  8. CD12

    ORA-00600 Internal Error

    I the error was raised during compilation. I don't know about the error number, but usually when I get the error message "Internal Error" I close the form, open it again, and compile it again, then it usually works.

Part and Inventory Search

Back
Top