Oracle FAQ - User contributions [en]

DBMS JOB complex scheduling

2013-05-24T16:52:32Z

Michel Cadot: /* Setting the internal variables */

This page describes two ways to schedule a job when the rule is not a simple expression that can be given in the ''interval'' parameter of the <tt>DBMS_JOB.SUBMIT</tt> function: "custom function" and "setting the internal Oracle variables".

= Custom function =

To determine the date of the next execution, the job coordinator executes the dynamic SQL 'select '||interval||' from dual', where "interval" is the value of the parameter of same name you gave at job submission. So this ''interval'' can be anything that returns a date and so can be a custom function.

'''Note''': this call from the coordinator is made '''before''' the execution of the expression in ''what'' parameter.

We will apply this at 2 examples:
- execute the job every week day at 7AM and on Saturday at 10AM.
- execute the job every 10 minutes from Monday to Friday, from 8AM to 10AM and from 2PM to 4PM

== First example ==

We create the following function:

create or replace function NextJobDate return date is
now date := sysdate;
begin
case
when to_number(to_char(now,'D')) = to_number(to_char(to_date('03/07/2004','DD/MM/YYYY'),'D'))
then /* Saturday */
if to_number(to_char(now,'HH24')) < 10 then /* before 10AM -> next = 10AM */
return trunc(now)+10/24;
else /* after 10AM -> next = Monday */
return trunc(now)+2+7/24;
end if;
when to_number(to_char(now,'D')) = to_number(to_char(to_date('04/07/2004','DD/MM/YYYY'),'D'))
then /* Sunday -> next = Monday morning */
return trunc(now)+1+7/24;
when to_number(to_char(now,'HH24')) <= 7
then /* week day before 7AM -> next = 7AM */
return trunc(now)+7/24;
when to_number(to_char(now,'D')) = to_number(to_char(to_date('02/07/2004','DD/MM/YYYY'),'D'))
then /* Friday after the hour -> next = Saturday morning */
return trunc(now)+1+10/24;
else /* -> weekday after the hour, next = tomorrow morning */
return trunc(now)+1+7/24;
end case;
end;
/

In this case, the parameter ''interval'' is set to '''NextJobDate'''.

== Second example ==

We create the following function:

create or replace function NextJobDate (nbMin number) return date is
/*-----------------------------------------------------------*/
/* */
/* Parameter : nbMin=number of minutes to the next execution */
/* */
/*-----------------------------------------------------------*/
now date := sysdate;
begin
case
when to_number(to_char(now,'D')) = to_number(to_char(to_date('03/07/2004','DD/MM/YYYY'),'D'))
then /* Saturday -> next = Monday morning */
return trunc(now)+2+8/24;
when to_number(to_char(now,'D')) = to_number(to_char(to_date('04/07/2004','DD/MM/YYYY'),'D'))
then /* Sunday -> next = Monday morning */
return trunc(now)+1+8/24;
when to_number(to_char(now,'HH24')) < 8
then /* before 8AM -> next = 8AM */
return trunc(now)+8/24;
when to_number(to_char(now,'HH24')) >= 10 and to_number(to_char(now,'HH24')) < 14
then /* after 10AM and before 2PM -> next = 2PM */
return trunc(now)+14/24;
when to_number(to_char(now,'HH24')) >= 16
then /* after 4PM -> next = tomorrow or next Monday 8AM */
if to_number(to_char(now,'D')) =
to_number(to_char(to_date('02/07/2004','DD/MM/YYYY'),'D'))
then /* Friday -> next = Monday morning */
return trunc(now)+3+8/24;
else /* Other week day -> next = tomorrow morning */
return trunc(now)+1+8/24;
end if;
else /* otherwise next in nbMin minutes */
return now+nbMin/24/60;
end case;
end;
/

In this case, the parameter ''interval'' is set to '''NextJobDate(10)'''.

= Setting the internal variables =

When the job coordinator has to execute a job, it first set the internal (bind) variable ''job'' with the value of SYS.JOB$.JOB column and the internal variable ''mydate'' with the result of the dynamic query "''select ||interval|| from dual''" where ''interval'' comes from the same SYS.JOB$ table. Then it executes the following dynamic PL/SQL block:
DECLARE
job BINARY_INTEGER := :job;
next_date DATE := :mydate;
broken BOOLEAN := FALSE;
BEGIN
<<< Value of the column SYS.JOB$.WHAT >>>
:mydate := next_date;
IF broken THEN :b := 1; ELSE :b := 0; END IF;
END;
/

As we can see the variable ''next_date'' is set to the value of the bind variable '':mydate'' at the beginning of the block and this later bind variable is set back with the content of the former one at the end of the block, after the execution of the code inside the ''what'' column. In the end, after the execution of this PL/SQL block, the job coordinator updates the column SYS.JOB$.NEXT_DATE with the content of the bind variable '':mydate''.

So if the code inside ''what'' column modifies the value of the ''next_date'' variable this modification is passed on the SYS.JOB$.NEXT_DATE column.

Here's an example to see what has been said. We create a table that will contain some messages from the job and a procedure that will be executed by the job. This procedure will modify the hour of the next execution (to tomorrow 3AM) and stored in the table the date before and after modification. Then, we will create the job, query USER_JOBS view to check the NEXT_DATE column, execute the job and check again the same USER_JOBS view.

SQL> create table job_msg (msg varchar2(80));

Table created.

SQL> create or replace procedure job_proc (p_job in number, p_next_date in out date)
2 as
3 l_next_date date := p_next_date;
4 begin
5 p_next_date := trunc(sysdate)+1+3/24;
6 insert into job_msg values (
7 'next_date planned: "' || to_char(l_next_date,'DD/MM/YYYY HH24:MI:SS') ||
8 '", next_date modified: "'||to_char(p_next_date,'DD/MM/YYYY HH24:MI:SS')||'"'
9 );
10 end;
11 /

Procedure created.

SQL> variable j number
SQL> set null null
SQL> col interval format a10
SQL> exec dbms_job.submit(:j,'job_proc(job,next_date);');

PL/SQL procedure successfully completed.

SQL> select interval,
2 to_char(last_date,'DD/MM/YYYY HH24:MI:SS') last_date,
3 to_char(next_date,'DD/MM/YYYY HH24:MI:SS') next_date
4 from user_jobs where job = :j;

INTERVAL LAST_DATE NEXT_DATE
---------- ------------------- -------------------
null null 22/04/2005 11:52:45

SQL> exec dbms_job.run(:j);

PL/SQL procedure successfully completed.

SQL> select interval,
2 to_char(last_date,'DD/MM/YYYY HH24:MI:SS') last_date,
3 to_char(next_date,'DD/MM/YYYY HH24:MI:SS') next_date
4 from user_jobs where job = :j;

INTERVAL LAST_DATE NEXT_DATE
---------- ------------------- -------------------
null 22/04/2005 11:52:45 23/04/2005 03:00:00

SQL> select msg from job_msg;

MSG
--------------------------------------------------------------------------------
next_date planned: "", next_date modified: "23/04/2005 03:00:00"

'''Note''': The name of the variables passed to the job procedure are mandatory as they are the name of the variables inside the internal PL/SQL block seen above.

'''Note''': This method is very useful when the date of the next execution is hard to compute or depends on (the result of) the current execution of the job.

[[Category:PL/SQL Packages]]

DBMS JOB complex scheduling

2013-05-24T16:47:58Z

Michel Cadot: /* First example */

This page describes two ways to schedule a job when the rule is not a simple expression that can be given in the ''interval'' parameter of the <tt>DBMS_JOB.SUBMIT</tt> function: "custom function" and "setting the internal Oracle variables".

= Custom function =

To determine the date of the next execution, the job coordinator executes the dynamic SQL 'select '||interval||' from dual', where "interval" is the value of the parameter of same name you gave at job submission. So this ''interval'' can be anything that returns a date and so can be a custom function.

'''Note''': this call from the coordinator is made '''before''' the execution of the expression in ''what'' parameter.

We will apply this at 2 examples:
- execute the job every week day at 7AM and on Saturday at 10AM.
- execute the job every 10 minutes from Monday to Friday, from 8AM to 10AM and from 2PM to 4PM

== First example ==

We create the following function:

create or replace function NextJobDate return date is
now date := sysdate;
begin
case
when to_number(to_char(now,'D')) = to_number(to_char(to_date('03/07/2004','DD/MM/YYYY'),'D'))
then /* Saturday */
if to_number(to_char(now,'HH24')) < 10 then /* before 10AM -> next = 10AM */
return trunc(now)+10/24;
else /* after 10AM -> next = Monday */
return trunc(now)+2+7/24;
end if;
when to_number(to_char(now,'D')) = to_number(to_char(to_date('04/07/2004','DD/MM/YYYY'),'D'))
then /* Sunday -> next = Monday morning */
return trunc(now)+1+7/24;
when to_number(to_char(now,'HH24')) <= 7
then /* week day before 7AM -> next = 7AM */
return trunc(now)+7/24;
when to_number(to_char(now,'D')) = to_number(to_char(to_date('02/07/2004','DD/MM/YYYY'),'D'))
then /* Friday after the hour -> next = Saturday morning */
return trunc(now)+1+10/24;
else /* -> weekday after the hour, next = tomorrow morning */
return trunc(now)+1+7/24;
end case;
end;
/

In this case, the parameter ''interval'' is set to '''NextJobDate'''.

== Second example ==

We create the following function:

create or replace function NextJobDate (nbMin number) return date is
/*-----------------------------------------------------------*/
/* */
/* Parameter : nbMin=number of minutes to the next execution */
/* */
/*-----------------------------------------------------------*/
now date := sysdate;
begin
case
when to_number(to_char(now,'D')) = to_number(to_char(to_date('03/07/2004','DD/MM/YYYY'),'D'))
then /* Saturday -> next = Monday morning */
return trunc(now)+2+8/24;
when to_number(to_char(now,'D')) = to_number(to_char(to_date('04/07/2004','DD/MM/YYYY'),'D'))
then /* Sunday -> next = Monday morning */
return trunc(now)+1+8/24;
when to_number(to_char(now,'HH24')) < 8
then /* before 8AM -> next = 8AM */
return trunc(now)+8/24;
when to_number(to_char(now,'HH24')) >= 10 and to_number(to_char(now,'HH24')) < 14
then /* after 10AM and before 2PM -> next = 2PM */
return trunc(now)+14/24;
when to_number(to_char(now,'HH24')) >= 16
then /* after 4PM -> next = tomorrow or next Monday 8AM */
if to_number(to_char(now,'D')) =
to_number(to_char(to_date('02/07/2004','DD/MM/YYYY'),'D'))
then /* Friday -> next = Monday morning */
return trunc(now)+3+8/24;
else /* Other week day -> next = tomorrow morning */
return trunc(now)+1+8/24;
end if;
else /* otherwise next in nbMin minutes */
return now+nbMin/24/60;
end case;
end;
/

In this case, the parameter ''interval'' is set to '''NextJobDate(10)'''.

= Setting the internal variables =

When the job coordinator has to execute a job, it first set the internal (bind) variable ''job'' with the value of SYS.JOB$.JOB column and the internal variable ''mydate'' with the result of the dynamic query "''select ||interval|| from dual''" where ''interval'' comes from the same SYS.JOB$ table. Then it executes the following dynamic PL/SQL block:
DECLARE
job BINARY_INTEGER := :job;
next_date DATE := :mydate;
broken BOOLEAN := FALSE;
BEGIN
<<< Value of the column SYS.JOB$.WHAT >>>
:mydate := next_date;
IF broken THEN :b := 1; ELSE :b := 0; END IF;
END;
/

As we can see the variable ''next_date'' is set to the value of the bind variable '':mydate'' at the beginning of the block and this later bind variable is set back with the content of the former one at the end of the block, after the execution of the code inside the ''what'' column. In the end, after the execution of this PL/SQL block, the job coordinator updates the column SYS.JOB$.NEXT_DATE with the content of the bind variable '':mydate''.

So if the code inside ''what'' column modifies the value of the ''next_date'' variable this modification is passed on the SYS.JOB$.NEXT_DATE column.

Here's an example to see what has been said. We create a table that will contain some messages from the job and a procedure that will be executed by the job. This procedure will modify the hour of the next execution (to tomorrow 3AM) and stored in the table the date before and after modification. Then, we will create the job, query USER_JOBS view to check the NEXT_DATE column, execute the job and check again the same USER_JOBS view.

SQL> create table job_msg (msg varchar2(80));

Table created.

SQL> create or replace procedure job_proc (p_job in number, p_next_date in out date)
2 as
3 l_next_date date := p_next_date;
4 begin
5 p_next_date := trunc(sysdate)+1+3/24;
6 insert into job_msg values (
7 'next_date planned: "' || to_char(l_next_date,'DD/MM/YYYY HH24:MI:SS') ||
8 '", next_date modified: "'||to_char(p_next_date,'DD/MM/YYYY HH24:MI:SS')||'"'
9 );
10 end;
11 /

Procedure created.

SQL> variable j number
SQL> set null null
SQL> col interval format a10
SQL> exec dbms_job.submit(:j,'job_proc(job,next_date);');

PL/SQL procedure successfully completed.

SQL> select interval,
2 to_char(last_date,'DD/MM/YYYY HH24:MI:SS') last_date,
3 to_char(next_date,'DD/MM/YYYY HH24:MI:SS') next_date
4 from user_jobs where job = :j;

INTERVAL LAST_DATE NEXT_DATE
---------- ------------------- -------------------
null null 22/04/2005 11:52:45

SQL> exec dbms_job.run(:j);

PL/SQL procedure successfully completed.

SQL> select interval,
2 to_char(last_date,'DD/MM/YYYY HH24:MI:SS') last_date,
3 to_char(next_date,'DD/MM/YYYY HH24:MI:SS') next_date
4 from user_jobs where job = :j;

INTERVAL LAST_DATE NEXT_DATE
---------- ------------------- -------------------
null 22/04/2005 11:52:45 23/04/2005 03:00:00

SQL> select msg from job_msg;

MSG
--------------------------------------------------------------------------------
next_date planned: "", next_date modified: "23/04/2005 03:00:00"

'''Note''': The name of the variables passed to the job procedure are mandatory as they are the name of the variable inside the internal PL/SQL block seen above.

'''Note''': This method is very useful when the date of the next execution is hard to compute or depends on (the result of) the current execution of the job.

[[Category:PL/SQL Packages]]

DBMS JOB complex scheduling

2013-05-24T16:46:01Z

Michel Cadot: /* Custom function */

This page describes two ways to schedule a job when the rule is not a simple expression that can be given in the ''interval'' parameter of the <tt>DBMS_JOB.SUBMIT</tt> function: "custom function" and "setting the internal Oracle variables".

= Custom function =

To determine the date of the next execution, the job coordinator executes the dynamic SQL 'select '||interval||' from dual', where "interval" is the value of the parameter of same name you gave at job submission. So this ''interval'' can be anything that returns a date and so can be a custom function.

'''Note''': this call from the coordinator is made '''before''' the execution of the expression in ''what'' parameter.

We will apply this at 2 examples:
- execute the job every week day at 7AM and on Saturday at 10AM.
- execute the job every 10 minutes from Monday to Friday, from 8AM to 10AM and from 2PM to 4PM

== First example ==

We create the following function:

create or replace function NextJobDate return date is
now date := sysdate;
begin
case
when to_number(to_char(now,'D')) = to_number(to_char(to_date('03/07/2004','DD/MM/YYYY'),'D'))
then /* Saturday */
if to_number(to_char(now,'HH24')) < 10 then /* before 10AM -> next = 10AM */
return trunc(now)+10/24;
else /* after 10AM -> next = Monday */
return trunc(now)+2+7/24;
end if;
when to_number(to_char(now,'D')) = to_number(to_char(to_date('04/07/2004','DD/MM/YYYY'),'D'))
then /* Sunday -> next = Monday morning */
return trunc(now)+1+7/24;
when to_number(to_char(now,'HH24')) <= 7
then /* week day before 7AM -> next = 7AM */
return trunc(now)+7/24;
when to_number(to_char(now,'D')) = to_number(to_char(to_date('02/07/2004','DD/MM/YYYY'),'D'))
then /* Friday after the hour -> next = Saturday morning */
return trunc(now)+1+10/24;
else /* -> weekd after the hour, next = tomorrow morning */
return trunc(now)+1+7/24;
end case;
end;
/

In this case, the parameter ''interval'' is set to '''NextJobDate'''.

== Second example ==

We create the following function:

create or replace function NextJobDate (nbMin number) return date is
/*-----------------------------------------------------------*/
/* */
/* Parameter : nbMin=number of minutes to the next execution */
/* */
/*-----------------------------------------------------------*/
now date := sysdate;
begin
case
when to_number(to_char(now,'D')) = to_number(to_char(to_date('03/07/2004','DD/MM/YYYY'),'D'))
then /* Saturday -> next = Monday morning */
return trunc(now)+2+8/24;
when to_number(to_char(now,'D')) = to_number(to_char(to_date('04/07/2004','DD/MM/YYYY'),'D'))
then /* Sunday -> next = Monday morning */
return trunc(now)+1+8/24;
when to_number(to_char(now,'HH24')) < 8
then /* before 8AM -> next = 8AM */
return trunc(now)+8/24;
when to_number(to_char(now,'HH24')) >= 10 and to_number(to_char(now,'HH24')) < 14
then /* after 10AM and before 2PM -> next = 2PM */
return trunc(now)+14/24;
when to_number(to_char(now,'HH24')) >= 16
then /* after 4PM -> next = tomorrow or next Monday 8AM */
if to_number(to_char(now,'D')) =
to_number(to_char(to_date('02/07/2004','DD/MM/YYYY'),'D'))
then /* Friday -> next = Monday morning */
return trunc(now)+3+8/24;
else /* Other week day -> next = tomorrow morning */
return trunc(now)+1+8/24;
end if;
else /* otherwise next in nbMin minutes */
return now+nbMin/24/60;
end case;
end;
/

In this case, the parameter ''interval'' is set to '''NextJobDate(10)'''.

= Setting the internal variables =

When the job coordinator has to execute a job, it first set the internal (bind) variable ''job'' with the value of SYS.JOB$.JOB column and the internal variable ''mydate'' with the result of the dynamic query "''select ||interval|| from dual''" where ''interval'' comes from the same SYS.JOB$ table. Then it executes the following dynamic PL/SQL block:
DECLARE
job BINARY_INTEGER := :job;
next_date DATE := :mydate;
broken BOOLEAN := FALSE;
BEGIN
<<< Value of the column SYS.JOB$.WHAT >>>
:mydate := next_date;
IF broken THEN :b := 1; ELSE :b := 0; END IF;
END;
/

As we can see the variable ''next_date'' is set to the value of the bind variable '':mydate'' at the beginning of the block and this later bind variable is set back with the content of the former one at the end of the block, after the execution of the code inside the ''what'' column. In the end, after the execution of this PL/SQL block, the job coordinator updates the column SYS.JOB$.NEXT_DATE with the content of the bind variable '':mydate''.

So if the code inside ''what'' column modifies the value of the ''next_date'' variable this modification is passed on the SYS.JOB$.NEXT_DATE column.

Here's an example to see what has been said. We create a table that will contain some messages from the job and a procedure that will be executed by the job. This procedure will modify the hour of the next execution (to tomorrow 3AM) and stored in the table the date before and after modification. Then, we will create the job, query USER_JOBS view to check the NEXT_DATE column, execute the job and check again the same USER_JOBS view.

SQL> create table job_msg (msg varchar2(80));

Table created.

SQL> create or replace procedure job_proc (p_job in number, p_next_date in out date)
2 as
3 l_next_date date := p_next_date;
4 begin
5 p_next_date := trunc(sysdate)+1+3/24;
6 insert into job_msg values (
7 'next_date planned: "' || to_char(l_next_date,'DD/MM/YYYY HH24:MI:SS') ||
8 '", next_date modified: "'||to_char(p_next_date,'DD/MM/YYYY HH24:MI:SS')||'"'
9 );
10 end;
11 /

Procedure created.

SQL> variable j number
SQL> set null null
SQL> col interval format a10
SQL> exec dbms_job.submit(:j,'job_proc(job,next_date);');

PL/SQL procedure successfully completed.

SQL> select interval,
2 to_char(last_date,'DD/MM/YYYY HH24:MI:SS') last_date,
3 to_char(next_date,'DD/MM/YYYY HH24:MI:SS') next_date
4 from user_jobs where job = :j;

INTERVAL LAST_DATE NEXT_DATE
---------- ------------------- -------------------
null null 22/04/2005 11:52:45

SQL> exec dbms_job.run(:j);

PL/SQL procedure successfully completed.

SQL> select interval,
2 to_char(last_date,'DD/MM/YYYY HH24:MI:SS') last_date,
3 to_char(next_date,'DD/MM/YYYY HH24:MI:SS') next_date
4 from user_jobs where job = :j;

INTERVAL LAST_DATE NEXT_DATE
---------- ------------------- -------------------
null 22/04/2005 11:52:45 23/04/2005 03:00:00

SQL> select msg from job_msg;

MSG
--------------------------------------------------------------------------------
next_date planned: "", next_date modified: "23/04/2005 03:00:00"

'''Note''': The name of the variables passed to the job procedure are mandatory as they are the name of the variable inside the internal PL/SQL block seen above.

'''Note''': This method is very useful when the date of the next execution is hard to compute or depends on (the result of) the current execution of the job.

[[Category:PL/SQL Packages]]

ORA-06502

2013-05-23T15:17:55Z

Michel Cadot: Reverted edits by 115.186.139.201 (talk) to last revision by Michel Cadot

'''ORA-06502: PL/SQL: numeric or value error: %s'''

==What causes this error?==
An '''ORA-06502''' error occurs when an arithmetic, numeric, string, conversion, or constraint error occurred in a [[PL/SQL]] block. This error mainly results from programmer error or invalid data input.

An example:
SQL> DECLARE
2 i NUMBER;
3 BEGIN
4 i := ' ';
5 END;
6 /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 4

Other examples:
* An attempt is made to assign the value [[NULL]] to a variable declared NOT NULL
* An attempt is made to assign an integer larger than 999 to a variable declared NUMBER(3)
* An attempt is made to assign more than 5 characters to a VARCHAR2(5) variable

==How to fix it==
Change the data, how it is manipulated, or how it is declared so that values do not violate the declared [[data type]] definitions.

You can also capture these errors with the predefined '''VALUE_ERROR''' exception. Example:
DECLARE
i NUMBER;
BEGIN
i := ' ';
EXCEPTION
when VALUE_ERROR then
dbms_output.put_line('VALUE_ERROR exception raised');
END;
/

[[Category:Errors]]

Talk:Scripts

2013-05-21T15:39:28Z

Michel Cadot:

API ERROR

Deer All

I Get this error when run API

Error
------

1. ORA-30678: too many open connections
ORA-06512: at "SYS.UTL_TCP", line 28
ORA-06512: at "SYS.UTL_TCP", line 257
ORA-06512: at "SYS.UTL_SMTP", line 116
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "APPS.SEND_MAIL", line 12
ORA-06512: in Package EAM

API scriprt

------

DECLARE
g_return_status VARCHAR2 (1 BYTE);
g_msg_count NUMBER;
g_msg_data VARCHAR2 (2000 BYTE);
g_object_id NUMBER;
--------
v_org_id number := 696 ;
v_loc_id number;
v_item_id number;
v_dep_id number;
msg varchar2(32000);

CURSOR ASSET_CUR IS
SELECT *
FROM xx_ASSET_num
WHERE SEQ BETWEEN 3 AND 50 ;

begin

fnd_global.apps_initialize ( user_id => 5120,
resp_id => 23118,
resp_appl_id => 426 );

for I in ASSET_CUR
loop
msg:=null;

begin
SELECT msi.INVENTORY_ITEM_ID into v_item_id
FROM mtl_system_items_b msi
WHERE msi.segment1 =I.ITEM_SEG1
and msi.ORGANIZATION_ID = v_org_id ;

exception when others then
msg:=msg||' Item Not Found ';
end ;

begin
select bd.DEPARTMENT_ID into v_dep_id
from bom_departments bd
where bd.DEPARTMENT_CODE = I.OWNING_DEPARTMENT_CODE
and ORGANIZATION_ID= v_org_id;

exception when others then
msg:=msg||' Owning Department Not Found ';
end;

if msg is null then

EAM_ASSETNUMBER_PUB .INSERT_ASSET_NUMBER
(
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_validation_level => fnd_api.g_valid_level_full,
x_return_status => g_return_status,
x_msg_count => g_msg_count,
x_msg_data => g_msg_data,
x_object_id => g_object_id,
p_INVENTORY_ITEM_ID => v_item_id ,
p_SERIAL_NUMBER => I.Asset_Number ,
p_CURRENT_STATUS => 3 ,
p_DESCRIPTIVE_TEXT => I.DESCRIPTIVE_TEXT,
p_CURRENT_ORGANIZATION_ID => 696,
p_ATTRIBUTE4 => 'YES' ,
p_WIP_ACCOUNTING_CLASS_CODE => 'UFMCO' ,
p_MAINTAINABLE_FLAG => 'Y',
p_OWNING_DEPARTMENT_ID => v_dep_id ,
p_EAM_LOCATION_ID => I.EAM_LOCATION_ID
);

DBMS_OUTPUT.put_line ('Asset Number Status' || ' ' || g_return_status);
DBMS_OUTPUT.put_line ('Error Message' || g_msg_data);
DBMS_OUTPUT.put_line ('Message' || g_msg_count);

IF g_msg_count >0 THEN
FOR I IN 1..g_msg_count
LOOP
dbms_output.put_line(I||'. '||SubStr(FND_MSG_PUB.Get(p_encoded =>FND_API.G_FALSE ), 1, 255));
END LOOP;
end if;

end if ;

end loop ;
--------------------------- update source table ----------------------------
--update xx_ASSET_num AST
-- set AST.FLAG = 'Y'
-- where AST.ASSET_NUMBER = I.ASSET_NUMBER ;

end ;

/

-- This procedure is used to insert records in ----- inv.MTL_SERIAL_NUMBERS ----- table
-- EAM_ASSETNUMBER_PUB

thanks

: -------------------

: Wiki is not the place to post a question but new page or comment on page. 
: Try to post it on Forum: http://www.orafaq.com/forum/i/102589/ without forget to before read OraFAQ Forum Guide (http://www.orafaq.com/forum/t/88153/0/) and "How to use [code] tags" topic (http://www.orafaq.com/forum/t/171557/102589/) and make your code easier to read.

: [[User:Michel Cadot|Michel Cadot]] ([[User talk:Michel Cadot|talk]]) 17:39, 21 May 2013 (CEST)

Oracle database

2013-05-17T20:21:17Z

Michel Cadot: /* Desupport dates */

The '''Oracle database''' is [[Oracle Corporation]]'s flagship [[database]] product.

== Database Editions ==
The Oracle database server is available in the following editions:

=== Oracle Enterprise Edition ===
Oracle's top-end database server product for big enterprise customers.

=== Oracle Standard Edition ===
Four-processor version of Oracle Database, including full clustering support ([[Real Application Clusters]]).

=== Oracle Standard Edition One ===
Two-processor version of Standard Edition at an attractive entry-level price. While [[Real Application Clusters]] is included in the installation package, the right to use is NOT included with Standard Edition One.

=== Oracle Personal Edition ===
Full-featured version for individuals, compatible with the entire Oracle Database family (except Real Application Clusters).

=== Oracle Express Edition ===
Free version of Oracle that is limited to 1 processor, 1 GB RAM and 11 GB of data. For more info, see [[Oracle XE]].

== Database Options ==
The following optional database options can be purchased separately. These options are only available with the Enterprise Edition (the only exception is RAC):

=== Partitioning Option ===
The [[partitioning]] option allows [[DBA]]s to split large tables into more manageable sub-tables (partitions). Some of the advantages offered:
* Partitions can be stored in different [[tablespace]]s;
* Partitions can be added/ removed while users are working;
* Data can be selected from targeted partitioned without having to scan all partitions for rows (partition pruning).

=== Spatial Option ===
The Spatial option store geographical information (GPS coordinates for instance) with records.

=== Real Application Clusters Option ===
[[Real Application Clusters]] ([[RAC]]) - formerly called Oracle Parallel Server (OPS) - allows more than one instance to mount and open an Oracle database. RAC can only be used on special [[cluster]]ed systems.

=== Advanced Security Option ===
Oracle [[Advanced Security]] (ASO), formerly called the Advanced Networking Option, provides a suite of security features to protect a company's network by providing network encryption, authentication solutions, single sign-on services, and support for other security protocols. ASO is only available with Oracle Enterprise Edition.

=== Oracle Label Security ===
Row level security based on stringent government and commercial requirements; sensitivity labels (i.e. confidential, doctor-patient only, top secret) provide better intellectual property protection and privacy.

=== Oracle OLAP ===
[[Oracle OLAP]] is a powerful multidimensional calculation engine with a complete set of analytical functions fully integrated within the Oracle Database. Oracle Database OLAP Option adds multidimensional data storage to Oracle Database, of the type previously only available in the best of the separate standalone multidimensional databases. Often generically described as "cubes", Analytic Workspaces inside Oracle Database provide fast scalable query performance and ease of use, especially for calculation intensive BI (or operational) applications - and offer a sophisticated alternative to traditional summary management in modern BI/Data Warehousing architectures.

Unlike previous generation separate engines (like Oracle [[Express]] Server) however, Oracle Database cubes (their data and calculations) are available to virtually any client tool or application, via simple SQL. Because Oracle Database OLAP Option cubes are a feature of the Oracle Database, they inherit other features from the Oracle Database including Security, Performance and Scalability, High Availability and Manageability capabilities.

=== Oracle Data Mining ===
[[Oracle Data Mining]] offers embedded [[data mining]] for classifications, predictions, and associations to build advanced business intelligence applications.

=== Database Vault ===
A new option to Oracle Database 10g Release 2 Enterprise Edition that lets you control who, when, and where data and applications can be accessed, protecting against the most common security threat like malicious internal users.

===Total Recall===
Total Recall is based on Oracle's Flashback feature and will allow users to query data "AS OF" an earlier time in the past. This will allow companies to "archive" data for auditing and regulatory compliance. For more info, see [[Oracle Total Recall]].

===Advanced Compression===
Option used to compress data. For more info, see [[Oracle Advanced Compression]].

===Real Application Testing (RAT)===
RAT can be used to capture, analyze and replay database transactions. For more info, see [[Real Application Testing]].

==Database features==
A database feature, in contrast with an option, is provided free with the database software.

Most DBA's and developers work with multiple versions of Oracle at any particular time. To see what features were introduced in each version, refer to the version pages: [[Oracle 2]], [[Oracle 3]], [[Oracle 4]], [[Oracle 5]], [[Oracle 6]], [[Oracle 7]], [[Oracle 8]], [[Oracle 8i]], [[Oracle 9i]], [[Oracle 10g]], [[Oracle 11g]].

== Database version history ==
The major Oracle versions, with their latest patch-sets are:
* [[Oracle 7]]: ... - 7.3.4.5
* [[Oracle 8]]: 8.0.3 - 8.0.6
* [[Oracle 8i]]: 8.1.5.0 - 8.1.7.4
* [[Oracle 9i]] (Release 1): 9.0.1.0 - 9.0.1.4
* [[Oracle 9i]] (Release 2): 9.2.0.1 - 9.2.0.8
* [[Oracle 10g]] (Release 1): 10.1.0.2 - 10.1.0.5
* [[Oracle 10g]] (Release 2): 10.2.0.1 - 10.2.0.5
* [[Oracle 11g]] (Release 1): 11.1.0.6 - 11.1.0.7
* [[Oracle 11g]] (Release 2): 11.2.0.1 - 11.2.0.3

If running on one of the above releases, it is recommended to always install the latest patch-set.

== Desupport dates ==
Oracle 9iR2 was desupported on 31 July [[2007]]. However, customers on Oracle 9.2.0.8 received free Extended Support until July 31, [[2008]]. For details about this, see http://www.oracle.com/features/hp/database-9i-support.html

Oracle 10g Release 1 was desupported on 31 January [[2009]] and extended support ended on 31 January [[2012]].

Oracle 10g Release 2 was desupported on 31 July [[2010]] and extended support will end on 31 July [[2013]].

Oracle 11g Release 1 was desupported on 31 August [[2012]] and extended support will end on 31 August [[2015]].

Currently, [[Oracle 11g]] Release 2 is fully supported until 31 January [[2015]].

==Also see==
* [[Database Concepts and Architecture]]
* [[Oracle database FAQ]] - Frequently asked questions

[[Category:Database]]
[[Category:Database systems]]

Oracle database

2013-05-17T20:19:50Z

Michel Cadot: /* Currently supported versions */

The '''Oracle database''' is [[Oracle Corporation]]'s flagship [[database]] product.

== Database Editions ==
The Oracle database server is available in the following editions:

=== Oracle Enterprise Edition ===
Oracle's top-end database server product for big enterprise customers.

=== Oracle Standard Edition ===
Four-processor version of Oracle Database, including full clustering support ([[Real Application Clusters]]).

=== Oracle Standard Edition One ===
Two-processor version of Standard Edition at an attractive entry-level price. While [[Real Application Clusters]] is included in the installation package, the right to use is NOT included with Standard Edition One.

=== Oracle Personal Edition ===
Full-featured version for individuals, compatible with the entire Oracle Database family (except Real Application Clusters).

=== Oracle Express Edition ===
Free version of Oracle that is limited to 1 processor, 1 GB RAM and 11 GB of data. For more info, see [[Oracle XE]].

== Database Options ==
The following optional database options can be purchased separately. These options are only available with the Enterprise Edition (the only exception is RAC):

=== Partitioning Option ===
The [[partitioning]] option allows [[DBA]]s to split large tables into more manageable sub-tables (partitions). Some of the advantages offered:
* Partitions can be stored in different [[tablespace]]s;
* Partitions can be added/ removed while users are working;
* Data can be selected from targeted partitioned without having to scan all partitions for rows (partition pruning).

=== Spatial Option ===
The Spatial option store geographical information (GPS coordinates for instance) with records.

=== Real Application Clusters Option ===
[[Real Application Clusters]] ([[RAC]]) - formerly called Oracle Parallel Server (OPS) - allows more than one instance to mount and open an Oracle database. RAC can only be used on special [[cluster]]ed systems.

=== Advanced Security Option ===
Oracle [[Advanced Security]] (ASO), formerly called the Advanced Networking Option, provides a suite of security features to protect a company's network by providing network encryption, authentication solutions, single sign-on services, and support for other security protocols. ASO is only available with Oracle Enterprise Edition.

=== Oracle Label Security ===
Row level security based on stringent government and commercial requirements; sensitivity labels (i.e. confidential, doctor-patient only, top secret) provide better intellectual property protection and privacy.

=== Oracle OLAP ===
[[Oracle OLAP]] is a powerful multidimensional calculation engine with a complete set of analytical functions fully integrated within the Oracle Database. Oracle Database OLAP Option adds multidimensional data storage to Oracle Database, of the type previously only available in the best of the separate standalone multidimensional databases. Often generically described as "cubes", Analytic Workspaces inside Oracle Database provide fast scalable query performance and ease of use, especially for calculation intensive BI (or operational) applications - and offer a sophisticated alternative to traditional summary management in modern BI/Data Warehousing architectures.

Unlike previous generation separate engines (like Oracle [[Express]] Server) however, Oracle Database cubes (their data and calculations) are available to virtually any client tool or application, via simple SQL. Because Oracle Database OLAP Option cubes are a feature of the Oracle Database, they inherit other features from the Oracle Database including Security, Performance and Scalability, High Availability and Manageability capabilities.

=== Oracle Data Mining ===
[[Oracle Data Mining]] offers embedded [[data mining]] for classifications, predictions, and associations to build advanced business intelligence applications.

=== Database Vault ===
A new option to Oracle Database 10g Release 2 Enterprise Edition that lets you control who, when, and where data and applications can be accessed, protecting against the most common security threat like malicious internal users.

===Total Recall===
Total Recall is based on Oracle's Flashback feature and will allow users to query data "AS OF" an earlier time in the past. This will allow companies to "archive" data for auditing and regulatory compliance. For more info, see [[Oracle Total Recall]].

===Advanced Compression===
Option used to compress data. For more info, see [[Oracle Advanced Compression]].

===Real Application Testing (RAT)===
RAT can be used to capture, analyze and replay database transactions. For more info, see [[Real Application Testing]].

==Database features==
A database feature, in contrast with an option, is provided free with the database software.

Most DBA's and developers work with multiple versions of Oracle at any particular time. To see what features were introduced in each version, refer to the version pages: [[Oracle 2]], [[Oracle 3]], [[Oracle 4]], [[Oracle 5]], [[Oracle 6]], [[Oracle 7]], [[Oracle 8]], [[Oracle 8i]], [[Oracle 9i]], [[Oracle 10g]], [[Oracle 11g]].

== Database version history ==
The major Oracle versions, with their latest patch-sets are:
* [[Oracle 7]]: ... - 7.3.4.5
* [[Oracle 8]]: 8.0.3 - 8.0.6
* [[Oracle 8i]]: 8.1.5.0 - 8.1.7.4
* [[Oracle 9i]] (Release 1): 9.0.1.0 - 9.0.1.4
* [[Oracle 9i]] (Release 2): 9.2.0.1 - 9.2.0.8
* [[Oracle 10g]] (Release 1): 10.1.0.2 - 10.1.0.5
* [[Oracle 10g]] (Release 2): 10.2.0.1 - 10.2.0.5
* [[Oracle 11g]] (Release 1): 11.1.0.6 - 11.1.0.7
* [[Oracle 11g]] (Release 2): 11.2.0.1 - 11.2.0.3

If running on one of the above releases, it is recommended to always install the latest patch-set.

== Desupport dates ==
Oracle 9iR2 was desupported on 31 July [[2007]]. However, customers on Oracle 9.2.0.8 received free Extended Support until July 31, [[2008]]. For details about this, see http://www.oracle.com/features/hp/database-9i-support.html

Oracle 10g Release 1 was desupported on 31 January [[2009]] and extended support ended on 31 January [[2012]].

Oracle 10g Release 2 was desupported on 31 July [[2010]] and extended support will ended on 31 July [[2013]].

Oracle 11g Release 1 was desupported on 31 August [[2012]] and extended support ended on 31 August [[2015]].

Currently, [[Oracle 11g]] Release 2 is fully supported until 31 January [[2015]].

==Also see==
* [[Database Concepts and Architecture]]
* [[Oracle database FAQ]] - Frequently asked questions

[[Category:Database]]
[[Category:Database systems]]

Oracle database

2013-05-17T20:19:09Z

Michel Cadot: /* Currently supported versions */

The '''Oracle database''' is [[Oracle Corporation]]'s flagship [[database]] product.

== Database Editions ==
The Oracle database server is available in the following editions:

=== Oracle Enterprise Edition ===
Oracle's top-end database server product for big enterprise customers.

=== Oracle Standard Edition ===
Four-processor version of Oracle Database, including full clustering support ([[Real Application Clusters]]).

=== Oracle Standard Edition One ===
Two-processor version of Standard Edition at an attractive entry-level price. While [[Real Application Clusters]] is included in the installation package, the right to use is NOT included with Standard Edition One.

=== Oracle Personal Edition ===
Full-featured version for individuals, compatible with the entire Oracle Database family (except Real Application Clusters).

=== Oracle Express Edition ===
Free version of Oracle that is limited to 1 processor, 1 GB RAM and 11 GB of data. For more info, see [[Oracle XE]].

== Database Options ==
The following optional database options can be purchased separately. These options are only available with the Enterprise Edition (the only exception is RAC):

=== Partitioning Option ===
The [[partitioning]] option allows [[DBA]]s to split large tables into more manageable sub-tables (partitions). Some of the advantages offered:
* Partitions can be stored in different [[tablespace]]s;
* Partitions can be added/ removed while users are working;
* Data can be selected from targeted partitioned without having to scan all partitions for rows (partition pruning).

=== Spatial Option ===
The Spatial option store geographical information (GPS coordinates for instance) with records.

=== Real Application Clusters Option ===
[[Real Application Clusters]] ([[RAC]]) - formerly called Oracle Parallel Server (OPS) - allows more than one instance to mount and open an Oracle database. RAC can only be used on special [[cluster]]ed systems.

=== Advanced Security Option ===
Oracle [[Advanced Security]] (ASO), formerly called the Advanced Networking Option, provides a suite of security features to protect a company's network by providing network encryption, authentication solutions, single sign-on services, and support for other security protocols. ASO is only available with Oracle Enterprise Edition.

=== Oracle Label Security ===
Row level security based on stringent government and commercial requirements; sensitivity labels (i.e. confidential, doctor-patient only, top secret) provide better intellectual property protection and privacy.

=== Oracle OLAP ===
[[Oracle OLAP]] is a powerful multidimensional calculation engine with a complete set of analytical functions fully integrated within the Oracle Database. Oracle Database OLAP Option adds multidimensional data storage to Oracle Database, of the type previously only available in the best of the separate standalone multidimensional databases. Often generically described as "cubes", Analytic Workspaces inside Oracle Database provide fast scalable query performance and ease of use, especially for calculation intensive BI (or operational) applications - and offer a sophisticated alternative to traditional summary management in modern BI/Data Warehousing architectures.

Unlike previous generation separate engines (like Oracle [[Express]] Server) however, Oracle Database cubes (their data and calculations) are available to virtually any client tool or application, via simple SQL. Because Oracle Database OLAP Option cubes are a feature of the Oracle Database, they inherit other features from the Oracle Database including Security, Performance and Scalability, High Availability and Manageability capabilities.

=== Oracle Data Mining ===
[[Oracle Data Mining]] offers embedded [[data mining]] for classifications, predictions, and associations to build advanced business intelligence applications.

=== Database Vault ===
A new option to Oracle Database 10g Release 2 Enterprise Edition that lets you control who, when, and where data and applications can be accessed, protecting against the most common security threat like malicious internal users.

===Total Recall===
Total Recall is based on Oracle's Flashback feature and will allow users to query data "AS OF" an earlier time in the past. This will allow companies to "archive" data for auditing and regulatory compliance. For more info, see [[Oracle Total Recall]].

===Advanced Compression===
Option used to compress data. For more info, see [[Oracle Advanced Compression]].

===Real Application Testing (RAT)===
RAT can be used to capture, analyze and replay database transactions. For more info, see [[Real Application Testing]].

==Database features==
A database feature, in contrast with an option, is provided free with the database software.

Most DBA's and developers work with multiple versions of Oracle at any particular time. To see what features were introduced in each version, refer to the version pages: [[Oracle 2]], [[Oracle 3]], [[Oracle 4]], [[Oracle 5]], [[Oracle 6]], [[Oracle 7]], [[Oracle 8]], [[Oracle 8i]], [[Oracle 9i]], [[Oracle 10g]], [[Oracle 11g]].

== Database version history ==
The major Oracle versions, with their latest patch-sets are:
* [[Oracle 7]]: ... - 7.3.4.5
* [[Oracle 8]]: 8.0.3 - 8.0.6
* [[Oracle 8i]]: 8.1.5.0 - 8.1.7.4
* [[Oracle 9i]] (Release 1): 9.0.1.0 - 9.0.1.4
* [[Oracle 9i]] (Release 2): 9.2.0.1 - 9.2.0.8
* [[Oracle 10g]] (Release 1): 10.1.0.2 - 10.1.0.5
* [[Oracle 10g]] (Release 2): 10.2.0.1 - 10.2.0.5
* [[Oracle 11g]] (Release 1): 11.1.0.6 - 11.1.0.7
* [[Oracle 11g]] (Release 2): 11.2.0.1 - 11.2.0.3

If running on one of the above releases, it is recommended to always install the latest patch-set.

== Currently supported versions ==
Oracle 9iR2 was desupported on 31 July [[2007]]. However, customers on Oracle 9.2.0.8 received free Extended Support until July 31, [[2008]]. For details about this, see http://www.oracle.com/features/hp/database-9i-support.html

Oracle 10g Release 1 was desupported on 31 January [[2009]] and extended support ended on 31 January [[2012]].

Oracle 10g Release 2 was desupported on 31 July [[2010]] and extended support will ended on 31 July [[2013]].

Oracle 11g Release 1 was desupported on 31 August [[2012]] and extended support ended on 31 August [[2015]].

Currently, [[Oracle 11g]] Release 2 is fully supported until 31 January [[2015]].

==Also see==
* [[Database Concepts and Architecture]]
* [[Oracle database FAQ]] - Frequently asked questions

[[Category:Database]]
[[Category:Database systems]]

WHEN OTHERS

2013-05-16T17:49:37Z

Michel Cadot: /* WHEN OTHERS hides where the error comes from */

In [http://www.orafaq.com/forum forum] part of this site, we often get PL/SQL topics from people asking why their code sometimes works and sometimes does not, sometimes makes all the expected modifications and sometimes only some or none of them.

Some other questions are about how to debug a code, where to start, when the code just gives an error message.

When the code is posted, we can immediatly see the reason: code contains some EXCEPTION WHEN OTHERS clause. This Wiki page will show through examples why this clause is misleading and dangerous.

= WHEN OTHERS hides the error =

See the following execution of code with a procedure which just inserts a row in a table T:

SQL> SELECT * FROM t;

no rows selected

SQL> CREATE OR REPLACE PROCEDURE p
2 IS
3 v INTEGER;
4 BEGIN
5 v := 1;
6 FOR i IN 1..3 LOOP
7 v := 10 * v;
8 END LOOP;
9 INSERT INTO t VALUES (v);
10 EXCEPTION WHEN OTHERS THEN dbms_output.put_line (SQLERRM);
11 END;
12 /

Procedure created.

SQL> EXECUTE p;

PL/SQL procedure successfully completed.

Everything seems to have executed well and we can check it querying the table:

SQL> SELECT * FROM t;

no rows selected

Gosh! Nothing in my table but I did insert and Oracle said it did it: there was no error!

Let's comment the WHEN OTHERS clause:

SQL> CREATE OR REPLACE PROCEDURE p
2 IS
3 v INTEGER;
4 BEGIN
5 v := 1;
6 FOR i IN 1..3 LOOP
7 v := 10 * v;
8 END LOOP;
9 INSERT INTO t VALUES (v);
10 -- EXCEPTION WHEN OTHERS THEN dbms_output.put_line (SQLERRM);
11 END;
12 /

Procedure created.

SQL> EXECUTE p;
BEGIN p; END;

*
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "MICHEL.P", line 9
ORA-06512: at line 1

Oh oh! There was a value error hidden by WHEN OTHERS.
Let's see the table definition:

SQL> DESCRIBE t
Name Null? Type
-------------------------------- -------- ----------------------
VAL NUMBER(3)

Indeed the column can't get a value greater than 999 and I tried to insert 1000.
One could say "you didn't see the message because you didn't set serveroutput on", but why should I? And even, let's see in the next section what happens with a more complex code.

= WHEN OTHERS hides where the error comes from =

See this other example (code does not matter):

SQL> CREATE OR REPLACE PROCEDURE p
2 IS
...
203 EXCEPTION WHEN OTHERS THEN dbms_output.put_line (SQLERRM);
204 END;
205 /

Procedure created.

SQL> EXECUTE p
ORA-01476: divisor is equal to zero

PL/SQL procedure successfully completed.

I have an error in my code but where should I start to debug it?

Now just comment WHEN OTHERS clause:

SQL> CREATE OR REPLACE PROCEDURE p
2 IS
...
203 -- EXCEPTION WHEN OTHERS THEN dbms_output.put_line (SQLERRM);
204 END;
205 /

Procedure created.

SQL> EXECUTE p
BEGIN p; END;

*
ERROR at line 1:
ORA-01476: divisor is equal to zero
ORA-06512: at "MICHEL.P", line 69
ORA-06512: at "MICHEL.P", line 105
ORA-06512: at "MICHEL.P", line 154
ORA-06512: at line 1

I now know that the error comes from line 69 which is in a procedure that was called at line 105 which itself was called in main block at line 154.
I then know where the error came from and so I am able to start debugging my code.

= WHEN OTHERS breaks the Atomicity of a procedure call =

The first [[ACID]] property of a [[transaction]] is Atomicity. This means that either a transaction succeeds and all actions done are commited, either it fails at one point and all that has been done is rolled back which means it is like nothing have been done.

Oracle extends this transactional property to each SQL statement and even each PL/SQL anonymous block or stored procedure call.

See the following example:

SQL> create or replace procedure p is
2 begin
3 insert into t values (0);
4 dbms_output.put_line ('First row inserted');
5 insert into t values (0);
6 dbms_output.put_line ('Second row inserted');
7 end;
8 /

Procedure created.

SQL> select * from t;

no rows selected

SQL> execute p;
First row inserted
BEGIN p; END;

*
ERROR at line 1:
ORA-00001: unique constraint (MICHEL.SYS_C0012769) violated
ORA-06512: at "MICHEL.P", line 5
ORA-06512: at line 1

SQL> select * from t;

no rows selected

As you can see the first row was inserted but the procedute fails to insert the second one so Oracle rolled back the first insert statement. The procedure call was treated as a single statement and as it fails nothing have been done.

Now let's see what happens with WHEN OTHERS clause:

SQL> create or replace procedure p is
2 begin
3 insert into t values (0);
4 dbms_output.put_line ('First row inserted');
5 insert into t values (0);
6 dbms_output.put_line ('Second row inserted');
7 exception
8 when others then -- (whatever but raise or raise_application_error)
9 dbms_output.put_line ('Failed to insert a row');
10 end;
11 /

Procedure created.

SQL> select * from t;

no rows selected

SQL> execute p;
First row inserted
Failed to insert a row

PL/SQL procedure successfully completed.

SQL> select * from t;
ID
----------
0

1 row selected.

Then we see one row has been created, only one, which means the atomicity of the procedure call is broken. Something has been done but you (as the caller program) don't know how much of the procedure has been done and how much has not be done.

= When to use WHEN OTHERS? =

Actually, the only cases you have to use WHEN OTHERS are the following ones:
* You opened some resources (cursor, file...) and have to close them before leaving
* You want to log all errors
In both cases, the WHEN OTHERS THEN part '''MUST''' be ended with a "'''RAISE;'''" statement.

= External links =

* [http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1155066278457 AskTom "when other than exception, and raise application error"]
* [http://www.oracle.com/technetwork/issue-archive/2007/07-jul/o47asktom-092692.html Oracle Magazine]
* [http://tkyte.blogspot.com/2008/06/when-others-then-null-redux.html Tom Kyte Blog "when others then null, redux"]
* [http://www.google.com/search?q=site%3Atkyte.blogspot.com+%22when+others%22 T.Kyte WHEN OTHERS references]

[[Category:PL/SQL]]

WHEN OTHERS

2013-05-16T17:48:18Z

Michel Cadot: /* WHEN OTHERS hides from where the error comes from */

In [http://www.orafaq.com/forum forum] part of this site, we often get PL/SQL topics from people asking why their code sometimes works and sometimes does not, sometimes makes all the expected modifications and sometimes only some or none of them.

Some other questions are about how to debug a code, where to start, when the code just gives an error message.

When the code is posted, we can immediatly see the reason: code contains some EXCEPTION WHEN OTHERS clause. This Wiki page will show through examples why this clause is misleading and dangerous.

= WHEN OTHERS hides the error =

See the following execution of code with a procedure which just inserts a row in a table T:

SQL> SELECT * FROM t;

no rows selected

SQL> CREATE OR REPLACE PROCEDURE p
2 IS
3 v INTEGER;
4 BEGIN
5 v := 1;
6 FOR i IN 1..3 LOOP
7 v := 10 * v;
8 END LOOP;
9 INSERT INTO t VALUES (v);
10 EXCEPTION WHEN OTHERS THEN dbms_output.put_line (SQLERRM);
11 END;
12 /

Procedure created.

SQL> EXECUTE p;

PL/SQL procedure successfully completed.

Everything seems to have executed well and we can check it querying the table:

SQL> SELECT * FROM t;

no rows selected

Gosh! Nothing in my table but I did insert and Oracle said it did it: there was no error!

Let's comment the WHEN OTHERS clause:

SQL> CREATE OR REPLACE PROCEDURE p
2 IS
3 v INTEGER;
4 BEGIN
5 v := 1;
6 FOR i IN 1..3 LOOP
7 v := 10 * v;
8 END LOOP;
9 INSERT INTO t VALUES (v);
10 -- EXCEPTION WHEN OTHERS THEN dbms_output.put_line (SQLERRM);
11 END;
12 /

Procedure created.

SQL> EXECUTE p;
BEGIN p; END;

*
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "MICHEL.P", line 9
ORA-06512: at line 1

Oh oh! There was a value error hidden by WHEN OTHERS.
Let's see the table definition:

SQL> DESCRIBE t
Name Null? Type
-------------------------------- -------- ----------------------
VAL NUMBER(3)

Indeed the column can't get a value greater than 999 and I tried to insert 1000.
One could say "you didn't see the message because you didn't set serveroutput on", but why should I? And even, let's see in the next section what happens with a more complex code.

= WHEN OTHERS hides where the error comes from =

See this other example (code does not matter):

SQL> CREATE OR REPLACE PROCEDURE p
2 IS
...
203 EXCEPTION WHEN OTHERS THEN dbms_output.put_line (SQLERRM);
204 END;
205 /

Procedure created.

SQL> EXECUTE p
ORA-01476: divisor is equal to zero

PL/SQL procedure successfully completed.

I have an error in my code but where should I start to debug it?

Now just comment WHEN OTHERS clause:

SQL> CREATE OR REPLACE PROCEDURE p
2 IS
...
203 -- EXCEPTION WHEN OTHERS THEN dbms_output.put_line (SQLERRM);
204 END;
205 /

Procedure created.

SQL> EXECUTE p
BEGIN p; END;

*
ERROR at line 1:
ORA-01476: divisor is equal to zero
ORA-06512: at "MICHEL.P", line 69
ORA-06512: at "MICHEL.P", line 105
ORA-06512: at "MICHEL.P", line 154
ORA-06512: at line 1

I now know that the error comes from line 69 which is in a procedure that was called at line 105 which itself was called in main block at line 154.
I then know where the error came from and so I am able to start a debugging of my code.

= WHEN OTHERS breaks the Atomicity of a procedure call =

The first [[ACID]] property of a [[transaction]] is Atomicity. This means that either a transaction succeeds and all actions done are commited, either it fails at one point and all that has been done is rolled back which means it is like nothing have been done.

Oracle extends this transactional property to each SQL statement and even each PL/SQL anonymous block or stored procedure call.

See the following example:

SQL> create or replace procedure p is
2 begin
3 insert into t values (0);
4 dbms_output.put_line ('First row inserted');
5 insert into t values (0);
6 dbms_output.put_line ('Second row inserted');
7 end;
8 /

Procedure created.

SQL> select * from t;

no rows selected

SQL> execute p;
First row inserted
BEGIN p; END;

*
ERROR at line 1:
ORA-00001: unique constraint (MICHEL.SYS_C0012769) violated
ORA-06512: at "MICHEL.P", line 5
ORA-06512: at line 1

SQL> select * from t;

no rows selected

As you can see the first row was inserted but the procedute fails to insert the second one so Oracle rolled back the first insert statement. The procedure call was treated as a single statement and as it fails nothing have been done.

Now let's see what happens with WHEN OTHERS clause:

SQL> create or replace procedure p is
2 begin
3 insert into t values (0);
4 dbms_output.put_line ('First row inserted');
5 insert into t values (0);
6 dbms_output.put_line ('Second row inserted');
7 exception
8 when others then -- (whatever but raise or raise_application_error)
9 dbms_output.put_line ('Failed to insert a row');
10 end;
11 /

Procedure created.

SQL> select * from t;

no rows selected

SQL> execute p;
First row inserted
Failed to insert a row

PL/SQL procedure successfully completed.

SQL> select * from t;
ID
----------
0

1 row selected.

Then we see one row has been created, only one, which means the atomicity of the procedure call is broken. Something has been done but you (as the caller program) don't know how much of the procedure has been done and how much has not be done.

= When to use WHEN OTHERS? =

Actually, the only cases you have to use WHEN OTHERS are the following ones:
* You opened some resources (cursor, file...) and have to close them before leaving
* You want to log all errors
In both cases, the WHEN OTHERS THEN part '''MUST''' be ended with a "'''RAISE;'''" statement.

= External links =

* [http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1155066278457 AskTom "when other than exception, and raise application error"]
* [http://www.oracle.com/technetwork/issue-archive/2007/07-jul/o47asktom-092692.html Oracle Magazine]
* [http://tkyte.blogspot.com/2008/06/when-others-then-null-redux.html Tom Kyte Blog "when others then null, redux"]
* [http://www.google.com/search?q=site%3Atkyte.blogspot.com+%22when+others%22 T.Kyte WHEN OTHERS references]

[[Category:PL/SQL]]

Oracle Product Set

2013-05-11T06:20:43Z

Michel Cadot: /* External links */

Oracle Corporation provides the following '''products''':

== Oracle Database Server ==
The [[Oracle database]] server is available in the following editions:

=== Oracle Enterprise Edition ===
Oracle's top-end database server product.

The following optional database options can be purchased separately. These options are only available with the Enterprise Edition:

==== Partitioning Option ====
The [[partitioning]] option allows DBAs to split large tables into more manageable sub-tables (partitions). Some of the advantages offered:
* Partitions can be stored in different tablespaces;
* Partitions can be added/ removed while users are working;
* Data can be selected from targeted partitioned without having to scan all partitions for rows (partition pruning).

==== Spatial Option ====
The [[Spatial]] option store geographical information (GPS coordinates for instance) with records.

==== Real Application Clusters Option ====
[[Real Application Clusters]] (RAC) - formerly called Oracle Parallel Server (OPS) - allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems.

==== Advanced Security Option ====
Oracle [[Advanced Security]] (formerly Advanced Networking Option) provides a suite of security features to protect a company's network by providing network encryption, authentication solutions, single sign-on services, and support for other security protocols.

==== Oracle Label Security ====
Row level security based on stringent government and commercial requirements; sensitivity labels (i.e. confidential, doctor-patient only, top secret) provide better intellectual property protection and privacy.

==== Oracle OLAP ====
[[Oracle OLAP]] offers a complete set of analytical functions fully integrated within the database.

==== Oracle Data Mining ====
[[Oracle Data Mining]] offers embedded data mining for classifications, predictions, and associations to build advanced business intelligence applications.

==== Database Vault ====
A new option to Oracle Database 10g Release 2 Enterprise Edition that lets you control who, when, and where data and applications can be accessed, protecting against the most common security threat like malicious internal users.

----
----

=== Oracle Standard Edition ===
Four-processor version of Oracle Database 10g, including full clustering support (Real Application Clusters).

=== Oracle Standard Edition One ===
Two-processor version of Standard Edition at an attractive entry-level price. Real Application Clusters is NOT included with Oracle Database Standard Edition One.

=== Oracle Personal Edition ===
Full-featured version for individuals, compatible with the entire Oracle Database family (except Real Application Clusters).

=== Oracle Express Edition ===
[[Oracle XE]] is a free version of Oracle that is limited to 1 processor, 1 GB RAM and 4 GB of data. It is also limited to 1 database on a computer, since the database must be named XE which must be unique.

----
----

== Oracle Enterprise Manager ==
The following [[Enterprise Manager]] management packs are available. These packs must be separately licensed:

=== Oracle Configuration Management Pack ===
Track hardware and software configuration for hosts and databases plus cloning for database instances and Oracle home to facilitate deployments. Implement Policies, including Security checks and scoring.

=== Oracle Change Management Pack ===
Evaluate, plan for, and implement database schema changes to support new application requirements; eliminate errors/data loss when making changes; minimize downtime.

=== Oracle Diagnostics Pack ===
Ensure high availability of mission-critical business systems by reducing the number of complex performance tasks.

=== Oracle Tuning Pack (requires Diagnostics Pack) ===
Dynamic tuning recommendations for more-efficient resource utilization, higher transaction throughput, faster query performance; avoid costly hardware, memory, and disk upgrades.

----
----

== Oracle Internet Application Server ==
iAS ([[Internet Application Server]]) is Oracle's [[J2EE]]-based Application Server. iAS is divided into Infrastructure and Middle Tier components:

Infrastructure Components:
* Metadata Repository
* [[Oracle Internet Directory]] ([[OID]])
* Management Server
* Single Sign-On (SSO)
* Delegated Administration Services (DAS)

Middle Tier Components:
* [[OC4J]] and Webcache
* [[Oracle Portal|Portal]] and Wireless
* Business Intelligence and Forms (including [[Forms Server]] and [[Reports Server]])

== Oracle Developer Suite ==
The [[Oracle Developer Suite]] consists of the following products:

* [[Forms]] Developer
* [[Reports]] Developer
* [[JDeveloper]]
* [[Designer]]
* SCM (Software Configuration Manager)
* [[Discoverer]] Administrator
* [[Warehouse Builder]]
* Clickstream Intelligence Builder
* Business Intelligence Beans

== Oracle Collaboration Suite ==
Oracle [[Collaboration Suite]] ([[OCS]]) consists of components like:

* Oracle Mail
* Oracle Calendar
* Oracle Voicemail & Fax
* Oracle Mobile Access
* Oracle Discussions
* Oracle Web Conferencing
* Oracle Messenger
* Oracle Workspaces (managing team and project collaboration)
* Oracle Content Services (content management system)

== E-Business Suite (Oracle Applications) ==
Oracle Applications like Financials, HR, GL, CRM, etc:

* [[Oracle Financials]] - run by the accounting department

* [[Human Resources]] (HR) - run by the human resources department

* [[Manufacturing]] - helps to figure out what materials are needed to input to get a certain amount of product.

* [http://www.customwrittenpaper.com/ Custom Written Paper]

This also includes recently purchased solutions like [[PeopleSoft]], [[Baan]], etc.

== External links ==

* [http://www.oracle.com/us/products/database/options/overview/index.html Oracle Database 11g Options]

[[Category:Oracle Corporation]]

Advanced Security

2013-05-11T06:20:19Z

Michel Cadot: /* External links */

'''Oracle Advanced Security Option''' ([[ASO]]) is an [[Oracle database]] option used to safeguard sensitive data and address regulatory compliance requirements. ASO requires additional licenses and can only be used with Oracle Enterprise Edition.

==History==
ASO was first introduced with [[Oracle 8i]].

==Features offered==
Advanced Security offers the following features:
* Encryption
* End User Authentication
* Single Sign-on
* Secure Sockets Layer
* DCE Integration
* Security and Directory Integration

==External links==
* [http://www.oracle.com/technology/deploy/security/database-security/advanced-security/index.html Oracle's ASO page for Oracle 11g]
* [http://www.oracle.com/us/products/database/security/overview/index.html Oracle Database Security products]

[[Category:Database]]
[[Category:Database options]]

Advanced Security

2013-05-11T06:19:52Z

Michel Cadot: /* External links */

'''Oracle Advanced Security Option''' ([[ASO]]) is an [[Oracle database]] option used to safeguard sensitive data and address regulatory compliance requirements. ASO requires additional licenses and can only be used with Oracle Enterprise Edition.

==History==
ASO was first introduced with [[Oracle 8i]].

==Features offered==
Advanced Security offers the following features:
* Encryption
* End User Authentication
* Single Sign-on
* Secure Sockets Layer
* DCE Integration
* Security and Directory Integration

==External links==
* [http://www.oracle.com/technology/deploy/security/database-security/advanced-security/index.html Oracle's ASO page for Oracle 11g]
* [http://www.oracle.com/us/products/database/security/overview/index.html Oracle Database Security]

[[Category:Database]]
[[Category:Database options]]

Oracle Product Set

2013-05-11T06:18:40Z

Michel Cadot:

Oracle Corporation provides the following '''products''':

== Oracle Database Server ==
The [[Oracle database]] server is available in the following editions:

=== Oracle Enterprise Edition ===
Oracle's top-end database server product.

The following optional database options can be purchased separately. These options are only available with the Enterprise Edition:

==== Partitioning Option ====
The [[partitioning]] option allows DBAs to split large tables into more manageable sub-tables (partitions). Some of the advantages offered:
* Partitions can be stored in different tablespaces;
* Partitions can be added/ removed while users are working;
* Data can be selected from targeted partitioned without having to scan all partitions for rows (partition pruning).

==== Spatial Option ====
The [[Spatial]] option store geographical information (GPS coordinates for instance) with records.

==== Real Application Clusters Option ====
[[Real Application Clusters]] (RAC) - formerly called Oracle Parallel Server (OPS) - allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems.

==== Advanced Security Option ====
Oracle [[Advanced Security]] (formerly Advanced Networking Option) provides a suite of security features to protect a company's network by providing network encryption, authentication solutions, single sign-on services, and support for other security protocols.

==== Oracle Label Security ====
Row level security based on stringent government and commercial requirements; sensitivity labels (i.e. confidential, doctor-patient only, top secret) provide better intellectual property protection and privacy.

==== Oracle OLAP ====
[[Oracle OLAP]] offers a complete set of analytical functions fully integrated within the database.

==== Oracle Data Mining ====
[[Oracle Data Mining]] offers embedded data mining for classifications, predictions, and associations to build advanced business intelligence applications.

==== Database Vault ====
A new option to Oracle Database 10g Release 2 Enterprise Edition that lets you control who, when, and where data and applications can be accessed, protecting against the most common security threat like malicious internal users.

----
----

=== Oracle Standard Edition ===
Four-processor version of Oracle Database 10g, including full clustering support (Real Application Clusters).

=== Oracle Standard Edition One ===
Two-processor version of Standard Edition at an attractive entry-level price. Real Application Clusters is NOT included with Oracle Database Standard Edition One.

=== Oracle Personal Edition ===
Full-featured version for individuals, compatible with the entire Oracle Database family (except Real Application Clusters).

=== Oracle Express Edition ===
[[Oracle XE]] is a free version of Oracle that is limited to 1 processor, 1 GB RAM and 4 GB of data. It is also limited to 1 database on a computer, since the database must be named XE which must be unique.

----
----

== Oracle Enterprise Manager ==
The following [[Enterprise Manager]] management packs are available. These packs must be separately licensed:

=== Oracle Configuration Management Pack ===
Track hardware and software configuration for hosts and databases plus cloning for database instances and Oracle home to facilitate deployments. Implement Policies, including Security checks and scoring.

=== Oracle Change Management Pack ===
Evaluate, plan for, and implement database schema changes to support new application requirements; eliminate errors/data loss when making changes; minimize downtime.

=== Oracle Diagnostics Pack ===
Ensure high availability of mission-critical business systems by reducing the number of complex performance tasks.

=== Oracle Tuning Pack (requires Diagnostics Pack) ===
Dynamic tuning recommendations for more-efficient resource utilization, higher transaction throughput, faster query performance; avoid costly hardware, memory, and disk upgrades.

----
----

== Oracle Internet Application Server ==
iAS ([[Internet Application Server]]) is Oracle's [[J2EE]]-based Application Server. iAS is divided into Infrastructure and Middle Tier components:

Infrastructure Components:
* Metadata Repository
* [[Oracle Internet Directory]] ([[OID]])
* Management Server
* Single Sign-On (SSO)
* Delegated Administration Services (DAS)

Middle Tier Components:
* [[OC4J]] and Webcache
* [[Oracle Portal|Portal]] and Wireless
* Business Intelligence and Forms (including [[Forms Server]] and [[Reports Server]])

== Oracle Developer Suite ==
The [[Oracle Developer Suite]] consists of the following products:

* [[Forms]] Developer
* [[Reports]] Developer
* [[JDeveloper]]
* [[Designer]]
* SCM (Software Configuration Manager)
* [[Discoverer]] Administrator
* [[Warehouse Builder]]
* Clickstream Intelligence Builder
* Business Intelligence Beans

== Oracle Collaboration Suite ==
Oracle [[Collaboration Suite]] ([[OCS]]) consists of components like:

* Oracle Mail
* Oracle Calendar
* Oracle Voicemail & Fax
* Oracle Mobile Access
* Oracle Discussions
* Oracle Web Conferencing
* Oracle Messenger
* Oracle Workspaces (managing team and project collaboration)
* Oracle Content Services (content management system)

== E-Business Suite (Oracle Applications) ==
Oracle Applications like Financials, HR, GL, CRM, etc:

* [[Oracle Financials]] - run by the accounting department

* [[Human Resources]] (HR) - run by the human resources department

* [[Manufacturing]] - helps to figure out what materials are needed to input to get a certain amount of product.

* [http://www.customwrittenpaper.com/ Custom Written Paper]

This also includes recently purchased solutions like [[PeopleSoft]], [[Baan]], etc.

== External links ==

[http://www.oracle.com/us/products/database/options/overview/index.html Oracle Database 11g Options]

[[Category:Oracle Corporation]]

Database Concepts and Architecture

2013-05-06T15:28:26Z

Michel Cadot: Reverted edits by 182.19.66.187 (talk) to last revision by Michel Cadot

== What is an Oracle Database? ==

A database is a collection of data. An Oracle database holds its data in a coordinated set of files stored on disk, including following types:

* [[Parameter File]]s - The Oracle Parameter File (PFILE or SPFILE) holds initialization parameters which indicate where the control files are, how memory is allocated, how logging is performed, and other characteristics of the Oracle instance.
* [[Control File]]s - The Control File stores information needed to verify that the database is consistent, including a list of all database files making up the instance and other important data.
* [[Redo Log]] Files - The Redo Log files store a sequence of entries describing all actions taken against the database. This data is used to recover a database in the event of instance failure.
* [[Data File]]s - The Data Files contain blocks of data which store database objects (''e.g.,'' tables, indexes, materialized views, etc.) in the database.
* [[Temp File]]s - The Temp files contains data used temporarily including intermediate results, sort results and so forth.

Data and Temp files are grouped into tablespaces (see definition below).

--------

== What is an Instance? ==

An instance is a collection of Oracle background processes and shared memory structures.

=== Memory Areas ===

* [[SGA]] - System Global Area

: The SGA consists of the following four (five if MTS) parts:
:* Fixed Portion
:* Variable Portion
:* Shared pool
:* java pool

* [[PGA]] - Process Global Area

* [[UGA]] - User Global Area

=== Processes ===
Oracle uses many small (focused) processes to manage and control the Oracle instance. This allows for optimum execution on multi-processor systems using multi-core and multi-threaded technology. Some of these processes include:
* [[PMON]] - Process Monitor
* [[SMON]] - System Monitor
* [[ARCH|ARCn]] - Redo Log Archiver
* [[LGWR]] - Redo Log Writer
* [[DBWR|DBWn]] - Database Writer
* [[CKPT]] - Checkpoint process
* [[RECO]] - Recoverer
* CJQn - Job Queue Coordinator
* QMNn - Queue-monitor processes
* Dnnn - Dispatcher Processes (multiplex server-processes on behalf of users)
* Snnn - Shared server processes (serve client-requests)
* [[MMAN]] - Memory Manager process which will help in automatic memory management when use sga_target,memory_target
* LSP0 - Logical standby coordinator process (controls Data Guard log-application)
* MRP - Media-recovery process (detached recovery-server process)
* [[MMON]] - This is the process which will write to AWR base tables ie WR$ tables
* [[MMNL]] - Memory monitor light (gathers and stores [[AWR]] statistics)
* PSP0 - Process-spawner (spawns Oracle processes)
* RFS - Remote file server process (archive to a remote site)
* DBRM - [[Database Resource Manager|DB resource manager]] (new in [[Oracle 11g|11g]])
* DIAGn - Diagnosability process (new in [[Oracle 11g|11g]])
* FBDA - [[Flashback]] data archiver process (new in [[Oracle 11g|11g]])
* VKTM - Virtual Timekeeper (new in [[Oracle 11g|11g]])
* Wnnn - Space Management Co-ordination process (new in [[Oracle 11g|11g]])
* SMCn - Space Manager process (new in [[Oracle 11g|11g]])

An instance can mount and open one and only one database.

A database can normally only be mounted and opened by one instance. However, when using [[Real Application Clusters]] ([[RAC]]) a database can be mounted and opened by many instances.

== What's the relationship between database and instance? ==

* An instance can mount and open one and only one database.
* Normally a database is mounted and opened by one instance.
* When using [[Real Application Clusters|RAC]], a database may be mounted and opened many instances.

== Tablespaces ==

Disk space needs to be allocated for certain database objects (like tables and indexs). In Oracle, disk space from the operating system is allocated to [[tablespace]]s. Database objects are then created within a tablespace.

To list all tablespaces:

SELECT tablespace_name FROM dba_tablespaces;

Commands used to create new tablespaces:

CREATE TABLESPACE ts1 DATAFILE '/u01/oradata/orcl_ts1_01.dbf' SIZE 100M;

CREATE UNDO TABLESPACE undots1 DATAFILE '/u01/oradata/orcl_undots1_01.dbf' SIZE 100M;

CREATE TEMPORARY TABLESPACE temp1 TEMPFILE '/u01/oradata/orcl_temp1_01.dbf' SIZE 100M;

== Database Users ==

A database consists of multiple users that one can connect to. Each user has its own namespaces - objects within it cannot share the same name.

To list all the database users:

SELECT username FROM dba_users;

To create a new user:

CREATE USER scott IDENTIFIED BY tiger;

== Schema Objects ==
Schema objects are created within a [[schema]] (Oracle user). Here are some of the object types that can be created:

* [[Table]] (heap, IOT, temporary, etc.)
* [[Index]]
* [[View]]
* [[Materialized View]] (snapshot)
* [[Sequence]]
* [[Synonym]]
* [[Cluster]]
* [[Trigger]]
* [[Procedure]]
* [[Function]]
* [[Package]] (containing procedures and functions)
Etc.

[[Category:Database]]

File:MyPosts.JPG

2013-05-05T09:53:53Z

Michel Cadot: Michel Cadot uploaded a new version of "File:MyPosts.JPG"

Decode

2013-05-01T13:46:54Z

Michel Cadot: Reverted edits by 202.63.127.18 (talk) to last revision by Malloc

'''DECODE''' is a [[SQL]] function that provides similar functionality to an IF-THEN-ELSE or [[Case]] statement.

== Syntax ==
The syntax for the decode function is:

decode(expression, search, result [,search, result]...[,default] )

* expression is the value to compare
* search is the value that is compared against expression
* result is the value returned, if expression is equal to search
* default is optional. If no matches are found, the decode will return default. If default is omitted, then the decode statement will return [[NULL]] (no matches found).

== Examples ==
Decoding code values:
SELECT decode(sex, 'M', 'Male', 'F', 'Female', 'Unknown')
FROM employees;

SELECT DECODE(day#, 1, 'Monday',
2, 'Tuesday',
3, 'Wednesday',
4, 'Thursday',
5, 'Friday',
6, 'Saturday',
7, 'Sunday',
'Invalid day')
FROM tableX;

Comparing values:
SELECT a, b, decode( abs(a-b), 0, 'a = b',
a-b, 'a > b',
'a < b')
FROM tableX;

Aggregating values:
SELECT dept, sum( decode(sex,'M',1,0)) MALE,
sum( decode(sex,'F',1,0)) FEMALE,
count( decode(sex,'M',1,'F',1) ) TOTAL
FROM my_emp_table
GROUP BY dept;

==Decode and NULL==
As a rule, comparison to [[NULL]] should always return NULL. However, DECODE is an exception as it evaluates NULL == NULL:

SQL> SELECT decode(null,null,1,0) FROM dual;
DECODE(NULL,NULL,1,0)
---------------------
1

==Also see==
* [[Case]]

[[Category:SQL functions]]

Fun stuff

2013-04-30T15:52:50Z

Michel Cadot:

"Anyone without a sense of humor is at the mercy of the rest of us!"

== Funny SQL statements ==

Some funny [[SQL]] Statements we've encountered:

SELECT standard_disclaimer, witty_remark FROM company_requirements;

SELECT standard_disclaimer FROM company_stuff WHERE meaningful_content = 'NONE';

SELECT * FROM management WHERE clue > 0;

SELECT * FROM clients WHERE clue > 0;

SELECT * FROM users WHERE clue > 0;

SELECT * FROM genepool WHERE clue > 0;

SELECT * FROM politicians WHERE clue > 0;

== Funny error messages ==

SQL> select intelligence_level from developer;
select intelligence_level from developer
*
ERROR at line 1:
ORA-00904: "INTELLIGENCE_LEVEL": invalid identifier

SQL> select count(*) from developer_brain;
select count(*) from developer_brain
*
ERROR at line 1:
ORA-00942: table or view does not exist

== Yesterday: A DBA's backup song ==
YESTERDAY (to be sung to the tune of the Beatles' song - Yesterday):

<pre>Yesterday,
All those backups seemed a waste of pay
Now my database has gone away

Oh I believe in yesterday

Suddenly,
There's not half the files there used to be
And there's a deadline
hanging over me
The system crashed so suddenly.

I pushed something wrong
What it was I could not say

Now my data's gone
and I long for yesterday-ay-ay-ay.

Yesterday,
The need for back-ups seemed so far away.
Thought all my data was here to stay,
Now I believe in yesterday.</pre>

Here is a Youtube [http://www.youtube.com/watch?v=bdCjaiXmUb0 video] of the song.

== Genesis of a DBA Universe ==

: In the beginning was the disk array, and all was empty
: and raw, and [[Unix]] moved over the face of the platters.
: And the [[DBA]] said: Let there be [[Oracle]]. And there was
: Oracle. And the environmental variables were set and
: the disks were striped and mirrored and the [[OFA]] was
: established, and behold spindle was rent asunder from
: spindle. And the DBA saw that all was in spec.

: And it was day and it was evening of the first day.

: And the DBA said: Let there be scripts. And sql.bsq
: brought forth myriad crawling things upon the face of
: the array. And catalog.sql brought forth all manner of
: tables and views that swim unseen beneath the waters.
: And catproc.sql brought forth all the built-in
: programs and all the hosts of the air, that the users
: might be given wings and take fight over the data.

: And it was day and it was evening of the second day.

: And the DBA said: Let there be [[tablespace]]s. And there
: were tablespaces. And the network administrator looked
: upon the disk array and did see what the tablespaces
: had wrought upon the disk arrays, and he did gnash his
: teeth and seek a new work upon the Internet with an
: engine of search.

: And it was day and it was evening of the third day.

: And the DBA created users. Male and female he created
: them. And he said unto the users: Thou mayest create
: tables and views as thou wilt. Yea, though mayest
: create even indexes upon the data. Only meddle not
: with the system tablespace, for it is a holy place,
: and on the day wherein thou treadest upon it, on that
: day thy create session shall surely be revoked. And
: the serpent crept among the users and whispered to
: them, saying: Thine roles shall not be revoked. Taste
: ye all of the system tablespace, for ye shall know of
: b-trees and hints and ye shall be as DBAs. And the
: users heeded the serpent and filled the system
: tablespace with crap. And the instance did crash and
: the client did wax wroth at the DBA. And the DBA did
: gnash his teeth and partake of the fruit of the vine,
: for behold the users were permanent employees and the
: DBA was but a contractor and could not revoke their
: create session.

: And it was day and it was evening of the fourth day.

: And the DBA did set default tablespaces and temporary
: tablespaces and did lock down all that was upon the
: face of the array with roles and profiles and all
: manner of quotas, yea even from the rollback segments
: even unto the archived redo logs.

: And it was day and it was evening of the fifth day.

: And the DBA created synonyms and links and did tune
: the server and apply patches upon the face of the
: database.

: And it was day and it was evening of the sixth day.

: And on the seventh day the DBA did rest from all the
: labors of the creation. And his pager did ring and he
: ceased from resting and did spend his sabbath on the
: telephone with Oracle support. And by the time the DBA
: got through to someone who knew whereof they spake
: behold it was day and it was evening of the eighth
: day.

: And the DBA waxed wroth.

== Some of Oracle's real life messages ==

: Q. What if your Dad loses his car keys?
: A. 'Parent keys not found!'

: Q. What if your old girl friend spots you with your new one?
: A. 'Duplicate value on index!'

: Q. What if the golf ball doesn't get into the hole at all?
: A. 'Value larger than specified precision!'

: Q. What if you try to freak out with somebody else's girlfriend and being kicked out?
: A. 'Insufficient privileges on the specified object!'

: Q. What if you don't get any response from the girl next door?
: A. 'No data found!' or ' Query caused no rows retrieved!'

: Q. What if you get response from the girl next door and her Mom too?
: A. 'SELECT INTO returns too many rows!'

: Q. What if you dial a wrong number?
: A. 'Invalid number' or ' Object doesn't exist!'

: Q. What if you try to beat your own trumpet?
: A. 'Object is found mutating!'

: Q. What if you are too late to office and the boss catches you?
: A. 'Discrete transaction failed!'

: Q. What if you see 'theatre full' when you go to a movie?
: A. 'Maximum number of users exceeded!'

: Q. What if you don't get table in the lunch room?
: A. 'System out of tablespace!'

: Q. What if you need to go on a diet?
: A. Invalid Body Size

== 12 days of denormalization ==

On the first day of denormalization, my design gave to me
: a really fast-running query.

On the second day of denormalization, my design gave to me
: 2 less tables.

On the third day of denormalization, my design gave to me
: 3 more indexes.

On the fourth day of denormalization, my design gave to me
: 4 larger disks.

On the fifth day of denormalization, my design gave to me
: 5 brand new reqs.

On the sixth day of denormalization, my design gave to me
: 6 times the locking.

On the seventh day of denormalization, my design gave to me
: 7 longer updates.

On the eighth day of denormalization, my design gave to me
: 8 more requirements.

On the ninth day of denormalization, my design gave to me
: 9 invalid rows.

On the tenth day of denormalization, my design gave to me
: 10 delays deleting.

On the eleventh day of denormalization, my design gave to me
: 11 questionable queries.

On the twelfth day of denormalization, my design gave to me
: 12 lessons learned.

== All about toasters ==

If IBM made toasters...
* They would want one big toaster where people bring bread to be submitted for overnight toasting. IBM would claim a worldwide market for five, maybe six toasters.

If Oracle made toasters...
* They'd claim their toaster was compatible with all brands and styles of bread, but when you got it home you'd discover the Bagel Engine was still in development, the Croissant Extension was three years away, and that indeed the whole appliance was just blowing smoke.

If Sun made toasters...
* The toast would burn often, but you could get a really good cuppa Java.

Does DEC still make toasters?...
* They made good toasters in the '80s, didn't they?

And, of course: If Microsoft made toasters ...
* Every time you bought a loaf of bread, you would have to buy a toaster. You wouldn't have to take the toaster, but you'd still have to pay for it anyway. Toaster'98 would weigh 15000 pounds (hence requiring a reinforced steel countertop), draw enough electricity to power a small city, take up 95% of the space in your kitchen, would claim to be the first toaster that lets you control how light or dark you want your toast to be, and would secretly interrogate your other appliances to find out who made them. Everyone would hate Microsoft toasters, but nonetheless would buy them since most of the good bread only works with their toasters.

If Apple made toasters...
* It would be cute, inoffensive, and idiot proof. It would work as soon as you plugged it in. It would work with anyone's bread. It would take a long time to warm up. It would only have one slot - but you could upgrade. It would be expensive but never require servicing or opening the box. Other companies would say that it was too simple to make real toast but secretly fire their design teams and headhunt the ex-Apple employees. Religious wars would (re)start.

== Popular IT quotes ==

Some popular IT related quotes you can learn to impress your fellow office workers:

* ORACLE = One Real A$#h%le Called [[Larry Ellison]] (Only joking, obviously!!!)

* "The degree of normality in a database is inversely proportional to that of its DBA".

* Unix is a very user-friendly system. It's just picky about who it's friendly with.

* "I'm too sexy for my code" - Awk Sed Fred.

* Program complexity grows until it exceeds the capability of the programmer who must maintain it.

* "Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"

* "Technology is dominated by two types of people: those who understand what they do not manage, and those who manage what they do not understand."

* Users don't know what they really want, but they will know when they see it...

* Good, fast, cheap: pick two (you cannot have it all!)

* Proper Preparation Prevents Piss Poor Performance

* Keep It Simple Stupid (KISS)

* "Too many fingers on the keyboard" error....

* The problem is caused by UBF (User Brain Failure)

* PEBKAC: Problem Exists Between Keyboard And Chair

* CALM DOWN! It's Only 1's and 0's

* If you work on a program long enough, it will eventually send E-mail (a derivative of [http://www.catb.org/~esr/jargon/html/Z/Zawinskis-Law.html Zawinski's Law])

== Super DBA Rap Video ==
Check out how [http://www.youtube.com/watch?v=UZuZkhbNPjs Super DBA] uses SQL powers to save the day!

<pre>Super DBA by William Avery

CHORUS 1
Cooler than ice chillin' in refrigerators
I'm Super Database Administrator
Cooler than ice chillin' in refrigerators
I'm Sup... Super DBA

I was walking in the park. Saw a cat up a tree
"Please, Super DBA. You got to help me"
I looked up. The cat started falling down.
I had to think quick before it hit the ground.
UPDATE park SET ground='cotton candy';
COMMIT;
The cat landed and everything was dandy.
The lady said, "Thanks" and the kids had fun.
Free cotton candy for everyone

CHORUS 2
I'm Super Super DBA
Using SQL powers to save the day
RMAN's got my back night and day
I fast commit transactions with no delay

Hackers get back. No getting in my system
Got powerful password packet encryption
I roll like a stone. Walk like an Egyptian
Anything WACK - not in my description
I can undo the past. Flash you back to the present
You got to give me space. Time is of the essence
Forever growing. Knowledge flowing
If I select one record, you can't handle what I'm showing.

(CHORUS 1)

My DBA phone was ringing early in the morning
It was an ORA- critical. I had to get going
To the DBA Mobile. Riding really fast.
Putt, putt... Running out of gas.
INSERT INTO car (tank) VALUES ('fuel');
COMMIT;
Vroom. Cruising down the avenue.
UPDATE traffic_light SET color='green';
COMMIT;
Like that, I was there on the scene.

I came in the door. I saw this before.
It was a party but nobody was dancing on the floor.
To make the people move. Get into the groove
I grabbed the microphone went Check 1, 2
SELECT hip FROM hop; SELECT dont FROM stop;
SELECT a_little_funk FROM the_planet_rock;
SELECT cool FROM jazz WHERE the_beat='pizzazz';
SELECT the_best FROM anything_you_ever_had;

All is good and the case is closed.
Up to the cloud away I go...
I got RACs on RACs to data guard your back
Scaling through the grid stopping any attack

(CHORUS 2)
(CHORUS 1) </pre>

Here is a Youtube [http://www.youtube.com/watch?v=UZuZkhbNPjs video] of the song Super DBA.
----

== Other fun pages on the Net ==

Links To Some non-Oracle Laughs on the Internet:

* Dilbert Comics - http://www.unitedmedia.com/comics/dilbert/

* Omri's Computer Humor Page - http://www.cs.bgu.ac.il/~omri/humor/

* User Friendly: The Comic Strip - http://www.userfriendly.org/

* Do you have a difficult problem that nobody can answer? Ask the Oracle at http://www.cs.indiana.edu/~oracle/

[[Category:Top level]]

Freeware

2013-04-30T12:28:14Z

Michel Cadot: /* TSHSQL - PL/SQL Editor and SQL Query Tool */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module. 
Latest version: 1.0.18 (2012-05-14)

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. 
Latest version: 3.2.2 (2012-11-01)

==[http://sqltools.net/index.html?frame=http%3A//sqltools.net/news.html SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus. 
Latest version: 1.6b15 (2011-12-26)

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses. 
Latest version: v04.02.04 (2007)

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support). 
Latest version: v112 (2005-03-10)

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T12:26:52Z

Michel Cadot: /* The DDL Extract Wizard */

Freeware

2013-04-30T12:21:59Z

Michel Cadot: /* SQLTools */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module. 
Latest version: 1.0.18 (2012-05-14)

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. 
Latest version: 3.2.2 (2012-11-01)

==[http://sqltools.net/index.html?frame=http%3A//sqltools.net/news.html SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus. 
Latest version: 1.6b15 (2011-12-26)

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T12:20:39Z

Michel Cadot: /* SQLTools */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module. 
Latest version: 1.0.18 (2012-05-14)

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. 
Latest version: 3.2.2 (2012-11-01)

==[http://sqltools.net/index.html?frame=http%3A//sqltools.net/news.html SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus. 
Latest version: 1.5 RC1 Build 22 (2011-10-03)

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T12:17:57Z

Michel Cadot: No more free

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module. 
Latest version: 1.0.18 (2012-05-14)

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. 
Latest version: 3.2.2 (2012-11-01)

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T12:16:47Z

Michel Cadot: /* SQL Developer */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module. 
Latest version: 1.0.18 (2012-05-14)

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. 
Latest version: 3.2.2 (2012-11-01)

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T12:14:31Z

Michel Cadot: No more free

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module. 
Latest version: 1.0.18 (2012-05-14)

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T12:12:56Z

Michel Cadot: /* Silver Sash free */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module. 
Latest version: 1.0.18 (2012-05-14)

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T11:59:51Z

Michel Cadot: No more exists

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T11:57:43Z

Michel Cadot: /* SchemaSpy */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T11:57:32Z

Michel Cadot: /* SchemaSpy */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source 
Latest version: 5.0.0 (2010-08-16)
[http://www.joachim-uhl.de/projekte/schemaspygui/ Graphical version]: 0.99 (2009-02-21)

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T11:53:33Z

Michel Cadot: /* Schema graphical editor */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Latest version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T11:49:52Z

Michel Cadot: /* Schema graphical editor */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc. 
Last version: 2003-05-19

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T09:27:25Z

Michel Cadot: No more free

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T09:26:11Z

Michel Cadot: /* DBAShell */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2006-07-11)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T09:25:11Z

Michel Cadot: /* Pretoria */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. 
Latest version: 3c (2008-04-28)

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T09:18:59Z

Michel Cadot: /* OraSnap (Oracle Snapshot) */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser. 
Latest version: 2008-01-14

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T09:16:59Z

Michel Cadot: /* OraSentry */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files. 
Latest version: 5.1 (2010-SEP)

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T09:14:05Z

Michel Cadot: No more exists

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:29:45Z

Michel Cadot: No more exists

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:27:34Z

Michel Cadot: /* Odat, free Oracle Admin Tool */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click. 
Latest version: 2005-09-29

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:22:33Z

Michel Cadot: /* MyOra */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. 
Latest version: 3.5 (2011-07-11)

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:20:35Z

Michel Cadot: /* MyGeneration Development Tool */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free 
Latest version: 1.3.1 (2011-01-02)

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:18:05Z

Michel Cadot: /* Jailer */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships. 
Latest version: 4.0.14 (2012-09-16)

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:16:15Z

Michel Cadot: Change URL

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:13:24Z

Michel Cadot: /* HammerOra */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain. 
Latest version: 2.13 (2012-DEC)

==[http://www.orafaq.com/utilities/sqlformatter.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:10:58Z

Michel Cadot: No more exists

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.

==[http://www.orafaq.com/utilities/sqlformatter.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:06:43Z

Michel Cadot: /* DBAShell */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 0.85 (2013-04-18)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://www.bahrenburgs.com/GoldFishNet Gold Fish.Net]==
Gold Fish.Net is a Charityware tool with such features as schema browser, storage manager, and export module. Through an easy to use interface you can edit, modify, create and drop most database objects.

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.

==[http://www.orafaq.com/utilities/sqlformatter.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:06:05Z

Michel Cadot: /* Free PLSQL Editor/Compiler/Object Viewer */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 1.6 (2011-12-25)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above. 
Latest version: 1.6 (2011-12-25)

==[http://www.bahrenburgs.com/GoldFishNet Gold Fish.Net]==
Gold Fish.Net is a Charityware tool with such features as schema browser, storage manager, and export module. Through an easy to use interface you can edit, modify, create and drop most database objects.

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.

==[http://www.orafaq.com/utilities/sqlformatter.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:05:02Z

Michel Cadot: /* DBAShell */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc. 
Latest version: 1.6 (2011-12-25)

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above.

==[http://www.bahrenburgs.com/GoldFishNet Gold Fish.Net]==
Gold Fish.Net is a Charityware tool with such features as schema browser, storage manager, and export module. Through an easy to use interface you can edit, modify, create and drop most database objects.

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.

==[http://www.orafaq.com/utilities/sqlformatter.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T08:04:27Z

Michel Cadot: /* DBeauty */

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator. 
Latest version: 2.0.11 (2012-09-16)

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc.

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above.

==[http://www.bahrenburgs.com/GoldFishNet Gold Fish.Net]==
Gold Fish.Net is a Charityware tool with such features as schema browser, storage manager, and export module. Through an easy to use interface you can edit, modify, create and drop most database objects.

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.

==[http://www.orafaq.com/utilities/sqlformatter.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T07:59:24Z

Michel Cadot: No more free

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator.

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc.

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above.

==[http://www.bahrenburgs.com/GoldFishNet Gold Fish.Net]==
Gold Fish.Net is a Charityware tool with such features as schema browser, storage manager, and export module. Through an easy to use interface you can edit, modify, create and drop most database objects.

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.

==[http://www.orafaq.com/utilities/sqlformatter.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__

Freeware

2013-04-30T07:58:27Z

Michel Cadot: No more free

List of '''Oracle Freeware''' products available in alphabetical order:

{{Note|Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.}}

==[http://www.lv2000.com/sendmail.htm CmdEmail]==
There is a simple and effective way to send email through oracle form, using the command line send mail component -- CmdEmail.

CmdEmail is a command line e-mail component, it can be integrated into your application developed by Oracle Form Builder, VC, VB, Perl etc.

==[http://dbeauty.sourceforge.net/ DBeauty]==
A relationship-oriented Database Browser.
Provides insight into both the data and the interrelation of the rows.
Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
Automatic detection of foreign keys.
SQL/DML generator.

==[http://sourceforge.net/projects/dbashell/ DBAShell]==
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc.

==[http://www.sqltools.net/ Free PLSQL Editor/Compiler/Object Viewer]==
I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above.

==[http://www.bahrenburgs.com/GoldFishNet Gold Fish.Net]==
Gold Fish.Net is a Charityware tool with such features as schema browser, storage manager, and export module. Through an easy to use interface you can edit, modify, create and drop most database objects.

==[http://hammerora.sourceforge.net/ HammerOra]==
Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.

==[http://www.orafaq.com/utilities/sqlformatter.htm Instant SQL Formatter]==
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.

==[http://jailer.sourceforge.net/ Jailer]==
Database Subsetting and Data Browsing tool.
Exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. Generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Since Release 3.6 it is also possible to browse a database based on relationships.

==[http://www.mygenerationsoftware.com/ MyGeneration Development Tool]==
MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

==[http://www.myorasql.com MyOra]==
MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time.

==[http://mysite.verizon.net/vze2n2ja/ Odat, free Oracle Admin Tool]==
Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

==[http://membres.lycos.fr/pmscontact/ Oracle Tool]==
OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

==[http://www.dkgas.com/oraedit.htm OraEdit]==
A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

==[http://www.orasentry.com/ OraSentry]==
OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

==[http://www.oracle-books.com/orasnap OraSnap (Oracle Snapshot)]==
OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

==[http://sourceforge.net/projects/pretoria/ Pretoria]==
Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

==[http://www.QueryAdvisor.com/ QueryAdvisor]==
QueryAdvisor can analyze thousands of Oracle event 10046 tracefiles from one or several Oracle single instance or RAC databases in parallel. A GUI based repository with drilldowns from SQL statements to bind variables and references to the location in the original trace file is build for further analysis. Free public and registered licenses are available.

==[http://home.zonnet.nl/r.vermeer/rrdora RRDORA]==
Trendanalysis on Oracle database with RRDTool.

==[http://db-org.sourceforge.net/ Schema graphical editor]==
Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

==[http://schemaspy.sourceforge.net/ SchemaSpy] ==
Simple command line tool which generates HTML reports of oracle DB schema, including [[UML]] diagrams showing relationships. A little fiddly to set up. Free & Open Source

==[http://www.cobblesoft.com/schemasurf SchemaSurf]==
SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

==[http://www.silversash.com/ Silver Sash free]==
Silver Sash has two free products. Silver Sash Developer,which is a complete SQL and PL/SQL Editor and an Administrator.
Silver Sash Administrator which has everything Silver Sash Developer has plus a monitoring module.

==[http://www.softtreetech.com/isql.htm SoftTree SQL Assistant]==
SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

==[[SQL Developer]]==
Oracle [[SQL Developer]] is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

==[http://www.sqlinform.com/ SQLinForm]==
SQLinForm is an automatic online SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options. Downloaded version is no longer freeware.

==[http://sourceforge.net/projects/sqlt SQLTools]==
SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

==[http://www.DDLWizard.com The DDL Extract Wizard]==
The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

==[http://www.oracle-base.com/misc/TSHSQL.php TSHSQL - PL/SQL Editor and SQL Query Tool]==
TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).

[[Category:Third-party products]]
__NOTOC__