Top "Oracle10g" questions

(Oracle) How get total number of results when using a pagination query?

I am using Oracle 10g and the following paradigm to get a page of 15 results as a time (so that …

sql oracle oracle10g

Date type without time in Oracle

In Oracle 10g I got a problem when using DATE type in my table. I just want my DATE field …

oracle datetime date oracle10g

Oracle's dbms_metadata.get_ddl for object_type JOB

I'd like to create ddl scripts for most of my database objects. dbms_metadata.get_ddl works for most of …

oracle oracle10g jobs ora-06512 dbms-metadata

Viewing oracle app and getting: java.lang.ClassNotFoundException: oracle.forms.engine.Main

I'm trying to debug an oracle forms application. In production, when I load the application I get an error: java.…

java oracle internet-explorer oracle10g oracleforms

Oracle: importing data pump dump without knowledge dump file content

Old approach for exporting/importing whole schema: exp user/pwdp@server FILE=export.dmp OWNER=user ROWS=Y imp newuser/…

import oracle10g impdp

How to convert a CLOB data type to a String in Hibernate?

In hibernate (3.2.1.GA), I use the following method to insert CLOB type data into Oracle (10g) database. Hibernate.createClob(parameters.…

spring hibernate oracle10g clob

SQL Query Select first rank 1 row From Multiple ranks/Group

I have following data Table1 id col1 col2 col3 ---------------------------------- 1 abc 01/01/2012 - 1 abc 01/01/2012 A 2 abc 01/01/2012 - 2 abc 01/02/2012 - 3 abc 01/02/2012 - 3 …

sql oracle oracle10g dense-rank

Access right on synonym and underlying table

1/ How are privileges on synonyms and underlying objects related ? If one has rights on synonym, would he automatically has rights …

oracle oracle11g oracle10g privileges synonym

How to execute a procedure with DBMS_SCHEDULER.CREATE_JOB procedure

I want to create a job that would drop a database object at a given date. The job created all …

oracle oracle10g dbms-scheduler

How to use DBMS_CRYPTO.encrypt function in oracle

I want to encrypt password column in the database and I am trying to use encrypt function present inside DBMS_…

database oracle oracle11g oracle10g database-administration