Top "Oracle10g" questions

Oracle is an RDBMS product.

Oracle Function: Replicate wm_concat

I currently am working on a project within Crystal Reports that refuses to use the undocumented function WM_CONCAT, which …

oracle function oracle10g string-aggregation wm-concat
How can I run Oracle XE on localhost only?

Is there a way that I can configure a XE installation on Windows to only use ports on the localhost …

oracle oracle10g oracle-xe
How to produce rank in Oracle

Need to rank the below by salary, with highest salary having rank 1. The RANK column shown is what I'm after: …

sql oracle oracle10g analytic-functions top-n
Oracle XE - Just can't login after install

That sounds really stupid. On Lubuntu 10.10, I did: echo "deb http://oss.oracle.com/debian unstable main non-free" >> /…

linux oracle oracle10g ora-01017
Is dbms_output.put() being buffered differently from dbms_output.put_line()?

Im using Aqua Data Studio to debug a stored proc by scattering output statments throughout. I have a delete statement …

oracle plsql oracle10g dbms-output
Oracle SQL XML Functions - How to get encoding in XML Prolog?

This SQL SELECT XMLRoot(XMLType('<poid>143598</poid>'), VERSION '1.0', STANDALONE YES) AS xmlroot …

sql oracle oracle10g sqlxml
How to undo ALTER TABLE using sqlplus (Oracle 10g Express)?

rollback; doesn't seem to undo alter table changes. Background: I'm generating some .sql scripts (based on parsed Hibernate scripts) which …

oracle10g sqlplus rollback alter
Using ouput parameter of type SYS_refcursor

In my database I have a stored procedure with an OUTPUT parameter of type SYS_REFCURSOR. The application side is …

c# stored-procedures oracle10g out-parameters sys-refcursor
ORACLE/ASP.NET: ORA-2020 - Too many database links... what's causing this?

Here's the scenario... We have an internal website that is running the latest version of the ODAC (Oracle Client). It …

asp.net oracle oracle10g database-link
Message file \ORANT\DBS\FMCUS.MSB not found Oracle Forms 6i

I install Oracle Developer Suite 6i on Windows 10 Professional 64-bit, but when i run form builder, its give the error \…

oracle oracle11g oracle10g registry oracleforms