Oracle 9i Views

[Peter Bateman]

Robert:

The normal oracle program is SQLPLUS.

The one that I like is TOAD. You can get an evaluation copy from their web 
site.

I thought Oracle discontinued ( matured ) Oracle on MPE/iX.

Regards,
Peter

>
>Thanks to all who responded with info on the create view' command and what 
>functions can be used within it.
>
>Only outstanding question now is 'How do I tell Oracle that I want to 
>create a view?', i.e. what command do I run (on an Hpe3000 I'd run the 
>program ISQL.PUB.SYS)?
>
>
>regards,
>
>Robert W.Mills
>MIS Systems Development Manager
>Windsong Services
>+44 (0)20 8309 3604
>
>
>
>   _____
>
>From: 
>powerh-l-bounces+robert.mills=windsong-services.co.uk at lists.sowder.com 
>[mailto:powerh-l-bounces+robert.mills=windsong-services.co.uk at lists.sowder.com] 
>On Behalf Of Jensen, Kim Bjørn
>Sent: 03 April 2006 12:38
>To: Robert Mills; powerh-l at lists.sowder.com
>Subject: RE: Oracle 9i Views
>
>
>
>I often use "techonthenet" as an easy reference, searching for the Oracle 
>to_date-function leads you here: 
>http://www.techonthenet.com/oracle/functions/to_date.php. Another relevant 
>function here may be "to_char".
>
>This link is informative on the issue of views: 
>http://www.techonthenet.com/sql/views.php
>
>Best Regards
>
>Kim Bjørn Jensen
>Principal Consultant
>Lindorff AS
>E-mail: kim-bjorn.jensen at lindorff.com 
><blocked::mailto:kim-bjorn.jensen at lindorff.com>
>Mailing Address: Postboks 4, NO-3833 Bø i Telemark, Norway
>
>   _____
>
>From: powerh-l-bounces+kim-bjorn.jensen=lindorff.com at lists.sowder.com 
>[mailto:powerh-l-bounces+kim-bjorn.jensen=lindorff.com at lists.sowder.com] On 
>Behalf Of Robert Mills
>Sent: 3. april 2006 13:14
>To: powerh-l at lists.sowder.com
>Subject: Oracle 9i Views
>
>
>Greetings to the -L,
>
>Have been asked to add some view's to an Oracle 9i database (have only ever 
>done this with Allbase (HP) and Sybase before).
>
>Looking for documentation on the commands to use and a list of the 
>functions that can be used in the view (have to reformat some date fields 
>from Oracle's internal format to CCYYMMDD format).
>
>Any hints on where I can get this info would be appreciated.
>
>
>regards,
>
>Robert W.Mills
>MIS Systems Development Manager
>Windsong Services
>+44 (0)20 8309 3604
>
><< Notebook.jpg >>


>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Take advantage of powerful junk e-mail filters built on patented Microsoft® 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.