issue with the query output in unix

Shell Programming and Scripting
1

I am running a query with contains blank spaces in between in the output. But when I open and read the file in UNIX i am not able to cursor the balnk spaces instead it is moving like tabs. Please help

suppose my query -

 
Select '  '||text from tab1;

the cursor should move to 1st and 2nd blank space but it is directly moving to text field trating the blank space as tabs.

2

Are you sure it is actually blank space?

If you are using vim, do ":l" to see the line,

                Leading spaces
                Leading tabs
:.,.+1l

                Leading spaces$
^I^ILeading tabs$