Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

oracle - Showing only actual column data in SQL*Plus -


i'm spooling out delimited text files sql*plus, every column printed full size per definition, rather data in row.

for instance, column defined 10 characters, row value of "test", printing out "test " instead of "test". can confirm selecting column along value of length function. prints "test |4".

it kind of defeats purpose of delimiter if forces me fixed-width. there set option fix this, or other way make print actual column data.

i don't want add trim every column, because if value stored spaces want able keep them.

thanks

i have seen many sql*plus script, create text files this:

select || ';' || b || ';' || c || ';' || d t ... 

it's strong indication me can't switch variable length output set command.

instead of ';' can of course use other delimiter. , it's query escape characters confused delimiter or line feed.


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -