Geeks Talk

Prepare for your Next Interview




its a bet if u solve it

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...


Go Back   Geeks Talk > Databases > Oracle

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 08-18-2008
Junior Member
 
Join Date: Jan 2008
Location: new delhi
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
nishantsethi is on a distinguished road
its a bet if u solve it

how to change the position of column in a table

Last edited by nishantsethi : 08-18-2008 at 04:33 AM.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 08-19-2008
Expert Member
 
Join Date: Sep 2007
Posts: 754
Thanks: 22
Thanked 64 Times in 63 Posts
krishnaindia2007 is on a distinguished road
Re: its a bet if u solve it

>>how to change the position of column in a table

What is the use ? Why you want to change the position?
Reply With Quote
  #3 (permalink)  
Old 08-19-2008
Junior Member
 
Join Date: Jan 2008
Location: new delhi
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
nishantsethi is on a distinguished road
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???
Reply With Quote
  #4 (permalink)  
Old 08-19-2008
Junior Member
 
Join Date: Aug 2008
Location: United States
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
prem_18 is on a distinguished road
Re: its a bet if u solve it

Only a DBA can do that using Enterprise Manager in Oracle
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle


Thread Tools
Display Modes


Similar Threads

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


All times are GMT -4. The time now is 07:32 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved