Oracle Developers

How to run oracle 10g forms without browser !!

I'm working on application using oracle 10g forms .. im done with it .. but i wanna run my application .. without the need to run browser with it . Is it possible ??? Please let me know and help me with it .

calling trigger in oracle db 10g

hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows' history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I'm waiting for your help.                  ...

SQL Developer: missing expression on insert into with select rownum

insert into TEMPLE_BDMS.TEMP_QSP values ( select rownum as uniqrownum, doc_id, doc_type, barcode2, barcode3, barcode4, routing_status, scan_date, assignee, scanner, scan_station, pfile_name, new_doc_id, new_doc_type, new_doc_type2 from TEMPLE_BDMS.QSP_SOURCE where pfile_name not like '%_0001.%' ) ...

to calculate last business day for each month for corresponding to any given date for last five years

Hi , i have created a function to calculate last business date for each month for 1 year . Now, I want to modify code to find out last business day for last 5 years. Please suggest me what changes i need to made in code . CREATE OR REPLACE FUNCTION LAST_MONTHLY_BUS_DATE_FOR_YEAR (P_DATE in...

View .pdf file from Oracle Forms 10g

Using Oracle Forms 10g version 9.0.4.0.19 that runs on a Sun Solaris box version 9. The application is web-based, and would like to add new functionality to an existing form. The user has the ability to upload .pdf files to the database from their local/network drive and download the .pdf files...

Escalation module with Oracle 9i and Oracle Forms 6i

we are developing customer care software working on Escalation Module.Here my system should genrate an email to executive or techical head if complain doesn't get resolved within 3-hrs.i am using oracle 9i and forms 6i as frontend.i hv two points to be disscussed. 1). if complain occur at 10.00...

how to config report server to run report by oracle developer 9i ?

oracle report

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 statements but Oracle doesn't...

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...

What is the Oracle Application Object Library?

what is object library ?

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.

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 ...

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

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

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...

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...

Join clause vs. nonequi join

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

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

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.

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...