Monday, September 12, 2016

Drop table error due to constraints [ ERROR due to ORA-02449: unique/primary keys in table referenced by foreign keys ]

Before drop the table If any constraints exsits drop the constraints by using the below query

else If you want to drop all the constraints and table use below query

drop table <table_name> cascade constraints

eg: drop table sample cascade constraints

It will drop all the constraints and table as well.



lvalue vs rvalue

  1. What is an lvalue? An lvalue is an object that: Has an identifiable memory location. Has a name (in most cases). Can appear on th...