Help on SQL

From: Mahesh Menon <mehesh_at_bmerhcb1.ca.nortel.com>
Date: 4 May 1998 16:18:04 GMT
Message-ID: <6ikpns$q8e_at_bcarh8ab.bnr.ca>

hi,

[Quoted] [Quoted]    a couple of SQL related queries from an SQL 'moron'.

   ONE
---

   consider the following table which contains    the following tuple:

   SITNO NAME CATEGORY

---

   500 Mahesh UNIX

[Quoted]    i'd like to add another tuple with name = 'MENON'    and category = 'DOS'. the sitno field should be    generated automatically and should be MAX(SITNO) + 1.

   can this be done using a single SQL statement    with or without the use of temporary tables.

   TWO
---

[Quoted]    how do i insert tuples into a table containing a    'long' field using SQL*PLUS.

mahesh "clueless" menon Received on Mon May 04 1998 - 18:18:04 CEST