« Star Jones is Hiding Her Candy | Main | Guys... the birds are dying. I'm so pissed. Cya L8r. »

April 11, 2006

SQL nerds, HELP!

create view custrep (customer, street_add, csz) as
select customer_name, street, rtrim(city)||', '||state||' '||zip
from customer;

clear columns

column customer heading 'Customer|Name' format a40
column street_add heading 'Customer|Address' format A13
column csz heading 'Customer|City/State/Zip' format A25

set linesize 80
set pagesize 50

select *
from custrep;

Posted by aristan at April 11, 2006 12:37 AM

Malbela.Com requires the use of TypeKey in order to add comments to the site. This helps the site be much more enjoyable for everyone involved.

TypeKey is free and your privacy is assured by the guys at SixApart/MovableType.

Comments

Post a comment

Thanks for signing in, . Now you can comment.

Wanna sign out?

If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.

Remember me?