What is self-referential integrity constraint ?
- 2 Answers
- 13526 Views
- SunGard, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / orawhiz
If a foreign key reference a parent key of the same table is
called self-referential integrity constraint
| Is This Answer Correct ? | 36 Yes | 3 No |
Answer / datta
Self-reference occurs in natural or formal languages when a
sentence or formula refers to itself. The reference may be
expressed either directly; through some intermediate
sentence or formula; or by means of some encoding. In
philosophy, it also refers to the ability of a subject to
speak of or refer to himself, herself, or itself: to have
the kind of thought expressed by the first person pronoun,
the word "I" in English. Self-reference is related to self-
reflexivity and apperception.
Self-reference is studied and has applications in
mathematics, philosophy, computer programming, and
linguistics. Self-referential statements sometimes have
paradoxical behavior.
Contents [hide]
1 Usage
2 Examples
2.1 Words
2.2 Mathematics
2.3 Sentences
2.4 Linguistics
2.5 The Fumblerules
2.6 Literature
3 See also
4 References
5 External links
Usage
The Ouroboros, a dragon that continually consumes itself,
is used as a symbol for self-reference.[citation needed]An
example of a self-referential situation is the one of
autopoiesis, as the logical organization produces itself
the physical structure which creates itself.
In metaphysics, self-reference is subjectivity,
while "hetero-reference", as it is called (see Niklas
Luhmann), is objectivity.[citation needed]
Self-reference also occurs in literature and film when an
author refers to his work in the context of the work
itself. Famous examples include Cervantes's Don Quixote,
Denis Diderot's Jacques le fataliste et son maître, Italo
Calvino's If on a winter's night a traveler, many stories
by Nikolai Gogol, Lost in the Funhouse by John Barth, Luigi
Pirandello's Six Characters in Search of an Author, and
Federico Fellini's 8½ . This is closely related to the
concepts of breaking the fourth wall and meta-reference,
which often involve self-reference.
The surrealistic painter René Magritte is famous for his
self-referential works. His painting The Treachery of
Images, shown above, includes words claiming, in French,
that it is not a pipe, the truth of which depends entirely
on whether the word "ceci" (in English, "this") refers to
the pipe depicted—or to the painting or the sentence itself.
In computer science, self-reference occurs in reflection,
where a program can read or modify its own instructions as
if they were data. Numerous programming languages support
reflection to some extent with varying degrees of
expressiveness. Additionally, self-reference is seen in
recursion (related to the mathematical recurrence
relation), where a code structure refers back to itself
during computation.
Examples
Many of the following examples appear in Douglas
Hofstadter's Gödel, Escher, Bach: an Eternal Golden Braid,
Metamagical Themas, or I Am a Strange Loop.
Words
A word that describes itself is called an autological word
(or autonym). This generally applies to adjectives, for
example sesquipedalian, but can also apply to other parts
of speech, such as TLA, as a three-letter abbreviation for
three-letter abbreviation, and PHP which is a recursive
acronym for "PHP: Hypertext Preprocessor".
See: Appendix:Autological words.
Mathematics
Impredicativity
Loop (graph theory)
Tupper's self-referential formula
Sentences
"Yields falsehood when preceded by its quotation" yields
falsehood when preceded by its quotation. (This is a
version of the liar paradox, an example of indirect self-
reference through a quine, which leads to a paradox.)
Russell's paradox: The set of all sets which are not
elements of themselves (which includes, and therefore does
not, and therefore does include itself)
| Is This Answer Correct ? | 0 Yes | 9 No |
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
How to display row numbers with the records?
How to create id with auto_increment on oracle?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
What are the oracle differences between nvl and coalesce
What are the basic element of Base configuration of an oracle Database ?
What is a named program unit?
How many types of cluster table in Oracle?
What is user managed backup in Oracle?
1. what is a single procedure? 2. suppose a view constructed on a query... after that in the master table a column was dropped, then what will be the status of that view? will it be invalid or something else? 3. what is mutating table error? how can you solve that problem? 4. suppose "select * from emp where empno=7788;" is running slow because of what ever the cause it is.. how can you fix it and make the execution faster? 5. will the snapshot of data will be stored in the RAM , where will ir be stored exactly. 6. how to delete 100 tables or 100000 tables' data from the schema without writing delete statement for no.of times. write an sql statement to do that job. 7. suppose a package contains so many cursors, procedures and all.. and we are using such types of procedures so many in a program. so the execution is to be stored all those packages and all to the RAM. utimately it is using many resources for each time execution. how can you reduce the time and using of resources for each execution because the query need to be run many times. how can you tune that? 8. suppose a procudere is there with specs as (a,b,c,d), all of these are IN mode only then while calling them should we pass all the 4 arguments? how to pass (b,c) only.. how ever the specs are wrote in the same order displayed in the above? 9. a function is returning a table type, how to access that function in a select statement? 10. i have a table in database A and another table in database B, how can you access the data of these two tables? write a query for that with dblinks. 11. i have two tables might have 15/20 columns in that.. i wanna send these columns(table) to the front end application for example you are using asp.net by writing a procedure. write that to perform the above job. 12. shall we create a table in the package? 13. shall we create a table in the procedure? 14. suppose i have 10 records, in that i want to select 7th record. write a query for that. cant you use rownum for this? 15. suppose my procedure has got around 20 select statements, in that some three select statements are running very slow. what will you write to detect which queries are running slowly? 16. what fields you use frequently in plan_table? 17. what is pipeline function? explain me with an example. 18. does a unique column can contain more than one null? 19. how many hints are there provided by oracle?
how to hide the stored procedure inside a package
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
Oracle General 
