MySQL RAND() returns a random floating-point value between the range 0 to 1. When a fixed integer value is passed as an argument, the value is treated as a seed value and as a result, a repeatable sequence of column values will be returned.

Another 10 PostgreSQL string functions have discussed with syntax and example in this page.

The PostgreSQL string functions can be used for manipulating and examining various type of queries independently or within a table. Here is the list of operator and 10 string functions bellow.

MySQL CONCAT() function is used to add two or more strings. It will return non-binary strings when all the strings are non-binary and return binary string when any of the specified string is binary. A numeric argument is also converted in its equivalent binary string form. It can be avoided by using

In this page we have discussed an advanced usage of MySQL LEFT JOIN.

MySQL tutorial of w3resource is a comprhensive tutorial to learn MySQL. We have hundreds of examples covered, often with PHP code. This helps you to learn how to create PHP-MySQL based web applications.

In this tutorial we will create a simple 5 star rating system using jQuery, MySQL, PHP and AJAX. We will use jQuery to highlight the star the mouse is over and the preceding stars, AJAX to send the vote to the server, PHP to process the vote and MySQL to store the vote.

In this tutorial we'll see how to setup our own database using phpmyadmin and how to connect to it and use mysql queries to interact with it.

The chapter, "Maintaining Oracle Standards" discusses "standards" such as Oracle's Optimal Flexible Architecture, Unix shell scripting, code and configuration basics. The new 11g Automatic Diagnostic Repository features, for diagnosing and repairing certain types of failures, are also shown here

Best place for ORACLE and SQL learners. New to Oracle, or new to DBA tasks? Use these resources to get started with database technology and features, step by step.