Forms :: Auto Stretch Functionality In Oracle?

Oct 6, 2013

Is it possible to have auto stretch functionality (similar to Oracle ADF) in Oracle Forms?

The requirement is to adjust the data blocks/ canvases according to the window size automatically.

I know it is possible in Oracle ADF. But I want to achieve the similar kind of functionality in Oracle Forms.

View 1 Replies


ADVERTISEMENT

Forms :: GET_FILE_NAME Functionality

Mar 8, 2010

I have my forms application working on both windows and Unix platform. When i am using GET_FILE_NAME ( ), it is working fine in Windows based application but the same is not working in Unix based application..

View 11 Replies View Related

Forms :: JTF Grid Functionality

Sep 12, 2009

what is JTF GRID functionality,i have use that grid in custom form. how to proceed with that and what are steps to be taken to display JTF GRID Functionality ?

View 6 Replies View Related

Reports & Discoverer :: Stretch Column As Per Requirement?

Aug 21, 2012

How can i stretch field dynamically as per the requirement.

i use horizontal elasticity and also format trigger on the field but cant find the expected output.... How can i achieve the same...

View 2 Replies View Related

Forms :: Restrict Standard Save Functionality?

Jun 20, 2011

how can we restrict standard save button functionality in custom form?

View 4 Replies View Related

DATE-ADD In Oracle - Convert Functionality?

Oct 28, 2011

I need to convert below functionality in Oracle. At present it is working with SQL server

current_end_time TIMESTAMP,
current_start_time TIMESTAMP
current_duration int
current_end_time := DATEADD(second, current_duration/10, current_start_time)

View 1 Replies View Related

Forms :: LOV / Auto Select Values

Apr 13, 2012

I have an LOV on my form which holds a list of course units for a student to select and insert. However some units on the LOV must be COMPULSORY(not optional).... so i was wondering is there a way to have these auto selected from the LOV?

View 4 Replies View Related

Forms :: Auto Refresh When Data Updated

Apr 19, 2010

i need a code to auto refresh or after 1 minute in form & report when the data is updated. basically i am deploying the plasma tv in hall so executive can see the status report where they need its going to be like a stock system multiple forms or reports sticky dynamically change .

View 2 Replies View Related

Forms :: Where To Set Auto Refresh On Custom Form

Dec 14, 2010

How and where to set Auto Refresh on Custom Form ...?

View 1 Replies View Related

SQL & PL/SQL :: Auto Rotation Table In Oracle

Nov 18, 2010

Is there any strcuture or fucntion that can make the table have something like rotation.I mean the record can be first in first delete.So,for example , even the table have limit row for example , 100 row .so, the new data can be replace the oldest row in the table auto and insert into the table .so the new row will replace the oldest 99 th row auto .the table still keep 100 row but the data can be update . Is it "partition" or other ??

View 8 Replies View Related

Oracle Auto Extensible Tablespaces

Jan 7, 2011

I need to create a shell script to find the free space of an auto extensible tablespaces and send an alert when the free space is < 700MB. I tried checking with the dba_free_space, but I did not get the exact free space.

Tell me the logic to find the exact free space of autoextensible enabled tablespaces?

View 1 Replies View Related

SQL & PL/SQL :: Performance To Generate Auto-increment Number In Oracle

Jun 16, 2010

which method is more efficient in terms of performance to generate an auto increment number in oracle.

Step1

CREATE TABLE test
(id NUMBER PRIMARY KEY,
name VARCHAR2(30));

Step2
CREATE SEQUENCE test_sequence
START WITH 1
INCREMENT BY 1;
[code]....

View 22 Replies View Related

Backup & Recovery :: Unable To Auto-start Oracle Net Listener

Dec 30, 2011

when i try to run dbstart i got Message like "

ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart ORACLE_HOME
Processing Database instance "orcl": log file /u01/app/oracle/product/11.2.0/dbhome_1/startup.log

how to set oracle listener ? i tried using listener.ora file again show the same error

View 3 Replies View Related

Forms :: Auto Populating Records In Other Fields Based On Inventory Number Field

Jul 13, 2011

I am having a problem with auto populating different fields based on inventory no. field.. This is a bug giving to me to work on and i not able to figure out how to populate the other fields.

How to set any triggers for the items to auto populate and i am suppose to finish this work today.

View 2 Replies View Related

SQL & PL/SQL :: Exporting Oracle Data Into Excel File With Auto Column Size

Nov 7, 2007

I want to export the oracle data into an excel sheet. I have written the code by using UTL_FILE package. but i am getting the output as shown in the screen shot(without formatting the column size as the width of the data it has). But I want the output column width to be set according to the size of the data automatically.

View 5 Replies View Related

PL/SQL :: OUT Parameter Functionality

Mar 25, 2013

I thought that you are not supposed to be able to assign the value of an out parameter to a variable (Feuerstein, 5th ed) and yet I was just
able to do this without any compilation error messages. Is Feuerstein wrong or am I missing something? Has the functionality changed?

PROCEDURE Parse_HC
          (p_timestamp_string IN VARCHAR2,
          p_timestamp_date OUT DATE)
AS
v_date DATE;

[Code]....

Here is my banner:

BANNER
----------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 – Production
"CORE     11.1.0.7.0     Production"
TNS for Linux: Version 11.1.0.7.0 – Production
NLSRTL Version 11.1.0.7.0 - Production

View 8 Replies View Related

Stream Functionality Replacement In 11g

Dec 15, 2010

Earlier I am using oracle 10g (10.2.0.4) and now we are planning to use 11gR2 (11.2.0.1).we are using oracle stream functionality in 10g. I just want to know is there any new feautre available in 11g which replace the stream functionality? we dont want to use stream (in 11g) any more.

View 3 Replies View Related

SQL & PL/SQL :: Decode Functionality With Null

Jun 29, 2010

Explain me the following behavior of DECODE?

SQL> select decode(null,null,'Matched','Not Matched') from dual;

DECODE(
-------
Matched
As expected, output should be 'Not Matched' instead of 'Matched'

View 10 Replies View Related

SQL & PL/SQL :: Decode Functionality In DBMS_OUTPUT

Jun 28, 2010

I would like to use the below decode in DBMS_OUTPUT in place of cur_rec.data_type. Could I know how can I achieve this.
The DBMS_OUTPUT is inside a loop and output is shown below as an example.

NOT NULL -- EMP_ID NUMBER
,NOT NULL -- EMP_NAME NUMBER
,NOT NULL -- HIRE_DT DATE
,NOT NULL -- SALARY NUMBER

DBMS_OUTPUT STMT:

Dbms_Output.Put_Line(nullable ||CHR(9)||CHR(9)||' -- ' ||upper(cur_rec.column_name)||CHR(9)||CHR(9)||cur_rec.data_type);

STMT to use in place of cur_rec.data_type:

substr(decode( data_type, 'NUMBER', decode( data_precision, NULL, NULL,'('||data_precision||','||data_scale||')' ),data_length),1,11)

Also I am not able to align the output using CHR(9).

View 14 Replies View Related

SQL & PL/SQL :: Procedure Functionality As Triggers

Oct 26, 2010

I am creating triggers for audit operation when any insert/update/delete happens on a table automatically.Now i need the same functionality in procedure.

My requirement is to create procedure for all those triggers.

View 2 Replies View Related

PL/SQL :: Replicate For Loop Functionality Through SQL Query

Jun 14, 2013

I have a requirement where i need to replicate the for loop functionality  through sql query.In pl/sql  i can achieve this through cursors or for loop but is there any way  to do  or replicate the same functionality in sql queries .  For example i want to repeat the  operation for  set of records  or iterate through set of records and fire query accordingly .Is it possible  through sql query

View 19 Replies View Related

Client Tools :: Access Violation And F4 Functionality

Jan 14, 2012

I am using the Toad10.After i enter the user, Pwd it displays the Toad error that""Access violation at address 6761CB21 in module 'ORA805.dll'. Read of address 00000010 ""

while i try to use the F4 functionality, it again displays the above msg and Object not found...After i execute the query, all the characters data displays in chinees.

View 1 Replies View Related

SQL & PL/SQL :: Create A Trigger With Requirement Of Achieving Primary Key Functionality?

Sep 22, 2011

I want to create a trigger with the requirement of achieving Primary key functionality.

I have a "EMP" table. the table already contains a duplicate data on "EMPNO" column. i want to restrict entering duplicate data further into table for that i want to create a trigger.

where can i find different triggering events of DML(like update, delete etc...)and DDL(database and schema level).

View 6 Replies View Related

Application Express :: Tabular Form Delete Row Functionality

Aug 29, 2013

I have a wizard created tabular form, adding a row is easy using addRow() function, is there a way that I can delete the row from it?  Let's say I have added a row and not submitted the form, but now I want to delete just that row from the form, how can I do that?

View 1 Replies View Related

Application Express :: No Page Edit Functionality After Upgrade To 4.2.2?

Jul 12, 2013

Apex has been upgraded from 4.1 to 4.2.2. I don't know if the upgrade was done correct or not by the administrator, but I don't have the page edit link anymore,

and anytime I run a individual page from the Edit Application, I have to Log in. Did something went wrong during the upgrade or is this the behavior of Apex now, which I don't think so.

View 1 Replies View Related

Client Tools :: SQL Developer - Disable Save Password Functionality?

Feb 18, 2011

I want to install SQL Developer on a server but don't want the user to be able to store passwords by checking the "Save Password" box.

View 14 Replies View Related

Application Express :: Creating Functionality For Changing Users Password

Mar 12, 2013

I'm trying to create a functionality on my application that lets the user change their password whenever they want or when the password gets expired.

But to do that, first I need a Branch to the page "Password Change" whenever the login procedure returns "Password Expire", but when the user has an expired password he can't access none of the pages of the application.

My other problem is:

Even if I can get the user to be redirect to the "Password Change" page, I would need a function that validate his current expired password, because in order to alter his own, he would need to inform his current password and the new one he desires. If I was using Apex Authentication that would be very easy I think, but I'm obligate to use Database Account Authentication.

View 4 Replies View Related

Application Express :: Interactive Report Subscription - Missing Search Functionality?

Oct 11, 2012

when receiving the output of a report subscription in Apex 4.1.1, the search Box is missing, only the Text string 'Suche:' is displayed.If i download the report as Email or html, the search box is there and usable.

Maybe i'm wrong, but this was not under Apex 4.0.2.

View 0 Replies View Related

Application Express :: Interactive Report Functionality For Classic Report?

Jun 27, 2012

I have to implement IR report search functionality (*when ever we click on column header it will display all the values in that particular column , once we click on particular value , the report will filter based on that particular value * ) in classic report .

View 8 Replies View Related

Auto Rotation Table

Nov 18, 2010

Is there any strcuture or fucntion that can make the table have something like rotation.

I mean the record can be first in first delete.

So,for example , even the table have limit row for example , 100 row .

so, the new data can be replace the oldest row in the table auto and insert into the table .

so the new row will replace the oldest 99 th row auto .the table still keep 100 row but the data can be update .

Is it "partition" or other ??

how can I create it .

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved