Description : What are the Built-ins to display the user-named editor?
Last Answer : A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.
Description : Do user parameters appear in the data modal editor in 2.5?
Last Answer : No
Description : Is it possible to insert comments into sql statements return in the data model editor?
Last Answer : Yes
Description : What buil-in routines are used to display editor dynamicaly?
Last Answer : Edit_text item show_editor LOV
Description : What is a Layout Editor?
Last Answer : The Layout Editor is a graphical design facility for creating and arranging items and boilerplate text and graphics objects in your application's interface.
Description : How can a square be drawn in the layout editor of the Report writer?
Last Answer : By using the rectangle tool while pressing the (Constraint) key.
Description : Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?
Last Answer : No.
Description : If two groups are not linked in the data model editor, What is the hierarchy between them?
Last Answer : Two group that is above are the left most rank higher than the group that is to right or below it.
Description : How can you execute the user defined triggers in forms 3.0 ?
Last Answer : Execute Trigger (trigger-name)
Description : What are the roles and user accounts created automatically with the database?
Last Answer : DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary ... administrative information and internal tables and views used by oracle tools are created using this username.
Description : When creating a user, what permissions must you grant to allow them to connect to the database?
Last Answer : Grant the CONNECT to the user.
Description : When a user process fails, what background process cleans up after it?
Last Answer : PMON
Description : Does user exits supports DLL on MSWINDOWS ?
Last Answer : YES .
Description : Can you call WIN-SDK thruo' user exits?
Last Answer : YES.
Description : What are user-exits?
Last Answer : It invokes 3GL programs.
Description : How does one switch to another user in Oracle? (for DBA
Last Answer : Users normally use the "connect" statement to connect from one database user to another. However, DBAs can switch from one user to another without a password. Of course it is not advisable to ... tiger Connected. Note: Also see the su.sql script in the Useful Scripts and Sample Programs Page.
Description : Who created all these users in my database?/ Can I drop this user? (for DBA
Last Answer : Oracle creates a number of default database users or schemas when a new database is created. Below are a few of them: SYS/CHANGE_ON_INSTALL or INTERNAL Oracle Data Dictionary/ Catalog Created ... there should be no problem altering these users to use a different default and temporary tablespace.
Description : What are various privileges that a user can grant to another user?
Last Answer : SELECT -CONNECT -RESOURCES
Description : What is an User Exits ?
Last Answer : A user exit is a subroutine which are written in programming languages using pro*C pro *Cobol , etc., that link into the SQL * forms executable.
Description : What are the type of User Exits ?
Last Answer : ORACLE Precompliers user exits OCI (ORACLE Call Interface) Non-ORACEL user exits. Page :
Description : What is an user exit used for?
Last Answer : A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.
Description : How can I message to passed to the user from reports?
Last Answer : By using SRW.MESSAGE function. (Continued on next part...)
Description : How does one connect to an administrative user? (for DBA
Last Answer : If an administrative user belongs to the "dba" group on Unix, or the "ORA_DBA" (ORA_sid_DBA) group on NT, he/she can connect like this: connect / as sysdba No password is required. This ... connections via Net8 are classified as non-secure. Look at this example: connect sys/password as sysdba
Description : What is an administrative (privileged) user? (for DBA
Last Answer : Oracle DBAs and operators typically use administrative accounts to manage the database and database instance. An administrative account is a user that is granted SYSOPER or SYSDBA privileges. SYSDBA ... and special operating system groups. This password file is created with the orapwd utility.
Description : What are the three types of user exits available ?
Last Answer : Oracle Precompiler exits, Oracle call interface, NonOracle user exits.
Description : What is user Account in Oracle database?
Last Answer : A user account is not a physical structure in database but it is having important relationship to the objects in the database and will be having certain privileges.
Last Answer : An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges.
Description : Can one rename a database user (schema)? (for DBA)
Last Answer : No, this is listed as Enhancement Request 158508. Workaround: Do a user-level export of user A create new user B Import system/manager fromuser=A touser=B Drop user A
Description : Will a user be able to modify a table with SELECT only privilege?
Last Answer : He won’t be able to UPDATE/INSERT into that table, but for some reason, he will still be able to lock a certain table.
Description : When a user process fails, what Oracle background process will clean after it?
Description : I'm new. Should I be worried that a user named "baby4luv20" propositioned me by a private message?
Last Answer : answer:I had similar experience. http://i46.tinypic.com/22m96v.jpg
Description : What does "jumps off the screen" mean?
Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.
Description : How to add conditions in select statement in oracle?
Last Answer : Just add the decode
Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?
Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?
Description : What are the two ways to incorporate images into a oracle forms application?
Last Answer : Boilerplate Images Image_items
Description : Can one export a subset of a table? (for DBA
Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"
Description : What are the types of visual attribute settings?
Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window
Description : How does one use the import/export utilities? (for DBA
Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).
Description : what is a display item?
Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.
Description : What is import/export and why does one need it? (for DBA
Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.
Description : Are there any troubleshooting tips for OEM? (for DBA
Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.
Description : Where can one get more information about TCL? (for DBA
Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter
Description : How does one start the Oracle Intelligent Agent? (for DBA
Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:
Description : What is the Oracle Intelligent Agent? (for DBA
Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.
Description : What are the types of SQL Statement ?
Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.
Description : How does one backout events and jobs during maintenance slots? (for DBA
Last Answer : Managemnet and data collection activity can be suspended by imposing a blackout. Look at these examples: agentctl start blackout # Blackout the entrire agent agentctl stop blackout # Resume normal monitoring ... management agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 minutes
Description : What are the pre requisites ?
Last Answer : I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.
Description : What kind of jobs can one schedule with OEM? (for DBA
Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.
Description : Difference between SUBSTR and INSTR ?
Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.
Description : Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA
Last Answer : When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA ... that OEM will not be able to send e-mail and paging notifications when the Console is not started.