oracle10g

How to specify an attribute "nullable" when creating a table, in oracle?

As title says, should I just add a nullable keyword as a constraint? ...

What is the best way of define "ENUM" data type when creating a table in Oracle 10?

For example: I want a data type called season (= { spring, summer, fall, winter} ...

How do I specify a candidate key and a foreign key when creating a table in Oracle 10g?

How do I specify a candidate key and a foreign key when creating a table in Oracle 10g? ...

Hibernate/Oracle seqhilo generator

Hi, I'm trying to configure a seqhilo generator for a Hibernate application on Oracle. <id name="idTest" type="int"> <column name="ID_TEST" precision="6" scale="0" /> <generator class="seqhilo"> <param name="sequence">S_TEST</param> <param name="max_lo">1000</param> </generator> </id> I created...

Oracle Script problem - create trigger not terminating

I am trying to make some changes to an oracle database and have a script put together to do so. The problem is when it gets to a point in the script where I am creating a trigger it seems like the Create Trigger block does not properly terminate, when I look at the trigger afterwards it contains all of the remaining code in the script. ...

How to use "as" to set alias for joined tables in oracle 10

I wrote this, and it is wrong syntax, help me fix it, I want 'T' to be an alias of the result of the two inner joins. select T.id from table1 inner join table2 on table1.x = table2.y inner join table3 on table3.z = table1.w as T; ...

Add Oracle DB as Linked Server

Hi everyone, I am using Windows 7 64 bit, but my Oracle Server I am trying to connect is 32 bit, and so is the SQL Server 2008 and Oracle Client on my machine. I have installed Oracle 10g client (32 bit) with administration tools on my machine and setup Net Services to connect to database. I can connect to all the databases through SQL...

BigDecimal to SQL NUMBER: check for value larger than precision

In my app, I handle numbers as BigDecimal and store them as NUMBER(15,5). Now I'd need to properly check on Java if the BigDecimal values would fit the column, so that I can generate proper error messages without executing the SQL, catching exceptions and verifying the vendor error code. My database is Oracle 10.3, and such errors cause ...

In Oracle, is using Sequences for surrogate primary keys considered standard

Caveats: Let me first clarify that this is not a question about whether to use surrogates primary keys or not. Also, this is NOT a related to identities (SQL Server) / Sequences (Oracle) and their pros / cons. I did get a fair bit of idea about that thanks to this, this and this Question: I come from a SQL Server background and have...

Oracle 10g and PHP

HI I've converted a call center app from Oracle Forms into a web app using PHP i am using oci_pconnect() to connect to the DB but we are seeing very high connections (in excess of 40 000 a day) because each user has a unique username and password. this is obviously killing the DB any advice on best practices to minimize the impact or r...

ORA-00054 while loading large data file

I get ORA-00054 while loading large data files(~ 10 gb) The error occurs when this a new file is loaded after a previous file. Any ideas how I can solve this? ...

how to resolve recompile problem with oracle dblink?

I used a dblink like '@dblink' in oracle procedures,but when i recompile it,it faild.And errors are below: ORA-04052:error occurred when looking up remote object OPENEAP.SYS_FILE@V_DBLINK.REGRESS.RDBMS.DEV.US.ORACLE.COM ORA-00604:error occurred at recursive SQL level1 ORA-02019:connection description for remote database not found Code...

Flex with Oracle 10g

Hi, I am new to Flex 3/4 and was after some help with what is involved (examples pls) in creating an application in flex that runs off an Oracle 10g database to both retrieve/modify data from, with flex. Basically would like to know how to connect flex to an oracle database to perform database transactions like updates/deletes/inserts....

Retrieving Weekend Data Rows Only in Oracle

Hi, How to query rows in a table where the created_date column value in the table falls on a weekend date ONLY, i.e. Saturday/Sunday using Oracle SQL.. Thanks ...

Call for a function with a variable name?

I have one package that has different procedures, and one main procedure through which I am calling other procedures. Through the front end, I am passing the procedure name into main(). Is there any way by which the procedure can be called just writing the parameter name containing('Procedure Name that is need to be called')? CREATE O...

Switching from Oracle 10g Express to SQL Server Compact (NHibernate)

Hey, I am switching my application from Oracle 10g to SQL Server Compact. Currently I have this in the mapping file: <id name="Id" column="MY_ID"> <generator class="sequence"> <param name="sequence">MY_SEQ</param> </generator> </id> and I have been informed that sequence does not exist in SQL Server Compact, I was wondering i...

What is the equivalent of IBM's SYSIBM.SYSTABLES in Oracle?

Hi, What are the equivalent of SYSIBM. in Oracle? ...

Finding total deductions based on sum of prior rows in SQL

I've got a rather tricky problem that I've been trying to solve for the past few days. I am currently solving it with the Oracle SQL Model clause and could probably have written a function but I'm looking for a nice simple solution using analytic functions or something but can't figure anything out. For a given policy (ddpsid), I want t...

Oracle license for development environment?

Hi I'm sorry that I have to ask that here, but I haven't found a conclusive answer on the oracle page or in the internet. I've even been on the phone with a sales rep, but they couldn't help me neither. What kind of Oracle Setups/licenses are you using for your development environments? We currently are using 10g XE which only has one...

OC4J 10.1.3.3 unable to find ojms.rar setting up database persistences

Howdy, I'm running into problems with JMS in Oracle AS 10.1.3.3. The error I am getting is 'connectors\ojms.rar (The system cannot find the path specified)' from EM. Below are a few bullets on the environment. This is on a Windows XP SP3 machine. All configuration is through EM. The EM is a local instance that has been used for ov...