Search results for query: *

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

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

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

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.

Do you have an index on ID? If not it would also help to fasten your 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...

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

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.