Top "Oracle10g" questions

Oracle is an RDBMS product.

How to reuse the Unused columns again in oracle DB

I have a table with 4 column, ID, NAME,AGE and COUNTRY. For some time being purpose i have set my …

oracle10g sql-drop
Can I use Oracle JDBC 12.1.0.1 (for 12c database) on a Oracle 10g database?

Just a simple question (I guess). Oracle released a new JDBC driver for Oracle Database 12c including a Java 7 JDBC …

java oracle jdbc oracle10g oracle12c
How can I speed up row_number in Oracle?

I have a SQL query that looks something like this: SELECT * FROM( SELECT ..., row_number() OVER(ORDER BY ID) rn …

sql oracle oracle10g row-number
An Oracle database user cannot create a DB job even with relevant privileges

I have an Oracle database user named "ADMUSER" with following privileges, which are the required privileges for creating a database …

oracle stored-procedures oracle10g dbms-scheduler
Oracle XE 10g Ubuntu removed from oracle web site?

I can't find Oracle XE 10g anymore on Oracle web site. I'm using 32 bit GNU/Linux Ubuntu 12.04. There's only 11g …

ubuntu oracle10g oracle-xe
How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?

In MS SQL Server if I want to check the results from a Stored procedure I might execute the following …

oracle oracle10g oracle-sqldeveloper
Set named parameter for Oracle dbms_scheduler job stored procedure

Is it possible to passed named arguments to for dbms_scheduler job with a type 'stored_procedure' ? I've tried this …

stored-procedures plsql oracle10g named-parameters dbms-scheduler
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I'm very new on Database subjects and trying to do some beginner stuff with connecting from Netbeans. but when i …

database oracle10g tns
Using Spring's KeyHolder with programmatically-generated primary keys

I am using Spring's NamedParameterJdbcTemplate to perform an insert into a table. The table uses a NEXTVAL on a sequence …

spring oracle10g primary-key jdbctemplate spring-jdbc
How to connect to newly installed Oracle XE instance?

I have installed Oracle XE on Win7 x64 machine. Installation completed successfully without problem, or perhaps installer didn't tell about …

oracle oracle10g oracle-xe