Many Oracle DBAs and developers use SQL*Plus for managing DB or developing program. It is very simple and has basic functions, but Prettykid has good GUI feautures with functions for DBA like DBA scripts, monitoring SGA. Each window manages SQL statements as history, so user can reuse his previous SQL easily. Many programs like prettykid does not support array processing. Though a table has many rows, the response time of query in prettykid is almost same. When user scrolls the resultset, automatically requery is executed for another resultset.

Prettykid has the following features.

• Syntax highlighting


• Multiple connections (MDI)


• Multiple windows per DB user


• Remembering SQL statements (30 per window)


• Saving as Excel file (csv format)


• Including DBA scripts


• Monitoring SGA


• Explain plan

• Running the SQL script file


• Executing stored procedures


• Additional server monitoring module with charts


• Reporting DBMS status everyday for DBA


• Including PL/SQL editor