sql help

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 397,868 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,530 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser:

Thread Tools Display Modes

Views: 1623 | Replies: 1

•

Join Date: Jun 2005

Location: California

Posts: 92

Reputation: djbsabkcb is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

djbsabkcb

Offline

Junior Poster in Training

sql help

Mar 8th, 2006

How would you display in your sql a column of brackets [ ] with a field width of five spaces in between?

•

Join Date: May 2004

Posts: 177

Reputation: jim mcnamara is on a distinguished road

Rep Power: 5

Solved Threads: 9

jim mcnamara jim mcnamara is offline

Offline

Junior Poster

Re: sql help

Mar 13th, 2006

Help with Code Tags

(Toggle Plain Text)

SQL> col brackets format a7 trunc
SQL> select '[     ]' brackets,
                my_field1
           from mytable;

BRACKET MY_FIELD1
-------   ---------------
[     ]      JOHN SMITH