Oracle Tag Directory

Featured Oracle Questions

Notes.notessession custom sender
Hi, I’m using Oracle 9i, Developer 6i and Lotus Notes to send an email. I need to change the sender for another and I don’t know how to do it. Please, help me.

Answer Question   |  May 14, 2013  6:46 PM
Lotus Notes, Oracle 9i, Oracle Developer
asked by:
15 pts.

Adding a star to a required field in Oracle Application Express
I have a page…in that page there is a required field I just want to add a star which highlights the field as a required. How can this be done? I am a newbie to Oracle Application Express. Please help

Answer Question   |  April 22, 2013  5:41 AM
APEX, Oracle, Oracle Application Express
asked by:
5 pts.

Execution of Oracle 11g wrapped procedure gives ora-00900 error
Hi, I have a procedure which I wrapped using the oracle 11g wrap utility. If I execute the wrapped procedure using JDBC I am getting an error of 0RA-00900 invalid SQL statement. The procedure is having basic SQL statements only. The same procedure if i wrap using Oracle 9i and execute using JDBC it works [...]

Answer Question   |  April 5, 2013  4:29 AM
Oracle 11g, Oracle 9i
asked by:
15 pts.

My Oracle forms 6i Form is exiting automatically
Dear friends, My problem is…after compiling, my Oracle Forms 6i form is exiting automatically. How can I solve this problem?

Answer Question   |  April 1, 2013  11:41 PM
Oracle 6i, Oracle Forms
asked by:
30 pts.

Clear button
Hi friends, I had created one form contains 2 table details(emp,dept), I saw the details from 2 table by entering empno but I want to clear those text fields.

Answer Question   |  March 19, 2013  1:05 PM
Oracle 6i, Oracle Forms
asked by:
5 pts.

Stop Oracle database using by other application
I have Oracle 9i database & want to stop other people from using it and use other applications like SQL Developer & Toad.

Answer Question   |  March 11, 2013  9:37 AM
Oracle 9i, Oracle 9i database
asked by:
10 pts.

How to sort a resultset from a ‘group by’ statement
I have written a query like this: select to_char(order_date,’mon-yyyy’) “months”, sum(nob) “number of bags” from p_in where order_date between ’1-apr-11 and ’31-mar-12′ group by to_char(order_date,’mon-yyyy’) The above query returns me a resultset which gives me number of bags sold in every month, but it does not sort the month in their chronological order.I want to [...]

Answer Question   |  March 11, 2013  4:20 AM
Oracle 11g, Oracle 11g Database, Oracle Query
asked by:
425 pts.

Oracle application is installed in VMware in 2003
Oracle application 12.1.1 is install in 2003 through VMware working properly. When I am trying to access application through Windows 7 (Windows 7 is install in C drive and 2003 is in E drive) its not working but theĀ  application is working in 2003 through VMware but not working in Windows 7. I tried by [...]

Answer Question   |  February 15, 2013  10:02 AM
Oracle applications, VMware
asked by:
5 pts.

Date field validation
Hi friends, I need a help from your side…I have developed one form in Oracle 6i. The problem is Date fields date format should take automatically (example 12jan2013 it has to take 12-jan-2013 automatically). Could you please tell me how to do it?

Answer Question   |  February 4, 2013  2:11 AM
Oracle 6i, Oracle Forms
asked by:
5 pts.

Mirror/Clone
I have a client with IBM made server using Windows 2003 Server running Oracle applications and some other stuff. He is having another IBM made server with same configuration and everything but is not installed with any OS or apps whatsoever. Now, he wants to create a exact replica of the first server with Windows [...]

Answer Question   |  January 28, 2013  7:13 AM
IBM Servers, Oracle applications, Windows 2003 Server
asked by:
5 pts.

How to install Oracle 9i on Win 2008 server?
error :- jrew.exe has stopped working so database not generated

Answer Question   |  January 21, 2013  12:18 PM
Oracle 9i, Windows Server 2008
asked by:
5 pts.

Problem connecting D2K 6i with database Oracle 11g
Steps to connect D2K 6i, with oracle database 11g.

Answer Question   |  January 11, 2013  10:19 AM
D2K, Oracle 11g, Oracle 11g Database
asked by:
v1
5 pts.

Oracle 9i data dictionary definition & informational SQL queries?
I am using Oracle 9i on a specific application that was designed back in 2000 — no supporting documentation, very little training and I’m new to Oracle and sql. I’m currently using Toad for Oracle which allows me to create query templates. Toad for Oracle has existing sql templates which I can modfiy so I’m [...]

Answer Question   |  January 11, 2013  8:10 AM
Oracle 9i, Oracle 9i query
5 pts.

Tutorial questions and answers
Queries on Oracle database black screen?

Answer Question   |  December 17, 2012  11:07 AM
Oracle, Oracle Database
asked by:
10 pts.

How can i keep sys_guid() unique in multiple table insert
I want to use unique sys_guid() for insert multiple table but out put are difference sys_guid() drop table T1; drop table T2; drop table T3; create table T1 (ROW_ID varchar2(50)); create table T2 (ROW_ID varchar2(50)); create table T3 (ROW_ID varchar2(50)); insert all into T1 values (NEW_ROW_ID) into T2 values (NEW_ROW_ID) into T3 values (NEW_ROW_ID) select [...]

Answer Question   |  November 26, 2012  12:40 PM
Oracle 9, Oracle SQL
asked by:
15 pts.

Linking columns from a report
I want to use the column link tab to transfer the report information to a form for possible update. How can I have 14 fields from a report auto populate a form for update?

Answer Question   |  November 15, 2012  4:56 PM
Oracle Apex
asked by:
5 pts.

IMPORT OR EXCEL DATA INTO ORACLE FORMS 6I
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   |  October 30, 2012  9:55 AM
EXCEL DATA, Import, Oracle 6i
asked by:
5 pts.

Can anyone tell me what is the difference between oracle 10g and oracle 11g in way of comparison
Please, can anyone tell me what is the difference between Oracle 10g and Oracle 11g in way of comparison?

Answer Question   |  October 22, 2012  9:31 AM
Oracle 10g, Oracle 11g
asked by:
20 pts.

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

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

Oracle8i
Does Oracle8i work on Windows 7 or not ?

Answer Question   |  September 18, 2012  9:32 AM
Oracle 8i, Oracle 8i Installation
asked by:
20 pts.