Category "oracle12c"

Need to get appropriate/expected row number in Oracle PLSQL

Getting the following output when i use the below query SELECT P.RefNum ,Ian.ID ,Ian.Date ,Igl.Name ,Ian.Comments ,ROW_NUMBER() OVER (

Achieve "all-or-nothing" transaction between Oracle and MongoDB

I have an usecase(migrate data from Oracle to MongoDB via Java app) where I required to implement transaction management to ensure "all-or-nothing" in the datas

Convert the total amount in words

I'm converting my total amount into words using bi publisher. Btw, the amount is base on the data from the data set. Can someone help me what to do? Thanks <

ADF validations and mandatory fields

I need to add a validation in the following way. There's a drop-down list with two attributes(let them be A1 & A2) and an Input Text box. I need to let the

How to install Oracle Instant Client on a Mac?

How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the fil

How to install Oracle Instant Client on a Mac?

How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the fil

ora-09925 unable to create audit trail file no such file or directory

I have just installed a oracle 12c 12.1.0 DB on a linux machine. after completing the installation i tried to login to database as sysdba [oracle@bjorn adump]

When logging in to Oracle Enterprise Manager, it is asking me for the credentials again. Why?

I'm trying to log in to: https://localhost:5500/em/login First, I entered my credentials at the bottom right area. Then, I clicked the button. After that, a po

Oracle 12c: TNS-12535: TNS:operation timed out

We have a new database server on RHEL 7 and Oracle 12c. The old database server is RHEL 4 and Oracle 10g. I need to dump the data using the 12c client from the