Subj : Re: Resume questions, how convey? (was: How much should I charge fo...)
To   : comp.programming,comp.lang.java.programmer,comp.lang.lisp
From : rambam
Date : Sun Aug 28 2005 12:32 pm

rem642b@Yahoo.Com (Robert Maas, see http://tinyurl.com/uh3t) writes:


> Oracle was available, but only manually via keyboard/SQL interface,
> with no way to make tables or find out what tables were already in the
> database it connected to, hence no way to play with it either manually
> or via JDBC.

You can use Oracle PL/SQL from the "keyboard" to create
tables and query the tables in the database.
The relevant commands are:

CREATE TABLE

eg:
CREATE TABLE EMPLOYEE (
EMP_ID     NUMBER(8),
LNAME      VARCHAR2(30),
FNAME      VARCHAR2(15),
HIRE_DT    DATE,
SALARY     NUMBER(8,2) )
  PCTFREE 20
  PCTUSED 50
STORAGE (
   INITIAL 200K NEXT 200K
   PCTINCREASE 0 MAXEXTENTS 50 )
TABLESPACE ts01
LOGGING ;

and

get_schema(GDA_CONNECTION_SCHEMA_TABLES)


-- 

Seek simplicity and mistrust it.
Alfred Whitehead

A witty saying proves nothing. 
Voltaire

.