What are the type of User Exits ?

What are the type of User Exits ?
by

1 Answer

Answer :

ORACLE Precompliers user exits
OCI (ORACLE Call Interface)
Non-ORACEL user exits.
Page :
by

Related questions

Does user exits supports DLL on MSWINDOWS ?

Description : Does user exits supports DLL on MSWINDOWS ?

Last Answer : YES .

Can you call WIN-SDK thruo' user exits?

Description : Can you call WIN-SDK thruo' user exits?

Last Answer : YES.

What are user-exits?

Description : What are user-exits?

Last Answer : It invokes 3GL programs.

What is an User Exits ?

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.

What are the three types of user exits available ?

Description : What are the three types of user exits available ?

Last Answer : Oracle Precompiler exits, Oracle call interface, NonOracle user exits.

How can values be passed bet. precompiler exits & Oracle call interface?

Description : How can values be passed bet. precompiler exits & Oracle call interface?

Last Answer : By using the statement EXECIAFGET & EXECIAFPUT.

How can you execute the user defined triggers in forms 3.0 ?

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

What are the Built-ins to display the user-named editor?

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.

What are the roles and user accounts created automatically with the database?

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.

When creating a user, what permissions must you grant to allow them to connect to the database?

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.

When a user process fails, what background process cleans up after it?

Description : When a user process fails, what background process cleans up after it?

Last Answer : PMON

How does one switch to another user in Oracle? (for DBA

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.

Who created all these users in my database?/ Can I drop this user? (for DBA

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.

What are various privileges that a user can grant to another user?

Description : What are various privileges that a user can grant to another user?

Last Answer : SELECT -CONNECT -RESOURCES

What is the User-Named Editor?

Description : What is the User-Named Editor?

Last Answer : A user named editor has the same text editing functionality as the default editor, but, because it is a named object, you can specify editor attributes such as windows display size, position, and title.

What is an user exit used for?

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.

How can I message to passed to the user from reports?

Description : How can I message to passed to the user from reports?

Last Answer : By using SRW.MESSAGE function. (Continued on next part...)

Do user parameters appear in the data modal editor in 2.5?

Description : Do user parameters appear in the data modal editor in 2.5?

Last Answer : No

How does one connect to an administrative user? (for DBA

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

What is an administrative (privileged) user? (for DBA

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.

What is user Account in Oracle database?

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.

What is user Account in Oracle database?

Description : What is user Account in Oracle database?

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.

Can one rename a database user (schema)? (for DBA)

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

Will a user be able to modify a table with SELECT only privilege?

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.

When a user process fails, what Oracle background process will clean after it?

Description : When a user process fails, what Oracle background process will clean after it?

Last Answer : PMON

Who's the classic cartoon character that exits a scene by kind of shooting the ground and hopping on his way out?

Description : Who's the classic cartoon character that exits a scene by kind of shooting the ground and hopping on his way out?

Last Answer : answer:Ugh, this question is bothering me. I feel like I should know it, but I can’t come up with any answer other than Yosemite Sam. I swear I’ve seen a cartoon where he pretty much uses his guns for locomotion… Here’s a list of old Looney Tunes characters. Maybe it will help jog your memory.

Do you tip the homeless people begging for money off exits on the freeway?

Description : Do you tip the homeless people begging for money off exits on the freeway?

Last Answer : If I can safely stop and I have a few extra dollars in my pocket, then I gladly give it to them. I don't really care what they spend it on. They're homeless and I'm not. If they can buy ... comfort when they are cold and hungry, I'm certainly not going to wag my finger and tell them they can't.

You're between exits on the interstate and you gotta pee. What do you do?

Description : You're between exits on the interstate and you gotta pee. What do you do?

Last Answer : answer:You’re a boy. Can you just use an empty Snapple bottle or something? As a girl, that’s not as easy for me.

Why doesn't Google Maps or Mapquest show where the highway exits are?

Description : Why doesn't Google Maps or Mapquest show where the highway exits are?

Last Answer : Google Maps clearly shows expressway ramps in my area. Where are they missing?

If a bee flies on to a train and exits 10 miles away, can the little worker find its way back home?

Description : If a bee flies on to a train and exits 10 miles away, can the little worker find its way back home?

Last Answer : wait what? does this mean something else from what you’re asking?

A man is trapped in a room. The room has only two possible exits: two doors. Through the first door there is a room constructed from magnifying glass. The blazing hot sun instantly fries anything or anyone that enters. Through the second door there is a fire-breathing dragon. How does the man escape? -Riddles

Description : A man is trapped in a room. The room has only two possible exits: two doors. Through the first door there is a room constructed from magnifying glass. The blazing hot sun instantly fries anything ... enters. Through the second door there is a fire-breathing dragon. How does the man escape? -Riddles

Last Answer : He waits until night time and then goes through the first door.

There are 100 light bulbs lined up in a row in a long room. Each bulb has its own switch and is currently switched off. The room has an entry door and an exit door. There are 100 people lined up outside the entry door. Each bulb is numbered consecutively from 1 to 100. So is each person. Person No. 1 enters the room, switches on every bulb, and exits. Person No. 2 enters and flips the switch on every second bulb (turning off bulbs 2, 4, 6, ...). Person No. 3 enters and flips the switch on every third bulb (changing the state on bulbs 3, 6, 9, ...). This continues until all 100 people have passed through the room. What is the final state of bulb No. 64? And how many of the light bulbs are illuminated after the 100th person has passed through the room? -Riddles

Description : There are 100 light bulbs lined up in a row in a long room. Each bulb has its own switch and is currently switched off. The room has an entry door and an exit door. There are 100 people ... And how many of the light bulbs are illuminated after the 100th person has passed through the room? -Riddles

Last Answer : First think who will operate each bulb, obviously person #2 will do all the even numbers, and say person #10 will operate all the bulbs that end in a zero. So who would operate for example bulb 48: Persons numbered: 1 & 48 ... 100 (1, 4, 9, 16, 25, 36, 49, 64, 81 & 100) hence 10 bulbs remain on.

Network layer protocol exits in _________ a. Host b. Switches c. Packets d. Bridges

Description : Network layer protocol exits in _________ a. Host b. Switches c. Packets d. Bridges

Last Answer : a. Host

5. Website Project definition phase comprises of  Overview of the Project  Organisational Background  The Environment the Organisation exits in  All of the Above

Description : 5. Website Project definition phase comprises of  Overview of the Project  Organisational Background  The Environment the Organisation exits in  All of the Above

Last Answer :  All of the Above

Network layer protocol exits in_____? A. Host B. Switches C. Packets D. Bridges

Description : Network layer protocol exits in_____? A. Host B. Switches C. Packets D. Bridges

Last Answer : A. Host  

It is a very hot day. You are in a special kitchen, in that there are no exits and the walls of this kitchen are thermally very well insulated. If you open the refrigerator door, the room will eventually: w) cool off. x) remain the same. y) heat up.

Description : It is a very hot day. You are in a special kitchen, in that there are no exits and the walls of this kitchen are thermally very well insulated. If you open the refrigerator door, the room will eventually: w) cool off. x) remain the same. y) heat up.

Last Answer : ANSWER: Y -- HEAT UP.

There are three processes P1, P2 and P3 sharing a semaphore for synchronising a variable. Initial value of semaphore is one. Assume that negative value of semaphore tells us how many processes are waiting in queue. Processes access the semaphore in following order: (a) P2 needs to access (b) P1 needs to access (c) P3 needs to access (d) P2 exits critical section (e) Pi exits critical section The final value of semaphore will be: (1) 0 (2) 1 (3) -1 (4) -2

Description : There are three processes P1, P2 and P3 sharing a semaphore for synchronising a variable. Initial value of semaphore is one. Assume that negative value of semaphore tells us how many processes are waiting in queue. Processes access ... The final value of semaphore will be: (1) 0 (2) 1 (3) -1 (4) -2 

Last Answer : Answer: 1

The value recorded in system.last_record variable is of type

Description : The value recorded in system.last_record variable is of type

Last Answer : a. Number b. Boolean c. Character. ? b. Boolean.

What type of index should you use on a fact table?

Description : What type of index should you use on a fact table?

Last Answer : A Bitmap index.

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

Description : What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

Last Answer : CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Description : What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Last Answer : The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE

What is difference between % ROWTYPE and TYPE RECORD ?

Description : What is difference between % ROWTYPE and TYPE RECORD ?

Last Answer : % ROWTYPE is to be used whenever query returns a entire row of a table or view. TYPE rec RECORD is to be used whenever query returns columns of different table or views and variables. E.g. ... emp ename %type ); e_rec emp% ROWTYPE cursor c1 is select empno,deptno from emp; e_rec c1 %ROWTYPE.

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Description : What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Last Answer : % TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in ... database definition of a column in a table changes, the data type of a variable changes accordingly.

Explain the two type of Cursors ?

Description : Explain the two type of Cursors ?

Last Answer : There are two types of cursors, Implicit Cursor and Explicit Cursor. PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.

What are the different type of a record group?

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

When do you use data parameter type?

Description : When do you use data parameter type?

Last Answer : When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogra

What are the various type of snapshots?

Description : What are the various type of snapshots?

Last Answer : Simple and Complex.

What are the different type of Segments ?

Description : What are the different type of Segments ?

Last Answer : Data Segment, Index Segment, Rollback Segment and Temporary Segment.

What are the type of Synonyms?

Description : What are the type of Synonyms?

Last Answer : There are two types of Synonyms Private and Public.