We recently upgraded开发者_如何学运维 to 10g and I\'ve noticed that metadata queries seem to take an extraordinarily long time (at a guess 2-5 times slower than on 9i).Has anyone else noticed this?Any
using a Oracle 10g db I have a table something like this: create table x( ID NUMBER(10) primary开发者_如何学JAVA key,
Within Crystal Reports XI I\'m trying to have a SQL Expression Field with Oracle 10g function wm_concat(column_name).It appears that 开发者_运维问答Crystal Reports XI is not handling this function pro
Friends, I\'m facing another challenge in APEX and I hope you can help. I have created a tree using the method described in John & Scott\'s superb book, \"Pro Application Express\" whereby the
I have created a list item to be used as the primary navigation within my APEX application. The tree can be expanded and clicking on a leaf node takes you to the correct page. However, on arrival at
When I have two sql-files, one of them in a sub-directory main_test.sql sub/sub_test.sql and sub_test.sqlcalls @../main_test.sql (or @@../main_test.sql) then this works fine when executing it from
/* This script was suppose to insert oneaccount for each rowand every dates and paymentsassociated with thataccount base on the each sequence from 1- 12representing each month , Instead the script is
I\'m trying to use a pipelined function to save on time and reduce redundancy in my queries. The function in question returns data from a reference table based on some input. Records in the main data
I have a stored procedure in an Oracle 10g database, in my java code, i call it with: CallableStatement cs = bdr.prepareCall(\"Begin ADMBAS01.pck_basilea_reportes.cargar_reporte(?,?,?,?,?); END;\", R
I\'d like to do the following in Oracle 10g (this is a contrived example to show the concepts, not real code)