Oracle
in [SQL]
|
LIKE operator on CHAR column when there is no wildcard character We are trying to upgrade our database from Oracle 9i to 10g. We have a CHAR(30) column in a table. When we perform string comparisons using '=' operator (Eg.....where col = 'XYZ' ) the trailing spaces are ignored, which is perfectly fine (both in 9i & 10g). When we use LIKE operator without specifying any... 9 Jul 2008 05:29
Trasaction between procedure calls. Problem Statement: Ive written a Stored Procedure which has several insert statements. After inserting these statements ,its calling other stored procedure which again has some insert statements. Now if the second procedure has some error, everything should be rolled back. The skeleton of the procedure is as fo... 7 Jul 2008 00:13
create two database Hi guys, I created two database but I have some problem : 1.How I can startup two data base or one of them ? 2.After create second database the listener is point on first data base ,How I can start listener for second database ? 3.Can not login to second database? Thanks ... 8 Jul 2008 21:19
JDBC Driver 8.1.6 Hello, Is it possible to download somewhere JDBC Driver 8.1.6 ? I would need to connect an old Oracle 7 database (The oldest one I found is 8.1.7) Thanks in advance. ... 5 Jul 2008 15:35
is there anyway to get the 10g|11g DBMS_CRYPTO stuff for 9i? hello forum, i know about DBMS_OBFUSCATION_TOOLKIT in 9i. but, is there anyway to get the 10g|11g DBMS_CRYPTO stuff for 9i? for example, if i get a hold of {ORACLE_HOME}/rdbms/admin/dbmsobtk.sql from a 10g/11g installation, would it work if i plonk it into my 9i installation? if so, what else would i need to ... 7 Jul 2008 09:24
Oracle support is sub-optimal On Jul 4, 3:27 pm, "gym dot scuba dot kennedy at gmail" <kenned...(a)verizon.net> wrote: snip I hope Oracle isn't going the way of the Detroit Auto makers of the early 80's until very recently. Think you have no competition and then just have quality and customer service suck. Ummm well not exactly. F... 10 Jul 2008 02:02
create database fatal error Hi I am having some serious problems with my create data procedure. After the CREATE DATABASE statement i run the catalog.sql and catproc.sql scripts. During the catproc script it after a while encounters a massive amounts of errors ending up in a fatal error whihc terminates the session. All statements afte... 8 Jul 2008 14:07
Fresh Enterprise Manager Install Can't connect "Connection Closed" DavidK wrote: On Jul 3, 2:18 pm, DavidK <davidknollh...(a)yahoo.com> wrote: On Jul 3, 1:57 pm, sybra...(a)hccnet.nl wrote: On Thu, 3 Jul 2008 12:59:40 -0700 (PDT), DavidK <davidknollh...(a)yahoo.com> wrote: I've an 8.1.7 oracle home on an xp pc. I installed OEM 9.2.0.1 of cli... 4 Jul 2008 00:49
SELECTing from a DML statement DB2 allows one to select from an insert, update, or delete, e.g.: select * from old table (delete from x where y = 1); --OR-- select * from new table (update x set y = 1 where z = 2); --OR-- select * from final table (insert into x (c1) values (1)); Is there any equivalent in Oracle? Thanks and reg... 4 Jul 2008 15:07
ASM I/O size Hello, I'm running under 10.2 database on AIX5.3L I have disk group ASM_DATA which has 100 SAN equi-sized (256GB) disks/ luns. with MBRC of 16 & Block size of 16K , When I read a table of 10GB via FTS, what should be my I/O size/lun ? Should my I/O size be same for all the LUNs? 1) ASM level 2) I/O stats (io... 7 Jul 2008 12:29 |