oracle - Columns displayed in incorrect order when select * from table in sql developer -


when use select * statement in sql developer, order of columns returned not order defined in table. if view table in connections pane, under columns tab columns in correct order , have correct column id assigned. when else runs query on table using different pc, columns displayed in correct order. leads me believe setting in sql developer. if i'm correct, how can change this.

ex. columns in order according column id in columns tab. left right order displayed when select * performed on table other pc:

1. message_id 2. source_id 3. event_id 4. when_created 5. container_id 6. container_type 7. wave_number 8. location 9. dest_location 10. item_name 11. batch_number 12. barcode 13. container_quantity 14. cube_volume 15. order_id 16. pick_status 17. pick_put_location 18. item_quantity 19. picked_quantity 20. required_quantity 21. mod_date 22. user_id

however, when select * table in sql developer on pc, order appear left right:

1. wave_number 2. location 3. item_name 4. batch_number 5. barcode 6. container_id 7. container_quantity 8. cube_volume 9. order_id 10. pick_status 11. pick_put_location 12. item_quantity 13. picked_quantity 14. required_quantity 15. mod_date 16. user_id 17. message_id 18. source_id 19. event_id 20. when_created 21. container_type 22. dest_location

right-click on column header , select 'delete persisted settings'

i'm guessing @ point or else on machine re-ordered columns.

this reset stored order in sql developer.

like so...


Comments

Post a Comment

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

Image
i developing site in angularjs ui-router. have situation on button click need change , load 3 state page , 3 looks image .please me how can load multiple pages. in 1 page you need configure router config this: $stateprovider .state("state1", { url: "/url1", controller: "firstcontroller", views: { view1: { templateurl: "templates/template1.html" }, view2: { templateurl: "templates/template2.html" }, view3: { templateurl: "templates/template3.html" } } }).state("state2", { url: "/url2", controller: "secondcontroller", views: { view1: { templateurl: "templates/template4.html" }, view2: { templateurl: "templates/template5.html" }, view3: { templateurl: "templates/template6.html" } }).state("state3", { ...
Read more

python - GRASS parser() error -

i'm trying use grass on python 2.7, i'm having problems @ setting script on idle, i'm getting error @ parser() function: here script: import os import sys gisbase = os.environ['gisbase'] = 'c:\program files (x86)\grass gis 7.0.1rc1' gisrc = 'c:\grassdata' gisdbase = 'c:\grassdata' location = 'newlocation' mapset = 'tc' ld_library_path = 'c:\program files (x86)\grass gis 7.0.1rc1\lib' path = 'c:\program files (x86)\grass gis 7.0.1rc1\etc';'c:\program files (x86)\grass gis 7.0.1rc1\etc\python';'c:\program files (x86)\grass gis 7.0.1rc1\lib';'c:\program files (x86)\grass gis 7.0.1rc1\bin';'c:\python27';'c:\program files (x86)\grass gis 7.0.1rc1\python27';'c:\program files (x86)\grass gis 7.0.1rc1\msys' pythonlib = 'c:\python27' pythonpath = 'c:\program files (x86)\grass gis 7.0.1rc1\etc\python' sys.path.append(os.path.join(os.environ['...
Read more

Swift game error message -

i following ios game tutorial. cannot figure out wrong here. error on these 2 lines. let newangle = percent * 180 - 180 cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi); 180.0 //error "use of unresolved identifier 'percent'" the tutorial uses: cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi)/ 180.0 but changed error suggested import spritekit class gamescene: skscene { var cannon: skspritenode! var touchlocation:cgpoint = cgpointzero override func didmovetoview(view: skview) { /* setup scene here */ cannon = self.childnodewithname("cannon") as! skspritenode } override func touchesbegan(touches: set<uitouch>, withevent event: uievent?) { /* called when touch begins */ touchlocation = touches.first!.locationinnode(self) } override func touchesmoved(touches: set<uitouch>, withevent event: uievent?) { touchlocation = touches.first!.locationinn...
Read more