Oracle Tag Directory

Featured Oracle Questions

Call a report from forms 6i
I need some help: I want to call a report from Oracle Forms 6i. What’s the step-by-step process in doing this? Thank you.

Answer Question   |  February 7, 2014  3:08 PM
Oracle Forms, Oracle Reports
asked by:
5 pts.

PL/SQL – How to make a check whether the attribute is positive or zero
Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?

Answer Question   |  November 27, 2013  4:55 AM
Oracle PL/SQL, PL/SQL, PL/SQL attributes, PL/SQL Variables
asked by:
610 pts.

asked by:
5 pts.

oracle 10g query
i need sum of income amount from income table and sum of expense amount from expense table to calculate the profit or loss. i have no idea how can i link these two tables.

Answer Question   |  November 10, 2013  8:31 AM
Oracle 10g, Oracle Query
asked by:
110 pts.

How to display non existent data as 0 in Oracle
in my table there refno,purchase,sale,acc_type are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose purchase,sale, are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for that month...

Answer Question   |  November 5, 2013  3:37 AM
Oracle, Oracle Database, Oracle Forms, Oracle Table
asked by:
50 pts.

Running a query on both SQL Server and Oracle databases
How do I run a query that queries a SQL Server database and an Oracle server database, on two different servers, and uses all the data?

Answer Question   |  October 23, 2013  7:47 PM
Oracle, Oracle queries, SQL Server databases, SQL Server Query
2,585 pts.

Create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?
Is there a way to create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?

Answer Question   |  October 18, 2013  6:25 PM
Oracle Streams, SQL Server, SQL Server Service Broker
2,585 pts.

Oracle perfomance tuning
How to tune Oracle SQL queries. Please tell me step-by-step.

Answer Question   |  October 2, 2013  5:50 PM
Oracle, Oracle performance, Oracle SQL
asked by:
5 pts.

Oracle Reports 6i – Convert data in Microsoft Excel
How do I convert Oracle Reports 6i data into a Microsoft Excel through coding on button?

Answer Question   |  September 10, 2013  9:46 AM
Microsoft Excel, Oracle, Oracle import/export, Oracle Reports 6i, Oracle Reports 6i to Excel
asked by:
5 pts.

Temp table with months in Oracle
How do I create temporary table which contains all the months from January to December?

Answer Question   |  August 29, 2013  4:31 AM
Oracle, Oracle Forms, Oracle Table, Oracle Tables
asked by:
50 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 find duplicate records in an Oracle table
How do I find duplicate records in a table?

Answer Question   |  August 28, 2013  1:28 PM
Oracle, Oracle Tables
asked by:
35 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.

How to develop basic form in Oracle Forms 6i
Hi sir, I am a beginner for developing forms and reports, in my office they are using oracle forms 6i. Can you please tell me how to develop a basic form?

Answer Question   |  August 26, 2013  10:19 AM
Oracle Forms 6i, Oracle reporting, Oracle Reports
asked by:
5 pts.

convert oracle reports to excel
How do i corvert oracle reports to excel

Answer Question   |  August 26, 2013  10:35 AM
Data conversion, excel, Oracle Reports, Oracle Reports Builder
asked by:
5 pts.

Multiple values
When we have to insert multiple values in a table in one column only, then what’s the query?

Answer Question   |  August 19, 2013  12:29 PM
Oracle, Oracle Query
asked by:
10 pts.

Verify if a patch is installed for Solaris 10
I need to check if two patches (120753-05 & 120048-03) have been installed for Solaris 10. How do I check that they have been installed?

Answer Question   |  August 15, 2013  3:30 PM
Installing/upgrading operating systems, Oracle patches, Solaris10, SPARC
asked by:
15 pts.

DNS Server change effect on oracle connections
Hello, There is going to be a change in DNS server at our site. Also, there is going to be migration from Static to DHCP IP, but it has been assured to us that IP address will not change. All our databases are accessed via DNS alias entries in TNSNAMES.ora. Will a change in DNS...

Answer Question   |  July 30, 2013  11:39 AM
DHCP, DNS, Oracle performance
asked by:
5 pts.

Modify Oracle Reports
Can anyone tell me, how to modify a report using report builder in Oracle Developer? Actually, I have to add 2 more fields to my original report that are already present in the table created previously. Give detailed information.

Answer Question   |  June 27, 2013  11:58 AM
Developer 2000, Oracle Developer 2000, Oracle Reports, Oracle Reports Developer
10 pts.

Oracle Reports: Print options
I have written a report that is Landscape, and legal size paper. (14 x 8.5) If the user goes into the print options and changes them to landscape, and then specifies legal size paper, it prints fine. How can I set it up so that these are the default, and the user does not have...

Answer Question   |  June 27, 2013  2:01 PM
Oracle printing, Oracle Reports
asked by:
65 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: