Re: Does CHR(10) add an extra newline?

Brian Tkatch wrote:
On Thu, 22 Nov 2007 04:32:22 -0800 (PST), Frank van Bortel
<frank.van.bortel@xxxxxxxxx> wrote:

On 21 nov, 20:53, Brian Tkatch <N/A> wrote:
On Wed, 21 Nov 2007 11:40:24 -0800 (PST), "fitzjarr...@xxxxxxx"
<SNIP>
You normally would not create views "on the fly"...

True. But i don't see what that has to do with anything. I did not
mean to sound like i was complaining how i want something to work. I
am asking why it works the way that it does.

It is quite often an indication of (bad) SQL Server habits
being ported to Oracle. Oracle does things differently; it's
better to start with that in mind. Creating objects on the fly
is something that should not be permitted in any environment,
even SQL Server.
For SQL Server, temporary tables may be an exception.

I just wanted to point that out... There's one exception, I can
think of - when delivering an update (or install) script for
maintenance purposes.


Apart from that - there's no need for carriage returns in DDL,

There is, if i want it to look pretty. :)

Well - who's going to see the code? It was my understanding the code
being generated was to be executed, using dynamic SQL?
[snip!]
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
.

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)
  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)