What is a property clause?

1 Answer

Answer :

A property clause is a named object that contains a list of properties
and their settings. Once you create a property clause you can base
other object on it. An object based on a property can inherit the setting
of any property in the clause that makes sense for that object.

Related questions

Description : Can a property clause itself be based on a property clause?

Last Answer : Yes

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Description : Can you use select in FROM clause of SQL select ?

Last Answer : Yes.

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

Description : When do you use WHERE clause and when do you use HAVING clause?

Last Answer : HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

Description : What WHERE CURRENT OF clause does in a cursor?

Last Answer : LOOP SELECT num_credits INTO v_numcredits FROM classes WHERE dept=123 and course=101; UPDATE students FHKO;;;;;;;;;SET current_credits=current_credits+v_numcredits WHERE CURRENT OF X;

Description : Explain the usage of WHERE CURRENT OF clause in cursors ?

Last Answer : WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

Description : What is the significance of having storage clause ?

Last Answer : We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free for managing row updations etc.,

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

Description : What is OLE Activation style property?

Last Answer : Specifies the event that will activate the OLE containing item.

Description : What is Current record attribute property?

Last Answer : Specifies the named visual attribute used when an item is part of the current record. Current Record Attribute is frequently used at the block level to display the current row in a multi-record ... current record, but you cannot dynamically highlight the current item, as the input focus changes.

Description : Diff. between VAT and Property Class? imp

Last Answer : Named visual attributes define only font, color, and pattern attributes; property classes can contain these and any other properties. You can change the appearance of objects at runtime by ... visual attribute settings take precedence, and any visual attribute properties in the class are ignored.

Description : What is transactional trigger property?

Last Answer : Identifies a block as transactional control block. i.e. non - database block that oracle forms should manage as transactional block.(NON- ORACLE datasource) default - FALSE.

Description : What is mouse navigate property of button?

Last Answer : When Mouse Navigate is True (the default), Oracle Forms performs standard navigation to move the focus to the item when the operator activates the item with the mouse. When Mouse Navigate is set ... the resulting validation) to move to the item when an operator activates the item with the mouse.

Description : If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Last Answer : Item level trigger fires , If item level trigger fires, property level trigger won't fire. Triggers at the lowest level are always given the first preference. The item level trigger fires first and then the block and then the Form level trigger.

Description : What are property classes ? Can property classes have trigger?

Last Answer : Property class inheritance is a powerful feature that allows you to quickly define objects that conform to your own interface and functionality standards. Property classes also allow you to make global ... all objects that inherit properties from that class. Yes . All type of triggers .

Description : What is SECURE property?

Last Answer : Hides characters that the operator types into the text item. This setting is typically used for password protection.

Description : How is it possible to select generate a select set for the query in the query property sheet?

Last Answer : By using the tables/columns button and then specifying the table and the column names.

Description : What is the remove on exit property?

Last Answer : For a modelless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.

Description : To execute row from being displayed that still use column in the row which property can be used?

Last Answer : Format trigger.

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 : What is the purpose of the product order option in the column property sheet?

Last Answer : To specify the order of individual group evaluation in a cross products.

Description : What is the "LOV of Validation" Property of an item? What is the use of it?

Last Answer : When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV. Whenever the validation event occurs. If ... the LOV and uses the text item value as the search criteria to automatically reduce the list.

Description : What are the sql clauses supported in the link property sheet?

Last Answer : Where start with having.

Description : What is Lossless join property?

Last Answer : It guarantees that the spurious tuple generation does not occur with respect to relation schemas after decomposition.

Description : How do I get around a non-compete clause?

Last Answer : When you signed the non-compete clause, did it specify a length of time?

Description : In grammar, what is a matrix clause?

Last Answer : answer:A matrix clause is a clause that surrounds an embedded clause. It is typically-but not always-the main clause of a sentence. Example: Jim's old car, which was never any good in the first place, ... is a matrix clause. which was never any good in the first place is an embedded clause.

Description : Can you guys tell me what the 72 hour real estate clause means to us in this situation?

Last Answer : From the time of notice of the other offer on that other house you have 72 hours to execute the offer you made on the other house that was accepted with this 72 hour contingency clause in your offer. ... in that time period the seller is free to accept this other offer if they choose to do so.

Description : Is this a grammatical error? What type of clause is this?

Last Answer : All three sentences need to begin with Whilst or While. Plus, it will be tedious if the author uses the same sentence structure constantly. Generally, one wants to mix sentences of different ... (unless the sentences are so long and convoluted that they're difficult and painful to follow).

Description : Do you think it's okay to teach your kids that Santa Clause/ Easter bunny/ tooth fairy exists?

Last Answer : Myth and magic are fun for kids.

Description : Is an apology still an apology if there is a but you clause in it?

Last Answer : I think I need more context to formulate an answer. It could swing both ways. More times than not, I wouldn’t think they’re not being sincere, but that’s just my opinion.

Description : I need some advice about my daughter and her belief of Santa Clause. Please help me?

Last Answer : I'm amazed she made it to 10 years old before she started questioning. I think my oldest son was 8. He had a younger brother and sister at the time, who did still believe in Santa. I told ... t believe in Santa Claus would get no presents from him under the tree each of my children were told this

Description : an adjectival clause always includes a/an -General Knowledge

Last Answer : An adjectival clause always includes a relative pronoun.

Description : which of the following is a complex sentence that contains a dependent adverbial clause? -General Knowledge

Last Answer : A complex sentence that contains a dependent adverbial clause is: Mark expects the photo to arrive when the letter arrives.

Description : which of the following sentences has a relative clause? -General Knowledge

Last Answer : The following sentence has a relative clause: The audience applauded the ambassador, who spoke for one-half hour.

Description : the establishment clause would prevent -General Knowledge

Last Answer : the mayor's office from displaying a cross.

Description : identify the sentence that contains a noun clause in italics -General Knowledge

Last Answer : The sentence that contains a noun clause is: What Betty wants is to harvest the corn.

Description : in this sentence what word begins the subordinate clause -General Knowledge

Last Answer : Dolly must clean up her room before she goes out. In this sentence, the word 'before' begins the subordinate clause.

Description : Discuss the significance of having clause with group by statement with suitable example. -Technology

Last Answer : Sometimes we do not want to see the whole output produced by a statement with Group By clause. We want to see the output only for those groups which satisfy some condition. It means we want ... the total amount of all type of transactions, it will only display the total of credit transactions only.

Description : What is the difference between the order by and group by clause when used along with the select statement. -Technology

Last Answer : The order by clause is used to show the contents of a table/relation in a sorted manner with respect to the column mentioned after the order by clause. The contents of the column can be arranged in ... a given column and then apply an aggregate function eg max(), min() etc on the entire group.

Description : A single clause standing alone is called asentence.A. compoundB. simpleO C. complexO D. incomplete?

Last Answer : B. simple

Description : Whenever there is a bluegrass festival adjective or adverb clause?

Last Answer : adjective

Description : Which of congresses powers is implied through the necessary and proper clause?

Last Answer : The power to restrict child labor

Description : Choose the group of words that is not an independent clause?

Last Answer : Experiencing unemployment during the depression.

Description : Who wrote the Santa Clause Movies?

Last Answer : Leo Benvenuti and Steve Rudnick co-wrote all 3 Santa Clause movies. They also co-wrote Space Jam and the Will Ferrell movie Kicking and Screaming

Description : What is the dance that Tim Allen does during the montage before his second Christmas Eve in the Santa Clause?

Last Answer : It was improvised and done in one take. The Director kept it because it was so good.