How to Escape Characters in Oracle PL/SQL Queries

Oracle databases reserve some special characters with specific meaning and purpose within Oracle environment. These reserved characters include _ (underscore) wild card character which used to match exactly one character, % (percentage) which used to match zero or more occurrences of any characters and ‘ (apostrophe or quotation mark) which used to mark the value supplied. These special characters will not be interpreted literally when […]

Read Me 3 Comments

Adobe Apollo Alpha Free Download

Adobe Systems has released Adobe Apollo alpha version for sneak peak and free download from Adobe Labs. Apollo is the code name for a cross-operating system runtime technology that allows rich Internet application to port and run offline, and thus allows developers to leverage their existing web development skills on Adobe (Macromedia) Flash, Flex, HTML, JavaScript, Ajax and etc to build and deploy rich Internet […]

Read Me Leave comment

Easily Duplicate, Copy or Backup Tables in Oracle, PostgreSQL, DB2 and SQLite with Create Table As SQL

In Oracle, PostgreSQL, DB2 and SQLite database system, there is a nice command feature called Create Table As which allows easy duplicating of a table with data from another or a few other tables. The SQL command can also be used to ‘copy and paste’ a table exactly or backup a table data before performing data manipulation query on the original table, just in case […]

Read Me 8 Comments

Change or Set MySQL Long Query Time Value for log-slow-queries

If you enable slow queries log of MySQL database server, you will notice that from the slow query log file contains only SQL statements and queries that took more than query_time of 10 seconds to execute or run. This is the default value or query time threshold for log_slow_queries function, which is 10 seconds. 10 seconds is way too long for a SQL query to […]

Read Me 1 Comment

Enable Logging of Slow Queries (Slow Query Log) in MySQL Database

One of the main requirements for a fast web server is to has efficient and effective SQL statements or queries that are optimized. Any non-optimal SQL (Structured Query Language) commands or statements that take too long or lengthy time to execute will use up a lot of system resources, causing MySQL database to run slower, and then more and more queries backlogs queuing up, and […]

Read Me 7 Comments

Delete, Remove or Drop Oracle Stored Packages with Drop Package

Oracle Package is an object in Oracle database that allows developers and designers to group procedures and functions into common groups, typically based upon their functionality. Package can be treated as the container for functions and procedures. A package consists of two sections which is the package specification (export script file will be in .pks extension) which must be declared first and contains a definition […]

Read Me Leave comment

ORA-00942 Table or View Does Not Exist Oracle Error

Sometime when you compile an object or package or view in Oracle, or execute some PL/SQL statements on Oracle table, or when running an Oracle program or application, the following error my occurs: ORA-00942: table or view does not exist

Read Me 5 Comments

Oracle JDeveloper Reviews

Oracle JDeveloper is a free Java IDE or integrated development environment from Oracle that offers features for development in Java, XML, SQL and PL/SQL, HTML, JavaScript, BPEL, PHP, and more. JDeveloper provides covers the end-to-end full development lifecycle from modeling, designing, developing, coding, debugging, optimization and profiling to deploying Java application and web services. Full features of Oracle JDeveloper, Oracle’s Java/J2EE Workbench for Oracle 10g […]

Read Me Leave comment

Microsoft Robotics Studio Free Download for Programming Robots

Robots addicts, enthusiasts, hobbyists, educators or students now have a good news, in a way that Microsoft has released Windows-based, robotic-platform-agnostic Microsoft Robotics Studio (MRS) CTP (community technical preview) November 2006 for free download. Microsoft Robotics Studio offers visual, services-based platform for programming robots or create robotics applications in the real and virtual world, and intends to be software platform for the robotics community that […]

Read Me 16 Comments

XNA Game Studio Express 1.0 Officially Released for Free Download

Microsoft has released XNA Game Studio Express and the XNA Framework out of beta as version 1.0, a games development tool designed to let game developers, designers and hobbyists to easily create and develop video games for Windows and Xbox 360 gaming platform using new and optimized XNA Framework, a set of managed code development cross-platform gaming libraries based on Visual C# Express 2005. XNA […]

Read Me 3 Comments

Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error

When inserting records into Oracle database by SQL statements, creating new tables, importing backup dump into Oracle database or when manipulating tables or data in the Oracle database, the following error may occurs: ORA-01658: unable to create INITIAL extent for segment in tablespace tablespace_name

Read Me 1 Comment

Free Download – Browse and Edit XML Documents Easily with XML Notepad 2007

XML Notepad 2007 is a free application from Microsoft that provides a more user friendly and intuitive user interface (GUI) for reading, browsing, editing, modifying or manipulating XML source files by developers or users. XML Notepad 2007 supports Windows Server 2003, Windows XP and Windows Vista operating systems and requires Microsoft .NET Frameworks v2.0. Among the features of XML Notepad 2007 are:

Read Me Leave comment