What is lexical reference? How can it be created?

1 Answer

Answer :

Lexical reference is place_holder for text that can be embedded in a
sql statements. A lexical reference can be created using & before the
column or parameter name.

Related questions

Description : What is bind reference and how can it be created?

Last Answer : Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

Description : How do you reference a Parameter?

Last Answer : In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER Parameter name

Description : How do you reference a parameter indirectly?

Last Answer : To indirectly reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param')

Description : What do you understand by Reference Data Sharing?

Last Answer : In oracle Fusion Reference data sharing facilitates sharing of configuration data such as jobs, grades across business units. It can be understood as buckets of reference data assigned to ... where appropriate. In Oracle Fusion Applications reference data sharing feature is also known as SetID

Description : Can a repeating frame be created without a data group as a base?

Last Answer : No

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

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 : What is a trace file and how is it created ?

Last Answer : Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.

Description : Name a tablespace automatically created when you create a database.

Last Answer : The SYSTEM tablespace.

Description : What are record groups ? * Can record groups created at run-time?

Last Answer : A record group is an internal Oracle Forms data structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to ... you define its structure and row values at design time, and they remain fixed at runtime.

Description : Which trigger are created when master -detail rela?

Last Answer : master delete property * NON-ISOLATED (default) a) on check delete master b) on clear details c) on populate details * ISOLATED a) on clear details b) on populate details * CASCADE a) per-delete b) on clear details c) on populate details

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 : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Last Answer : II) FALSE

Description : If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Last Answer : It won't, Because SYSDATE format contains time attached with it.

Description : Name the two files that are created when you generate the form give the filex extension ?

Last Answer : INP (Source File) FRM (Executable File)

Description : What are the default extensions of the files created by forms modules?

Last Answer : .fmb - form module binary .fmx - form module executable

Description : What are the default extensions of the files created by menu module?

Last Answer : .mmb, .mmx

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no

Description : What are the different file extensions that are created by oracle reports?

Last Answer : Rep file and Rdf file.

Description : What are the default extensions of the files created by library module?

Last Answer : The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary

Description : What is SYSTEM tablespace and when is it created?

Last Answer : Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.

Description : Which default Database roles are created when you create a Database?

Last Answer : CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in ... ------------ -------- CONNECT NO RESOURCE NO DBA NO SECURITY_ADMIN YES

Description : What is lexical semantics ?

Last Answer : The branch of morphology that deals with the meaning of words is called lexical semantics .

Description : What is the lexical meaning of the word "Quran" ?

Last Answer : শব্দThe word Quran comes from the Arabic word "Qarun". Which means to read. Therefore , the meaning of the word Quran is that which has been read or recited.

Description : What is the lexical meaning of the word Islam ?

Last Answer : The lexical meaning of the word Islam is surrender.

Description : What is the lexical meaning of the word Nifaq ?

Last Answer : The literal meaning of the word hypocrisy is to deceive.

Description : What is the lexical meaning of the word spreadsheet ?

Last Answer : spreadsheet

Description : What is the lexical meaning of the word sadaqah ?

Last Answer : The literal meaning of the word sadaqah is donation.

Description : What is the lexical meaning of the Arabic word ?

Last Answer : The lexical meaning of the Arabic word is eloquence

Description : What is the lexical meaning of the word ornament ?

Last Answer : The word ornament means ornament or adornment.

Last Answer : pH Literally means the ability of hydrogen ions in water

Last Answer : The literal meaning of ' Hajj ' is - to resolve , to make a wish.

Last Answer : article The lexical meaning of the word is one , one , one , one, etc.

Description : What are the stages in the compilation process? A) Feasibility study, system design and testing B) Implementation and documentation C) Lexical Analysis, syntax analysis, and code generation D) None of the above

Last Answer : Answer : C

Description : What is lexical parameter?

Last Answer : Lexical Parameter is used to replace the where, order by ………conditions at run time

Description : When a definition implies a proposal to use the definiendum to mean what is meant by the definiens it is called (A) Lexical definition (B) Stipulative definition (C) Precising definition (D) Persuasive definition

Last Answer : (B) Stipulative definition

Description : A definition that has a meaning that is deliberately assigned to some symbol is called: (A) Lexical (B) Precising (C) Stipulative (D) Persuasive

Last Answer : (C) Stipulative

Description : When the purpose of a definition is to explain the use or to eliminate ambiguity the definition is called: (A) Persuasive (B) Stipulative (C) Theoretical (D) Lexical

Last Answer : (D) Lexical

Description : A definition put forward to resolve a dispute by influencing attitudes or stirring emotions is called (A) Lexical (B) Persuasive (C) Stipulative (D) Precisions

Last Answer : (B) Persuasive

Description : Determine the nature of the following definition: ‘Poor’ means having an annual income of Rs.10,000. (A) persuasive (B) precising (C) lexical (D) stipulative

Last Answer : (B) precising

Description : Which phase of compiler generates stream of atoms ? (A) Syntax analysis (B) Lexical Analysis (C) Code generation (D) Code optimization 

Last Answer : (A) Syntax analysis

Description : Consider the following statements related to compiler construction: I. Lexical Analysis is specified by context-free grammars and implemented by pushdown automata. II. Syntax Analysis is specified by regular expressions and implemented by ... Only l (2) Only ll (3) Both I and II (4) Neither I nor Il

Last Answer : Answer: 4

Description : Is it acceptable to reference characters someone else created in your own writing?

Last Answer : answer:To the best of my knowledge, it's okay. I see something of the sort done all the time. Just don't use any excerpts or images or borrow anything without being very sure of your ground ... references) was being coy or just really didn't want to tangle with the sharp-fanged Disney legal machine.

Description : When one object reference variable is assigned to another object reference variable then (A) a copy of the object is created. (B) a copy of the reference is created. (C) a copy of the ... not created. (D) it is illegal to assign one object reference variable to another object reference variable.

Last Answer : (B) a copy of the reference is created.

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.