We cant rename a column in 8i.but in 9i we can do. thse datatype of large

difference between oracle 8i and oracle 9i

Question Posted / thiyagarajan

Answer Posted / thiyagarajan

We cant rename a column in 8i.but in 9i we can do.
thse datatype of large object in oracle 8i is long but in
9i.it is LOB(large objects)

Is This Answer Correct ?

20 Yes

16 No

Please Help Members By Posting Answers For Below Questions

Can you load data into multiple tables at once? : aql loader

1117

what is transaction? : Sql dba

1057

explain the difference between delete , truncate and drop commands? : Sql dba

1141

what are date and time data types? : Sql dba

1024

How do I make my sql query run faster?

1013

What is an alias command?

1111

Differentiate between pl/sql and sql?

1211

how can we know the count/number of elements of an array? : Sql dba

1104

What is compound trigger?

1097

what are the advantages a stored procedure? : Sql dba

1016

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1117

How can you create an empty table from an existing table?

1125

How run sql*plus commands that are stored in a local file?

1110

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1028

what is 'mysqlcheck'? : Sql dba

1063