Hi,
I'm writing a C# web service that takes a last name and searched a customer database (Oracle 10g) and returns a record. I am having trouble with searching for names that contain an apostrap...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23239932.html
I installed Oracle 11g database on fedora 7 linux. I did not document the summary installation which has all the information about the database I created. I would like to launch the database consol...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_22912470.html
Hi,
I'm failry new to Oracle 11g. I'm trying to upload an XML document via the native web services from a client and can't figure out how. Can someone point me in the right diretcion on ...
http://www.experts-exchange.com/Database/Oracle/11.x/Q_23135687.html
I am attempting to add a foreign key to a table that I have already created and getting an error.
The method used to create the table was as follows:
create table lab_employee (
EMPNO NUMBER...
http://www.experts-exchange.com/Database/Oracle/Q_23160813.html
I started installation of OCS at RHEL but i've been halted due to the error (attched)
http://www.experts-exchange.com/Database/Oracle/11.x/Q_23437849.html
Zones:
Oracle 11.xDate Answered: 05/28/2008 Rating: 9.3 Views: 0
TYPE priceindex_cur IS REF CURSOR;
v_priceindex_cur priceindex_cur;
l_priceindex xpriceindex.priceindex%TYPE;
BEGIN
OPEN v_priceindex_cur FOR
SELECT priceindex FROM xpriceindex ...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23664082.html
SELECT * from loadshapevolume where loadshape, t begtime in (select loadshape,begtime from xloadshape_stage WHERE t.begtime < begtime);
I need to select from if it is in a table then compare b...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23671679.html
I have a freshly installed Oracle 11g environment with the standard SYSTEM and SYS ids. I am attempting to connect to the database using a web application (MapViewer) using a JDBC connection. If I ...
http://www.experts-exchange.com/Database/Oracle/Q_23878315.html
How do I convert decimal data type to integer and char(8) data types
table name
titles
column name
PRICE
21.99
19.95
39.95
12.99
6.95
19.95
23.95
10
13.95
This is an example f...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23899591.html
I need some advice.
1. Is the best way to index on a unique values to see the most benefit, or is it better to index off non unique values that will always be used in the where clause's of my SQL...
http://www.experts-exchange.com/Database/Oracle/11.x/Q_24009285.html
