oracle

Good pl/sql ebook or video tutorial which are available free for download

Please can anyone tell me of sites i can access to download free oracle pl/sql ebooks or video tutorials? Thanks. Moze ...

Oracle RMAN big-endian to little-endian

Hi All, I have an Oracle RMAN backup that was created on a Solaris SPARC box and is therefore in big-endian format. I wish to restore this backup to a Windows x86-64 based machine but have hit a roadblock due to the endianness issue. I have read on Wikipedia http://en.wikipedia.org/wiki/Endianness#Endianness_in_files_and_byte_swap that...

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...

XOR Constraint in Mysql

Hi. I want to implement a kind of xor constraint on foreign keys in mysql 5.1 There is this table, let's say Entity which can refer to two different kinds of valuesets represented by Tables ValsA and ValsB. Now I would like to implement a constraint wich makes sure that exactly one of those two is mapped, and the other one isn't. In ...

Can I use inline views with the criteria API?

Does NHibernate support inline views using criterias? Google doesn't seem to return any relevant results. Here is the query I need to convert preferably using criterias. SELECT COUNT (incident_count) AS incident_count, SUM (total_customers) AS total_customers, MAX (longest_etr) AS longest_etr, COUNT (DISTINCT crew_c...

How much costs the Oracle ADF Framework?

I would like to develop applications using Oracle ADF Framework. How is the licensing? How much costs to develop and deploy applications to my customers with this amazing technology. ...

Smart Oracle tool to find missing field relationships

Does Oracle have a tool I can use to analyze a database and help determine possible missing field relationships? We have a legacy database with 150+ tables and many relationships are missing. We could go through it by hand but an automated tool might be useful. So find things like missing foreign keys and whatnot. ...

In Oracle, how do you select multiple values from a related table and store them in a single column?

I'm selecting columns from one table and would like to select all values of a column from a related table when the two tables have a matching value, separate them by commas, and display them in a single column with my results from table one. I'm fairly new to this and apologize ahead of time if I'm not wording it correctly. ...

can't merge a union all view

I know Oracle RDMS can't merge a view that has a set operator in it. I want to know why is that. For example, this: SELECT u.* FROM ( SELECT a.a1 A, a.a2 B FROM tab_a a UNION ALL SELECT b.b1 A, b.b2 B FROM tab_b b ) u, tab_p p WHERE p.a = u.a could be transformed into this: SELECT * FROM ...

PL/SQL - Use of variables in nested queries

Hey, I'd like to do something like this with PL/SQL: for ACCOUNT in account_cursor loop for related_data in (select something from table where some_column = ACCOUNT.column) loop endloop; endloop; (caps for emphasis) I'm away from my dev environment so I can't test this out, so please ignore any minor syntactical...

ORA-06550, PLS-00306; Error inserting data to Oracle procedure.

Hi all, I have tried to troubleshoot this problem but to no avail. I get error while inserting a big chuck of data to Oracle package containing procedure 'INSCRAPP'. The error message is, ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'INSCRAPP' ORA-06550: line 1, column 7: PL/SQL: Stat...

Calling an excel function from oracle forms

Can anyone suggest how I can use ole2 to perform an excel function (e.g. PMT()), from oracle forms and get back the result?? ...

Different value of date display between database and data table

I have a problem with display of dates from Oracle database in a Java webapplication using a JSF datatable. The displayed date differs from the date in the database. Here are some examples: in oracle: 24-APR-87 display in datatable: Apr 23, 1987 in oracle: 01-JAN-10 display in datatable: Dec 31, 2009 in oracle: 13-MAR-89 display in...

sql query on dual

This: select * from dual connect by level <= i ...will return result as 1 2 3 ... i Can the query be modified to get result row wise? i.e 1 2 3 .....i ...

ORA-12638 Credential retrieval failed and ORA-01031: insufficient privileges

in sqlnet.ora file: when i have SQLNET.AUTHENTICATION_SERVICES= (NTS) i can't connect by PL/SQL developer arises "ORA-12638 Credential retrieval failed" ,but can connect by command line when i have SQLNET.AUTHENTICATION_SERVICES= (NONE) i can't connect >sqlplus / as sysdba arises "ORA-01031: insufficient privileges" ,but can co...

How to Oracle XMLTYPE in Hibernate

One of the column is of the type XMLTYPE in Oracle database. In my application, I want to persist the data and using Hibernate. I did the following for mapping XMLTYPE in hibernate Define the custom user type implementing UserType The custom user type implementation is based on the blog link - http://community.jboss.org/wiki/MappingOr...

Convert comma separated string to array in PL/SQL

How do I convert a comma separated string to a array? I have the input '1,2,3' , and I need to convert it into an array. ...

Encountering ORA-00979: not a GROUP BY expression when using CASE - IN statements in sql

This works: SELECT (CASE WHEN x = 'value' THEN a.col1 ELSE nvl(a.col1, a.col2) END) FROM table1 a WHERE a.this = 'that' GROUP BY (CASE WHEN x = 'value' THEN a.col1 ELSE nvl(a.col1, a.col2) ...

Normalizing a table: finding unique columns over series of rows (Oracle 10.x)

Hello, I have a table with the following structure: WorkerPersons ------------------------------- ID (PK) PersonID (Indicates which version of Person the record describes) SomeColumn1 (data specific to Worker) SomeColumn2 (data specific to Person) .... SomeColumnN ------------------------------- As you can see, it's a den...

Java: Send array to a PL-SQL function

I need to pass an array of objects to a PL-SQL function My ORACLE code: CREATE OR REPLACE TYPE uu.ITEMTAB AS TABLE OF ITEMREC; / CREATE OR REPLACE TYPE uu.ITEMREC AS OBJECT (ID NUMBER, NAME VARCHAR2(30)) / Java class public class ITEMREC { private int ID; private String NAME...