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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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
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 […]
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 […]
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 […]
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
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:
Tip and Trick