Mercurial > sqlpython

testdata@eqdev> CREATE TABLE species (
> ID     NUMBER(8,0) CONSTRAINT xnn1_species NOT NULL
>                    CONSTRAINT xpk_species PRIMARY KEY,
> NAME   VARCHAR2(12) CONSTRAINT xnn2_species NOT NULL
>                     CONSTRAINT xuk1_species UNIQUE );

Executed

testdata@eqdev> :id = 0
testdata@eqdev> :name = 'turtle'
testdata@eqdev> INSERT INTO species VALUES (:id, :name);

Executed (1 rows)

testdata@eqdev> :id = 1
testdata@eqdev> :name = 'python'
testdata@eqdev> INSERT INTO species VALUES (:id, :name);

Executed (1 rows)

testdata@eqdev> :id = 2
testdata@eqdev> :name = 'parrot'
testdata@eqdev> INSERT INTO species VALUES (:id, :name);

Executed (1 rows)

testdata@eqdev> commit;

Executed

testdata@eqdev> select * from species;

ID NAME
-- ------
 0 turtle
 1 python
 2 parrot

3 rows selected.

testdata@eqdev> select *
> from species;

ID NAME
-- ------
 0 turtle
 1 python
 2 parrot

3 rows selected.

testdata@eqdev> select * from species\h

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  <head>
    <title>species</title>
    <meta http-equiv="content-type" content="text/html;charset=utf-8"/>
  </head>
  <body>
    <table id="species" summary="Result set from query on table species">
      <tr>
        <th id="header_id">
          id
        </th><th id="header_name">
          name
        </th>
      </tr>
      <tr>
        <td headers="header_id">
          0
        </td><td headers="header_id">
          turtle
        </td>
      </tr><tr>
        <td headers="header_name">
          1
        </td><td headers="header_name">
          python
        </td>
      </tr>
    </table>
  </body>
</html>

3 rows selected.

testdata@eqdev> DROP TABLE species;

Executed

testdata@eqdev>
author	catherine@dellzilla
date	Mon, 17 Nov 2008 14:26:53 -0500
parents
children	f1916065f95d