Oracle Tag Directory

Featured Oracle Questions

Export row of table and all its children in Oracle Database 11g
Is there a way in toad to export the row of a table and all of its children in Oracle Database 11g?

Answer Question   |  April 14, 2014  1:58 PM
Oracle 11g Database
asked by:
5 pts.

How to uninstall Oracle 11g
I am a beginner with oracle I just installed it, but after 1 day it’s SQL plus window starts showing an error “an initialization or shutdown in progress” I already ran some commands like “database pluggable all open” and “instant startup or shutdown”, shown on your site yet not working, so I wanted to reinstall...

Answer Question   |  March 4, 2014  10:56 AM
Oracle 11g
asked by:
5 pts.

Hi, I need some serious help here..I use OAS I deployed my ear file to the OC4J container. And everytime I access the webpage I get this error. 500 Internal Server Error java.lang.ExceptionInInitializerError at com.experio.common.util.AppUtil.getInitialContext( at com.experio.common.util.AppUtil.createEJB( at com.experio.common.util.AppUtil.createEJB( at com.experio.common.util.Debug.println( at com.experio.web.control.Entry.service( at javax.servlet.http.HttpServlet.service( at com.evermind[Oracle Application Server Containers for J2EE 10g (].server.http.ServletRequestDispatcher.invoke(

Answer Question   |  February 7, 2014  11:40 PM
Java development, JDeveloper, Oracle 10, Oracle Application Server, Oracle development, Oracle JDeveloper, Web development
asked by:
5 pts.

Hi all, i have to import excel data of two column into oralce forms 6 i on button pressed trigger. can any one help me in this regard with source code. thanks a lot in advance

Answer Question   |  December 23, 2013  9:55 AM
EXCEL DATA, Import, Oracle 6i
asked by:
5 pts.

How to redirect to different page after login in APEX 4.1
Dear All, Here is my requirement is: When the users login the username = Raj should be redirected to page 1 and username = vikram should be redirected to page 2 when they entered their username and password and pressed login button. How can I do this? Please give some suggestion. Thank you. regards, Gurujothi

Answer Question   |  December 9, 2013  11:05 AM
Oracle Apex, Oracle Apex 4.1
asked by:
5 pts.

Wanted to configure PGP on Oracle applications R12
Hi, We are currently on Oracle Applications R12 based on Unix Platform.  We have a requirement to encrypt the files using the PGP key and FTP to another server. The other server will require to decrypt these files. Can you please let me know from where I have to start? Do we need any configuration on...

Answer Question   |  December 9, 2013  6:45 AM
Oracle applications, PGP, Unix
asked by:
5 pts.

Is D2K is compatible with Oracle 12 or 11
Is D2K is compatible with Oracle 12? My application has been developed in D2K and with database Oracle 8i. Now I want to change Oracle 8i to Oracle 11 or Oracle 12.

Answer Question   |  November 18, 2013  9:11 AM
D2K, Oracle 11, Oracle 12
asked by:
5 pts.

How do I concatonate the data from the same field from multiple rows
I need to concatonate data from the same field with multiple rows with a one to many relationship. For example: oder_id product 503 corn 503 beans 503 Apples the end result wanted would be a single row order. _id products 503 corn, beans, apples

Answer Question   |  November 5, 2013  5:34 PM
Oracle 9, Oracle 9 Database, Oracle Data Access, Oracle Developer
asked by:
5 pts.

Oracle Application Express 11g xe
I have Oracle Application Express 11g xe installed and when I attempt to create a workspace (PM) I get a error saying invalid or restricted workspace. I am not sure as to how to fix this. I and cannot find the solution. Can anyone give me some instruction or directions. Thank You Steve Walker

Answer Question   |  October 30, 2013  9:41 PM
Oracle Application Express, Workspace
asked by:
5 pts.

Oracle Forms 6i – “when timer expired”
I don’t know the logic of “When Timer Expired” trigger in forms 6i. Can someone please explain it (with examples)?

Answer Question   |  October 28, 2013  3:48 AM
Oracle 6i, Oracle Forms, Oracle Forms 6i, When Timer Expired Trigger
asked by:
40 pts.

SQL Server restore job fails
I’ve created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev 16: RESTORE...

Answer Question   |  October 16, 2013  3:46 PM
Backup & recovery, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, SQL, SQL Server
asked by:
0 pts.

Steps to install oracle 8 on windows 7
What are the steps to install Oracle 8 on Windows 7?

Answer Question   |  October 12, 2013  3:48 AM
Oracle 8, Windows 7
asked by:
15 pts.

Oracle 9i Migration from Solaris to AIX
Hi, We have to migrate the Oracle 9i Database from Solaris 2.8 to AIX 6.1. There are two databases of 500 GB and 1.5 TB respectively to be migrated. I did go through an article from Maria Anderson (Production DBA, Autodesk at but the article was from 10-09-2006. Is the solution provided still stands...

Answer Question   |  September 23, 2013  10:48 PM
Database migration, Migration, Oracle 9i, Solaris, Solaris to AIX
asked by:
5 pts.

Access Oracle Database via Internet
I want to access Oracle Database via internet. Please tell me about it and the steps required. How can we deploy Oracle Forms 6i on Web.

Answer Question   |  September 17, 2013  10:12 AM
Oracle, Oracle Access Manager, Oracle Database, Oracle Forms, Oracle Forms 6i
asked by:
35 pts.

Escalation module with Oracle 9i and Oracle Forms 6i
We are developing customer care software working on Escalation Module. Here my system should generates an email to executive or technical head if complaint doesn’t get resolved within 3-hrs. I’m using Oracle 9i and forms 6i as front end. I have two points to be discussed. If complaint occurs at 10.00 am, so it should...

Answer Question   |  September 11, 2013  11:43 AM
Oracle 9i, Oracle developers, Oracle Forms 6i
asked by:
25 pts.

Installation of Oracle 9i in 2008 Server
jrew.exe has stopped installation. What should I do?

Answer Question   |  August 31, 2013  7:40 AM
HP Compaq Pentium 4, Oracle 9i, Oracle 9i installation, Oracle 9i installation errors
5 pts.

Oracle Forms 6i next button coding
I need to know the coding for NEXT BUTTON in oracle forms 6i, when the fields are not database items…. I want to fetch next record after pressing NEXT BUTTON…I have applied select query and tried to store the fetched records in fields of the form….but in vain…i got no output in the screen…just the...

Answer Question   |  August 29, 2013  11:07 AM
Oracle 6i, Oracle administration, Oracle Forms, Oracle Forms 6i
asked by:
5 pts.

To delete the duplicate record from Oracle table.
How do I delete the duplicate a record from an Oracle table? Please provide the command.

Answer Question   |  August 28, 2013  8:22 AM
Oracle commands, Oracle Tables
asked by:
5 pts.

How to get value from barcode scanner using Oracle forms 6i
How can Oracle forms 6i get the value directly from barcode scanner.Can forms 6i interact directly with such hardware, if so then how… plz help.

Answer Question   |  August 28, 2013  5:25 PM
Barcode scanners, Oracle 6i, Oracle Forms, Oracle Forms 6i
asked by:
40 pts.

Converting Oracle Report to Excel
How do I convert my Oracle D2K report to Excel?

Answer Question   |  August 27, 2013  9:54 AM
Oracle Application Server, Oracle Database, Oracle Reports
asked by:
10 pts.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: