Hi,

Is there anyway to insert/add a new column between two column in a table without deleting any other column???

The answer is a big NO.

But there are couple of work around for the solution.

NO This cant be done

It is not supported in Oracle :(

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.