Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.cwix.com!news.maxwell.syr.edu!postnews1.google.com!not-for-mail
From: waichoi@yahoo.com (Unbreakable)
Newsgroups: comp.databases.oracle.server
Subject: Re: NewBie type Oracle question
Date: 12 Oct 2003 21:23:11 -0700
Organization: http://groups.google.com
Lines: 24
Message-ID: <3c38d571.0310122023.2b2c6c3e@posting.google.com>
References: <3c38d571.0310100136.3c478ee2@posting.google.com> <1efdad5b.0310100915.1eff238@posting.google.com> <3f86ed30$1@rutgers.edu>
NNTP-Posting-Host: 202.146.98.179
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1066018991 13655 127.0.0.1 (13 Oct 2003 04:23:11 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 13 Oct 2003 04:23:11 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245194

thanks for all the reply.
    -----------------------
    I will try to pratice with    
    ERwin    
    http://www3.ca.com/Solutions/Product.asp?ID=260
    
    BTW, as I saw my freind develope the PL/SQL which has 1000 lines
SQL of code.  It has  Package/function/commit command.
    
    Since I can only enter few lines of command into SQL*Plus.  (Using
A can add some more line but just not 100 lines)
    
    It anything like using Ultra-edit to copy or FTP the file to
Oracle Server?
    
    What is the formal way to do it?  when I wish to develop liek 1000
lines of code?

  Also, i read the PL/SQL book.  it only show me SQL command, liek
select, View, Group by.  but it doesn't talk too much about the
program structure using SQL (Package, fucnton..)  Any material you
guys can recommend?
    
    Thanks all