Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: formatting SQL tables

Re: formatting SQL tables

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Mon, 25 Mar 2002 19:03:08 GMT
Message-ID: <MvKn8.5557$se.555092@bgtnsc04-news.ops.worldnet.att.net>


Remember, a standard of SQL is that you do the formatting; SQL is a retrieval and interchange / update language and protocol. You ask, you get; you send, you create or change; there is no guarantee of anything beyond committed transactions.

SQL itself does not guarantee how you get what you ask for. That is particularly and most aggravating for application developers I've worked with. To whom I have often said "Oracle gave you what you asked for; it's your problem you didn't know how to ask it nicely." (I have never said that but I have been sorely tempted.)

Delimiting by double quotes, double double quotes, double single quotes, single single quotes, unit separator character ( | ), if not carefully looked over syntactically, can cause grief.

Good luck with this, you've gotten some good advice already.

RSH. "Mark Gifford" <mgiff2002_at_hotmail.com> wrote in message news:ba3acda6.0203241614.5af0a874_at_posting.google.com...
> Hi,
>
> I'm a bit new to Oracle and SQL and I'm not even sure if this is
> really the right forum to be posting on but anyway...
>
> I have a form on an HTML page that calls a perl script and this
> connects to a db and through SQL (oracle 8.0) and retrieves some data
> from a table. This then gets published on the HTML page. The perl
> script that I got seems to retrieve each row of the table one at a
> time with one space in between each field. By the end of the row the
> columns are all over the place. Is there some way of formatting the
> table so that the columns line up nicely? Maybe some SQL which would,
> each time the script connects to the db, format the columns.
> Anyway, thanks in advance for your time
>
> Mark
Received on Mon Mar 25 2002 - 13:03:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US