you would normalize the entities of a database. This has nothing to do with SQL plus. This would be in the design stage of database modeling.

If you mean you want to get the column names etc from the db to normalize then that can be done is sql plus

desc your_table_name

Originally posted by c.ravi
hello,

Normalization is always done at design level.
once the relationships are defined nothing can be done using sql - plus.
it is just the means to ask/give data from/to database.

if ur trying for query tunning, then there r possibilities.

Normalizaton "should" always be done at design level but modifications can be caried out on the database using SQL. Dropping table columns etc all have an effect on the data although I would not suggest it unless you know what you are doing. You can continue to redefine your database after the initial design and SQL is the tool used to make these changes.

hello hjackson,

true, i agree with u .

but thats not good practise changing the table structure after the initial design is done. what i wrote was in this context.

And as u said Sql IS used for doing modifications.