Oracle Help
in [SQL]
|
Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE Hello, I have a (application-)database which is filled with polygons, also there is a administrative coupling on a guid. The guid is unique for the administative part, but can contain more than 1 polygon. For this reason i want to union the polygons, so i have 1 geometry for 1 guid. Well, i managed to do this tr... 19 Jun 2008 01:14
How to create a sequence with a dynamic start value Hello, what is the best way to create a sequence with a dynamic start value. The following statement is not valid: create sequence TEXT_SEQ start with select NVL(max(ID),0) + 1 from TEXT; Thank you, Norbert ... 19 Jun 2008 01:14
11g OEM - dictionary comparison - Selecting another databaseinstance for comparison Luch wrote: Using 11g OEM (via https://machine:1158/em/) With Oracle 10g OEM, the desktop version, I could use the "Change Manager" program to compare two database instances. With the 11g web-version... I'm not seeing how to select either the "left" or "right" database to be a database instance, ... 19 Jun 2008 01:14
MS-Access to Oracle Moving tables from MS-Access to Orcale 10g changes double field types to Varchar2. Any ideas why and suggestions on how to get them to numerics? Thanks, Tim Mills-Groninger ... 19 Jun 2008 01:14
11g OEM - dictionary comparison - Selecting another database instance for comparison Using 11g OEM (via https://machine:1158/em/) With Oracle 10g OEM, the desktop version, I could use the "Change Manager" program to compare two database instances. With the 11g web-version... I'm not seeing how to select either the "left" or "right" database to be a database instance, other than the database th... 19 Jun 2008 01:14
user_updatable_columns if i select * from user_updatable_columns i get information if column in table is updatable or not, insertable or not, deletable or not. What makes column updatable, insertable, deletable?? Primary key, not null constraints..?? please clear my mind! ... 19 Jun 2008 01:14
user_updatable_columns if i select * from user_updatable_columns i get information if column in table is updatable or not, insertable or not, deletable or not. What makes column updatable, insertable, deletable?? Primary key, not null constraints..?? please clear my mind! ... 19 Jun 2008 01:14
slow forms on win 2003 terminal server "Andreas Moroder" <Andreas.moroder@[nospam]sb-brixen.it> schreef in bericht news:g2jd0k$732$1(a)news.dtag.de... Hello, we have a forms 10 application that run very well on a win 2000 server. Now we migrated to a win 2003 TS and the application became very slow. When we type then the characters appe... 19 Jun 2008 01:14
Recompiling invalid objects with a batch file gazzag schreef: Sorry, in my previous post "ALTER <object_type> <object_name> RECOMPILE;" should be "ALTER <object_type> <object_name> COMPILE;" COMPILE *not* RECOMPILE. Apologies. Plus you should cater for package bodies, where the syntax is alter package amehoela compile body; ... 11 Jul 2008 10:57
PHP and Oracle Client Scenario: - Windows Server 2003 - Apache 2.2.8 (latest) - PHP 2.2.6 (latest) - Oracle 10g (remote machine) - Oracle Client 10g Express Edition I spent a couple of hours trying to figure out why PHP would not connect to Oracle using OCI8 functions while ODBC functions and TOAD worked fine. I eventually lau... 19 Jun 2008 01:14 |