This forum is SQL Server and not Oracle. But this is an absurd question in any SQL. Do you know that the rows in a table have no ordering? Tables are sets, etc. You locate them by keys. Guess what! Columns have no ordering either; you locate them by name. In fact, many SQLs store the varying length columns at the end of the physical records on the disk. Good SQL use SELECT * in EXISTS() and some derived table situations. Otherwise, the column names are listed explicitly.
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing Analytics and OLAP in SQL Data and Databases: Concepts in Practice Data, Measurements and Standards in SQL SQL for Smarties SQL Programming Style SQL Puzzles and Answers Thinking in Sets Trees and Hierarchies in SQL
I am trying to add a new column between two existing columns
lets say there are there columns A B and C and now i want to add column B1 between B and C.
i am using oracle plus.
thanks
Don't worry about the order of the column. If you want it in specific order do it via select statement or create a new view with the columns specified with the correct ordinal position
adding a new column between two columns
Posted - 07/10/2011 : 14:41:35
