Free tcp Oracle access for testing your sql scripts.

[fcastrog]

Hello!:
Does anybody know about a free oracle server in internet available for testing your sql scripts?

For example:
I want to test the next code...
select translate('123grg','3','6') from dual;

Or...

create table Example(field varchar2(100));
insert into Example values ('123grg');
commit;
select translate(field,'3','6') from example;

Only for temporal testing...
Thanks.

 

[jkotan]

I don't know of any, however you CAN, for Development purposes, download Oracle Personal, create your own DB & test things.

Here are the results of your queries:
select translate('123grg','3','6') from dual;
TRANSL
------
126grg


SQL> create table Example(field varchar2(100));

Table created.

SQL> insert into Example values ('123grg');

1 row created.

SQL> commit;

Commit complete.

SQL> select translate(field,'3','6') from example;

TRANSLATE(FIELD,'3','6')
----------------------------------------------
126grg



Jim

 

[jkotan]

One thing I just thought of: Go to

http://wwww.DBTune.com

and see if they do it there. I remember something about them offering free access but don't remember exactly what it was.
Jim