Subj : Re: Resume questions, how convey? (was: How much should I charge fo...)
To   : comp.programming,comp.lang.java.programmer,comp.lang.lisp
From : Tim X
Date : Mon Aug 29 2005 12:25 am

<rambam@bigpond.net.au> writes:

> 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)
> 

Actually, thats just standard SQL, not PL/SQL. I would advise dropping
the storage, allocation, tablespace and logging commands - it can
cause problems if yo don't know what your doing, the dba probably
woldn't be impressed and for the level he is operating at, its just
another complication not required - let it just inherit the system
defaults. Also, it may or may ot work depending on whether his login
has the right privilages, such as create table etc. 

Probably should mention that for development (i.e. not to be sold)
purposes, you can get a free copy of Oracle. The 10g version for Linux
is quite nice. Of course, I'm sure he won't be able to do any of this
as his position is so hopeless!

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!

.