Printable View
1) There are records in table. Table has a primary key.
Suppose I disable the Primary key. Add some data. then again enable the primary key. What oracle server checks? Only duplicate records or something else also.
2) What is globle package variable?
1.Before enable primary key constriant u must Remove the duplicate values or null values in primary key columns .Other wise u will get ORA-02437 error.
2.Variables that you want to remain available between procedure calls in the same session. You can treat variables in a package like global variables