Prepare for your Next Interview
This is a discussion on its a bet if u solve it within the Oracle forums, part of the Databases category; how to change the position of column in a table...
|
|||
|
Re: its a bet if u solve it
dats a question i want to hear,
1st i m stuck 2nd i have a table which has a long list of columns and with a 5 views connecting with and i have altered dat table and added 7 columns simultaneously but with a mistake devloper droped 2 columns by mistake and i need to affix dis up by adding 2 new columns but dat new columns has added at d end of the list of all columns , the problem is i want 2 columns on same position where it was coz i dnt want to show to my senior dba so as far as i can hide for some days but not 4 long. i cant drop dat table and recreate dat again coz 5 views are connecting with this along with triggers and synomns. so wat wud i do tell me??? |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| solve it | vmshenoy | Brainteasers | 1 | 01-24-2007 03:33 PM |
| solve this | arunjanghu | Brainteasers | 6 | 01-15-2007 09:53 AM |
| can u solve it | arunjanghu | Brainteasers | 7 | 01-13-2007 04:16 AM |
| Can you Solve | sripri | Brainteasers | 7 | 01-04-2007 07:20 AM |
| Can you solve this...? | psuresh1982 | Brainteasers | 2 | 11-07-2006 02:47 AM |