Member Avatar for djbsabkcb

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

  • 2 Contributors
  • 1 Reply
  • 95 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by jim mcnamara
Member Avatar for jim mcnamara 
SQL> col brackets format a7 trunc
SQL> select '[     ]' brackets,
                my_field1
           from mytable;

BRACKET MY_FIELD1
-------   ---------------
[     ]      JOHN SMITH
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.