Forms :: Meaning Of System Message_level
Jul 3, 2010what is mean by system.message_level..
View 2 Replies
ADVERTISEMENT
Forms :: Difference Between System.current_item And System.cursor_item?
Apr 1, 2012We have system.current_item and system.cursor_item.....
both represent the same....
like this we have few other system variables also .....
what is the main difference between current_item and cursor_item?
Meaning Of Sentence SRW.USER_EXIT?
Apr 9, 2013I am developing in the Report tool.I wonder what the meaning of the sentence SRW.USER_EXIT, and arguments that are used in it.
For example,
srw.user_exit('FND FLEXIDVAL
CODE=" "
NUM=" "
APPL_SHORT_NAME=" "
DATA=" "
VALUE=" "
DISPLAY=" "
DISPLAY=" "
IDISPLAY=" "
IDISPLAY=" "');
return();
SQL & PL/SQL :: Escape Character Meaning
Jul 6, 2010i want to understand each and every concept of oracle.in this book they explained about escape character, but stiil i cant get it..i want to understand why used escape character in 2nd query and whats its effects...
1. SQL> SELECT first_name, last_name
FROM employees
WHERE first_name LIKE 'Su%'
AND last_name NOT LIKE 'S%';
2. SELECT job_id, job_title
FROM jobs
WHERE job_id like 'AC\_%' ESCAPE '';
SQL & PL/SQL :: Meaning Of Partition By Null In Analytic Functions
Aug 18, 2013What's the meaning of "partition by null" in analytic functions like
select emp_no, dept_nm, count(*) over(partition by null) cnt
from some_table
is it right there is no partition?
Replication :: Meaning Of BOUNDED RECOVERY In Golden Gate
Jan 8, 2012whats the meaning of BOUNDED RECOVERY in golden gate. I just know RECOVERY in oracle.. What is the difference when you say BOUNDED RECOVERY.
View 1 Replies View RelatedNetworking And Gateways :: What Is Meaning For Port Number In Listener.ora File
Aug 12, 2013what is meaning for port number,in listener.ora file associated with ? is there any difference for port number in windows & in linux server.,?
View 3 Replies View RelatedMeaning Of Lines CPU Cores And 99th Percentile In Average Active Session
Apr 18, 2013I´m monitoring a 11g database with OEM. I have a couple of questions regarding the Average Active Sessions chart:
- What does the line 'CPU core' means? The DB is running in a virtual server with 8 CPUs. However, the line 'CPU core' is in 1. Does it mean that Oracle is just using 1 CPU?
- What represents the '99th percentile' line? The chart shows several sessions above that line, something is not working well, isn't it?
Forms :: How To Know Operating System Current Path In Oracle 10g Forms
Apr 19, 2011How to Know Operating System Current Path in oracle 10g forms ?
View 4 Replies View RelatedCPU System Time (percentage) For Multi Core System?
Aug 21, 2012couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not
CPU Idle Time (%)
CPU System Time (%)
CPU User Time (%)
Forms :: What Is Exactly System.cursor_record
Sep 1, 2010what is exactly system.cursor_record?? actually i read documentation on that...but i still not getting..
View 2 Replies View RelatedForms :: How To Stop System Message
Nov 3, 2010I have a form with multiple data block. When i want to query and go to next record then this displayed a message "Do you want save changes". But i would like to stop this message(i.e would not see the message) is it possible.
View 3 Replies View RelatedForms :: System Date Change
May 18, 2013after change the system date form not working. (after enter value in a text field ,cursor not moving)
View 4 Replies View RelatedForms :: SYSTEM.BLOCK_STATUS Remains On Query
Feb 23, 2013The form is used to insert new customers into a table on the database, but also, it is used to QUERY the table, by using a customer_id entered by the user to see the details for a customer.
The scenario is that for a particular field on the table, CUSTOMER_ID, I want to conceal the data on this field ONLY when I do a QUERY.I got this to work by using the below in the POST-QUERY trigger on the block.
IF :SYSTEM.BLOCK_STATUS = 'QUERY' THEN
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_TRUE);
END IF;
However, after I do a QUERY, and I decide to INSERT a NEW customer into the table, I click on the button to do a NEW insert into the database, and when typing in the CUSTOMER_ID, it is still concealed and I cannot see what I am typing.
This shouldn't happen as I only want the data to be hidden/concealed when doing a query, but I do want to see the data I am typing into the field when I am doing a new Insert.
Forms :: Retrieving Images From File System
Sep 15, 2010I am trying to retrieve images from the file system, but the open dialog box is not popping up for me to choose which file i want. It does nothing gives no error. Just says record 1/1 on the message bar at runtime.
I have two blocks on the module. One is the lobs_table block and the other is the control block. On the control block i have a when-button-pressed trigger on an item. And here is the code below.
Declare
jpg_image_dir VARCHAR2(100) := 'C:UsersajayiaDesktopMe_pics';
photo_filename VARCHAR2(100);
BEGIN
:System.Message_Level := '25';
[code]......
I don't know the code to use to get forms to bring up the open dialog box.
Forms :: Picture In Database Or System Folder
Oct 5, 2010Where should one store pictures in database or read it straight from a folder stored in hard disk and why (performance talking)?
View 4 Replies View RelatedForms :: Get The Current User Login On System?
Jun 19, 2011How can i get the Current user log in on my system using global variable.
View 6 Replies View RelatedForms :: Trigger That System Generate Position Against Total Marks?
Aug 26, 2011i have one project about school system.there is one column of total marks.and other one is position column.i want a trigger that system genrate the position against total marks. problem is this when total marks become equal for example 101 and 101 than position also same.but dont now what a trigger i write for this.here some example
if total marks 100 than position is 1stand if total marks 99 than position is 2ndbut third person is also same number in total marks column i mean 99 than in position column must write the 2nd
Forms :: Uploading Image Which Is Not Database Item From Operating System?
Sep 13, 2010uploading an image item which is not a database item from the operating system. I am using forms 10g on db 10g. My platform is windows Vista sp1.
I am trying to use
GO_ITEM('BEEEE');
Set_Custom_Property( 'SALGRADE.BEEEE',1, 'READIMGFILE', 'C:/users/ajayia/Desktop/Beeee.jpg' ) ;
But I just get a blank image on runform. I am using WHEN-NEW-BLOCK-INSTANCE trigger. I have tried it on when-new-form-instance, but also not working. The file am trying to upload is a JPG file format, but i cant find the file type in forms image item property. What can I change it to. Or how to i go about changing it.
Forms :: Replica Of Windows Explorer - Read UNIX File System
Jun 14, 2011I would like to develop a form which will be replica of windows explorer.It should be able to read all files or files from a specific folder from an unix platform.
if yes can i have a template. I do not want to start from the scratch since I do not have much time.
Forms :: Write Trigger To Insert System Clock Time In Oracle?
Jan 4, 2013how can i write a trigger to insert the system clock time in the oracle form?
View 15 Replies View RelatedForms :: Hierarchical Tree - Make Information System Of Subjects And Corresponding Section?
Jan 26, 2012 I want to make an Information System of Subjects and its corresponding sections.Below is my desired output:
+ Sections
- Section 1
- Advanced Algebra
- Physics
- Section 2
[code]...
I wanna do it in a hierarchical tree, since I don't know how to do it,
Migrating To Newer System
Dec 21, 2011My manager has a couple of 2-proc dual-core Opteron servers with 8GB of RAM and RAID controllers. These servers currently run Solaris 8, but he wants to migrate them to a newer Linux systems.
View 4 Replies View RelatedSystem Generated Constraints
Jul 5, 2012I was wondering with dba_constraints and i found unexpected result shown as below
select constraints_name, constraint_type from dba_constraints
constraint_name constraint_type
SYS_C00141 c
SYS_C00142 c
SYS_C00143 c
SYS_C00144 c
SYS_C00145 c
SYS_C00146 c
SYS_C00147 c
SYS_C00148 c
SYS_C00149 c
i jst want to know that what is this system generated constraints ?
Importing Dmp File From One To Another System
Jul 23, 2013I have a dmp files of one table . the dmp files are from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
I want to export into my oracle db. i have not create any db or tables . i just installed oracle 11g.
System Tablespace Is Growing Up
Aug 19, 2010On one of our systems, the system tablespace ist growing up fast. The largest objects are:
SYS.C_OBJ# 3 GB (CLuster)
SYS.I_COL1 2,8 GB (INDEX)
SYS.I_COL2 1 GB (INDEX)
SYS.I_COL3 980 MB (INDEX)
why theses objects are going so big? Is it possible to shrink these objects? Table of the three index ist sys.col$ and part of CLuster sys.c_obj#
Windows :: Oracle 8i On XP System
May 12, 2002i have installed oracle 8i on my windows xp system. it has not given me any problems during installation. i could log on to oracle and work on it without any problems. but when i restarted my system, my system has failed to start the oracle service, and i could no longer logon to sql * plus.
I've got messages 'oracle not available'. i've even tried to start the service from administrative tools-services, but of no use. then i created a new database and log on to sql* plus. but when i rebooted my system, the problem continued.
SQL & PL/SQL :: Field Keep On Getting Updated By Other System
May 20, 2011I have a promotion table which is having 3 columns.
PROMOTION_ID
display_name
ASSET_VERSION
This ASSET_VERSION
field keep on getting updated by other system where they may update the display name of the promotion_id.The main concept of this table is there will be a unique combitination of asset_id and promotion id.
Promotion_idDISPLAY_NAME ASSET_VERSION
123 1ST VERSION 1
123 2ND VERSION 2
123 3RD VERSION 3
456 1ST VERSION 1
456 2ND VERSION 2
456 3RD VERSION 3
789 1ST VERSION 1
789 2ND VERSION 2
789 3RD VERSION 3
So,my requirement is that i have the fetch promotion_id ,display_name that is having highset asset_version.
The OUTPUT SHOULD BE:
Promotion_idDISPLAY_NAME
123 3RD VERSION
456 3RD VERSION
789 3RD VERSION
I need a single sql for this .
Driver used: oracle.jdbc.xa.client.OracleXADataSource
Orcale version: 11G
Connecting Using SYS Or SYSTEM Sqldeveloper
Jan 4, 2011When I attempt to connect to the DB as SYS, SYSTEM using sqldeveloper I get:
ORA-01017:invalid username/password; logon denied
Now I am certain the username and password are correct, I think it has something to do with remote login of SYS account. Are DBA accounts not allowed to connect via network? I get the same error when I try to sqlpython wrapper which I believe uses TCP
[oracle@oracle ~]$ sqlpython sys as sysdba
which: no gedit in (/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/sbin:/bin:/usr/sbin:/usr/bin)
which: no kate in (/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/sbin:/bin:/usr/sbin:/usr/bin)
Password:
Connection failure.
Opens the DB connection. Some sample valid connection strings:
[code]....
SQL & PL/SQL :: Filter The System Grants?
Jun 3, 2010As per my req, i need to get the system grants of one user (GRANTEE) using DBMS_OUTPUT API. The requirement get completed using 'SYSTEM_GRANT' as parameter for OPEN function in the metadata api. Please look into part of code which works.
v_meta_handle := DBMS_METADATA.OPEN('SYSTEM_GRANT');
DBMS_METADATA.SET_FILTER(v_meta_handle, 'GRANTEE','SCOTT');
When using above piece, i get sys grants granted to SCOTT user. But i need to use 'DATABASE_EXPORT' as a parameter to my 'OPEN' function.
v_meta_handle := DBMS_METADATA.OPEN('DATABASE_EXPORT');
DBMS_METADATA.SET_FILTER(v_meta_handle, 'INCLUDE_PATH_EXPR','IN''SYSTEM_GRANT''');
DBMS_METADATA.SET_FILTER(v_meta_handle, 'NAME_EXPR','IN''SCOTT''','GRANTEE_EXPR');
The second set filter doesn't work to get SYS GRANTS of one user. It does not throw any error. Simply the filter doesn't work. 'GRANTEE_EXPR' is not a correct value in the 2nd set filter. What parameter need to pass in object_path_expr ('GRANTEE_EXPR')?