Oracle Help
in [SQL]
|
what are the different between database migration and database upgration? what are the different between database migration and database upgration? ... 18 Jan 2008 13:18
user defined data type: does they exist ? I'm migrating an application from sql server to oracle. We have tables with column that use user defined data type, for example CREATE TABLE AA ( Column1 CODE ) Where CODE is defined as varchar(50) Is there a way to create an equivalent CODE in oracle ? ... 28 Jan 2008 15:56
partitioning table with sequence made in java base 36 hi everbody, i would to partition by range a big table (more than 10millions of rows ) on a aprt of the primary key which is a java sequence in base 36 . I intent to use dbms_redefinition but i am wondering how to use the sequence (or the converted sequence in base 10) regards ... 17 Jan 2008 04:04
help regarding sql loader Hi I have a table Test: id number default -999 occ varchar2(25) default 'student' addr varchar2(25) qual varchar2(100) secid varchar2(25) default 'h-000' primary key: id, occ, secid I am using sql loader to load data into the table. The ctrl file is : LOAD DATA ... 18 Jan 2008 13:18
Clear case developer position in Roseville, CA Hi, We have an Immediate Opportunity for you as clear case developer. Location : Roseville, CA. Employment type : 6-12 months. Job Description: Client is looking for contract resource for a period of 6-12 months to support our software configura... 16 Jan 2008 13:04
Oracle Index Question I work primarily in SQL Server and have run across a situatiion in Oracle that's troubling me.... I have a query that contains a where clause with 2 restrictions. Both these fields are in a composite index of 3 fields. If I add the third field to the restriction the optimizer uses the index, however if i keep ... 16 Jan 2008 14:46
count(*) ? I understand that when you feed the count( ) function an asterisk as an argument it runs slower than if you use a column name as an argument. Can someone tell me why this is so? Thanks ... 17 Jan 2008 08:09
Oracle to C# mapping Hi, Is there a possibility of direct mapping C# class to PL/SQL records, and vice versa, in Oracle 9i with ADO.NET. I need to map some simple records (NUMBER,DATE,VARCHAR2) to classes with simillar fields. Thanks for any kind of info (links etc). ... 15 Jan 2008 12:14
XMLType: bytes written before prologue Hi NG, I have a very general question concerning the XML-abilities oracle offers, and I'm afraid I cannot restrict the field of possible causes for this kind of error: When performing a query where an XMLType is returned, in some cases 4 or 8 bytes are written before the prologue. Did anyone else observe this be... 19 Jan 2008 12:10 |