Oracle SQL question
I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I’m unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case [...]

Answer Question   |  April 22, 2009  2:39 AM
CASE statement, IF THEN statement, IIF statement, Oracle developers, Oracle development, Oracle SQL, SQL

Default Types in Oracle Parameter Screen
I am adding my default parameters to my stage. In the default type drop down box I see Constant, Current Date, Current Time, Field, Profile, SQL Statement and Segment. I know what most of them mean but have questions on Field, Profile and Segment. I have tried searching the web for answers but came up [...]

Answer Question   |  February 12, 2011  12:59 PM
Oracle default parameters, Oracle developers, Oracle development

What is the Oracle Application Object Library?
what is object library ?

Answer Question   |  September 6, 2011  8:58 AM
Oracle AOL, Oracle Application Object Library, Oracle developers

Oracle Reports 9i
I am new to Oracle reports, I am working on 9.0.4 version, I have configured OC4J, but when I run forms its shows Oracle application services installed successfully, and once I click ok it comes with a blank screen and status bar of the IE says its still loading. Please help me out.

Answer Question   |  December 8, 2008  10:54 AM
OC4J, Oracle Containers for J2EE, Oracle developers, Oracle Reports, Oracle Reports 9i

SQL Query
Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ———- ———- ——– 1 3 01-12-08 1 2 01-12-08 2 3 01-12-08 2 2 01-12-08 3 6 05-12-08 4 10 05-12-08 [...]

Answer Question   |  December 2, 2008  4:11 PM
Oracle Database, Oracle developers, SQL Query

How to call Microsoft Excel from Oracle Reports/Forms 6i
how to call excel from oracle report/forms 6i plz tell me the step by step process how can we do it my e-mailid is lightmobeen@yahoo.com if any one know the process plz send me mail sonsist of code,me very thankful to u for this

Answer Question   |  November 21, 2010  10:55 AM
Excel import/export, Microsoft Excel, Microsoft Excel import/export, Oracle 6i, Oracle 6i import/export, Oracle developers, Oracle Forms, Oracle Forms 6i, Oracle import/export, Oracle Reports

Insert superscript text into Oracle database
how can i insert superscript or subscript text to the data base i have colomn called measuments Units and i want to insert quadratic meter M2 or Cubing meter M3 am using oracle 9i pleeez help

Answer Question   |  November 6, 2008  10:23 AM
Data Types, Oracle 9i, Oracle developers, SQL

IN PL/SQL how to declare and use ‘STATIC DATA TYPE like C’
Hi All, Can anybody help me to declare a variable having the similar propery of ‘STATIC DATA TYPE IN C’. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will make the variable like [...]

Answer Question   |  July 24, 2009  10:47 AM
Oracle Application Server, Oracle database replication software, Oracle developers, Oracle development, PL/SQL

Oracle Lock Query
Is it possible to determine who is locking (not blocking) a row in an Oracle database? This relates to a problem I have with a COBOL program that needs to determine who is locking a requested record. I can determine the rowid of the requested record (after Oracle has informed the program that the requested [...]

Answer Question   |  August 21, 2008  4:00 PM
COBOL, Oracle developers, Oracle Lock Query

Join clause vs. nonequi join
pls help, can using clause is simmilar to non equi join,if yes how is it

Answer Question   |  August 15, 2008  1:49 PM
Join logical files, JOIN statement, Oracle developers

Nonequi join and self join as inner join
pls Help, can we call non-equi join and self join as inner join ,if yes pls give some resion

Answer Question   |  August 13, 2008  1:47 PM
Join logical files, JOIN statement, Oracle developers

3 tier character report printing not possible in 10g
i made a character report in 10g , if i run in report builder then its printing is fine. but when i print report using 3 tier (using pdf format) then all setting are disturbed.

Answer Question   |  June 26, 2008  3:47 AM
Oracle 10g, Oracle developers, Oracle Reports

Pl/sql code for queries
Hi , I have written 4 sql queries.2 select commands and 2 delete commands.now I want to write a pl/sql block for this.i.e after 2 select statements if the given condition satisfies then 1st delete command applicable. same way for 2nd delete command.I want to write cusor for those 2 select statements. the queries are [...]

Answer Question   |  May 22, 2008  5:20 PM
Oracle developers, PL/SQL

Oracle 9i to 10g conversion
have anybody done this type of conversion and what are the problem is can expect, we are using a lot of stored proc and triggers, is there any problem regarding the meta data?

Answer Question   |  June 4, 2008  8:16 AM
Oracle 10g, Oracle 9i, Oracle developers

install oracle developer suite 10g in windows
without oracle database can i install oracle developer suite 10g in windows

Answer Question   |  December 16, 2010  11:19 AM
Oracle 10g, Oracle developers, Oracle development

how can i update ?
when update in form (master_details) in details block i found error frm-40735 when button pressed trigger raised unhandled exception ora-00001

Answer Question   |  September 16, 2008  9:54 AM
Oracle developers, Oracle error messages

Oracle / EADH
Can someone please explain to me what EADH (Enterprise Agent Data Hub) works?

Answer Question   |  November 27, 2007  11:30 PM
EADH, Oracle Business Applications, Oracle developers