One
1. Start: The fields in the SQL code exported through Powderdesiger are lowercase and are then imported directly into Oracle.
2.bug: Unable to modify the table structure (in PL/SQL developer)---include adding delete modifications ...
3.
Obviously the table is there, delete times: Table or view does not exist ~!
Line 1th Error:
ORA-00942: The table or view does not exist
and then finally found out because my table name is lowercase, but uppercase does not appear this problem.
under normal circumstances .... The data in the dictionary is all uppercase,,,, dynamic view is lowercase ... When you use a keyword to make a table or other object's name, use the "" so that the
table name is used to cause the form to be
deleted with cascade constraints the constraint associated with it is deleted
the table that needs to be deleted is available in a select query, with the following code
--Query FOREIGN KEY constraint
select ' Alter table ' | | table_name| | ' '||' Drop Constraint ' | | '|| constraint_name| | '; '
From user_constraints
where constraint_type = ' R ' and
table_name like ' ta/_% ' escape '/';
--Query table name
select ' Drop table ' | | table_name| | ' '||';'
From User_tables
where table_name like ' ta/_% ' escape '/';
Two.
1. When the table is generated, the table name is not checked, the table is directly built, the result, the table has the primary key, and there are foreign keys, delete ah deleted, double quotes caused no effect
2. Report bugs, invalid characters, or bugs that don't exist in a table or view
3. Fix, change table name, then delete
Code: ALTER TABLE "Tbl_cert ificate _type" Rename to "TABLE2";
Here, double quotes cause the table name, where the double quotes function differently than the previous double quotes, and the previous double quotes are lowercase table names, which causes the table names to be discontinuous.