Forms :: JTF Grid Functionality
Sep 12, 2009what 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
ADVERTISEMENT
Forms :: GET_FILE_NAME Functionality
Mar 8, 2010I 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 RelatedForms :: Restrict Standard Save Functionality?
Jun 20, 2011how can we restrict standard save button functionality in custom form?
View 4 Replies View RelatedForms :: Auto Stretch Functionality In Oracle?
Oct 6, 2013Is 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.
Grid / Real Application Clusters Grid Computing With RAC
Aug 12, 2010(Oracle Grid & Real Application Clusters Oracle Grid Computing with RAC) from rampant tech press. I have already ordered it 3 months back and still have not received it as its not printed yet or as i am told is in press. I would be glad to have a copy soon if its published.
View 4 Replies View RelatedForms :: Using Data Grid View In 6i?
Jan 26, 2010Is it possible to use Data grid view in Forms6i just as in Visual Basic?
View 7 Replies View RelatedPL/SQL :: OUT Parameter Functionality
Mar 25, 2013I 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
Stream Functionality Replacement In 11g
Dec 15, 2010Earlier 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 RelatedSQL & PL/SQL :: Decode Functionality With Null
Jun 29, 2010Explain 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'
SQL & PL/SQL :: Decode Functionality In DBMS_OUTPUT
Jun 28, 2010I 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).
SQL & PL/SQL :: Procedure Functionality As Triggers
Oct 26, 2010I 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.
DATE-ADD In Oracle - Convert Functionality?
Oct 28, 2011I 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)
PL/SQL :: Replicate For Loop Functionality Through SQL Query
Jun 14, 2013I 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 RelatedClient Tools :: Access Violation And F4 Functionality
Jan 14, 2012I 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.
SQL & PL/SQL :: Create A Trigger With Requirement Of Achieving Primary Key Functionality?
Sep 22, 2011I 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).
Application Express :: Tabular Form Delete Row Functionality
Aug 29, 2013I 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 RelatedApplication 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.
Client Tools :: SQL Developer - Disable Save Password Functionality?
Feb 18, 2011I 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 RelatedApplication Express :: Creating Functionality For Changing Users Password
Mar 12, 2013I'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.
Application Express :: Interactive Report Subscription - Missing Search Functionality?
Oct 11, 2012when 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.
Single Instance Non-Grid To Single Instance Grid Database
Aug 27, 2012I'm trying to test moving a single instance 11202 database to single instance w/ grid infra.
Here is what I've done:
1. Install a database (11202), single instance and create a database
2. Install Grid Software only (user: grid)
3. start the cluster
4. "srvctl add database -d orclsidb -o $ORACLE_HOME" to register the database with grid.
4.1> I was able to start/stop the database with srvctl command here onwards
5. configure disks using asmlib and start the asm
6. "srvctl add asm" to register asm with grid.
7. PROBLEM ... when I try to "backup as copy database format '+ASM_DATA_DG';" from oracle user it errors out as below:
RMAN> backup as copy database format '+ASM_DATA_DG';
Starting backup at 24-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/fs0/oracle/oradata/orclsidb/sjc883p_indx_large_01.dbf
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 08:53:29
ORA-19504: failed to create file "+ASM_DATA_DG"
ORA-12547: TNS:lost contact
ORA-15001: diskgroup "ASM_DATA_DG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contactConsidering "TNS: lost contact" I tried to see if grid listener is aware of ASM instance:
[Code]....
All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usracdb03.rwcats.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 22-AUG-2012 06:08:53
Uptime 2 days 2 hr. 50 min. 48 sec
Trace Level off
[Code]....
Application Express :: Interactive Report Functionality For Classic Report?
Jun 27, 2012I 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 Related11g Grid On Windows
Mar 22, 2011I Had installed 11g grid on 32 bit machine. Grid was working fine till yesterday and was also able to monitor agents on 4 diff boxes. Agents installation was smooth using the pull method. But from yesterday onwards grid is not working. OMS service on windows is not getting started. node manager,listener,database service, web tier all services are running fine but for some reasons the Windows OMS service is not coming up .
I also tried to start manually oms_home/emctl start oms but the service doesn't come up.
OEM Grid Control 10g Reporting
Aug 19, 2011I am using OEM Grid control 10g for monitoring/reporting purposes and a bit new to OEM.I am able to generate database alerts sent via email say for DB_abc1 and also generate reports.I installed Oracle 10g agent on a another box and lets say with DB_abc2 running on it,and did not realise that there was a database control already installed on that box, so I
1.Uninstalled database control on DB_abc2 box.
2.Uninstalled Oracle 10g agent and re-installed it on DB_abc2 box.
2.Was able to configure the DB_abc2 database from OEM Grid control gui ie the dbsnmp user password and was able to connect to it.
But when I put in alert for things like ORA-XXXX errors I am not getting any emails, also when I put in database usage reports(to be sent via emails) the reports are not picking up any data, they are empty.
I checked the agent on the box in question and the heart beat is OK, and I manually uploaded using "emctl upload" and it is sucessful.The only alerts I am getting for DB_abc1 is the agent up/down thats it.
DB_abc1 is a 9208 database and DB_abc2 is 10201 database.
Installing Grid Control 12c?
Apr 19, 2012I need to install the new Oracle Grid on a new virtual machine. Currently the new Grid VM server has a different name and IP. After it is setup and tested it will eventually take the place of the old production server using its original IP and name. If I install the new Grid now on this new VM with different name and IP address would I have to reinstall the agents on each of the target database servers?
View 1 Replies View RelatedGenerate Report From OEM Grid
Feb 6, 2012Can we collect information(generate report) about user sessions connected, database hit ratios, memory usage and other system metrics of all target databases from OEM grid control repository database. Which tables/views in repository DB will be holding these information.
View 1 Replies View RelatedSetting Threshold Value Without Using Grid
Jun 13, 2012if I create manual database how to set threshold value? is there any other tool to set threshold value?
View 4 Replies View RelatedOracle Grid 12C - Converting All Servers?
Apr 18, 2012Is the 12c version of the Grid Control only for Oracle Cloud? Not completely sure of exactly what cloud computing is. Looks like a conglomeration of shared resources. Anyway we are converting all of our servers over to vmware virtual machines except the ones we manage in other states. I am upgrading each database to 11 r2 as we convert the servers. Anyway my Grid server is next to convert to a virtual machine. I am using Grid Control 10.2.0.5.0 now. I want to upgrade to the latest version of the Grid control. 12c seems to stress and boast about managing the "Oracle Cloud" to manage regular single node Oracle servers as well as vmware virtual machines?
View 3 Replies View RelatedGenerate Report From OEM Grid 11 Or RMAN
May 17, 2013*How can we generate the report of backup status,tablesapce(usedf,free space) for all the databases from OEM or RMAN*
1.)we need generate the report of tablespace used,free, archive...
2.)we also need we generate the Backup status report also
Basic Difference Between RAC And Grid Computing?
Jul 13, 2011I have only 9i OCP certification. What is the basic difference between the RAC and GRID.
Also I want to upgrade myself to Oracle 11g. Do I have to go thru 10g concepts to understand 11g.