Set of fields in database taken collectively to identify any row uniquely is called Candidate key...
So Database has more than 1 Candidate key...
Primary key is the Candidate key choosen by the...
Type: Posts; User: sunshine60india; Keyword(s):
Re: Primary key & foreign key
Set of fields in database taken collectively to identify any row uniquely is called Candidate key...
So Database has more than 1 Candidate key...
Primary key is the Candidate key choosen by the...
Re: oracle 9i and oracle 10g
'i' stands for Internet Capabilities because it supports Internet Application...
'g' stands for Grid Computing as it supports....
Set of fields in database taken collectively to identify any row uniquely is called Candidate key...
So Database has more than 1 Candidate key...
Primary key is the Candidate key choosen by the...
Re: Dual Table in Oracle
Dual is small Oracle work table that consist of exactly 1 row and 1 column..
This table is not available in SQL Server...
Ex:
SELECT 2*2 FROM dual;
For adding column to the table...
ALTER TABLE table-name ADD column-name type(size);
For inserting data into added column
UPDATE table-name SET column-name =value WHERE...