Join Clause Snippets

18 January, 2012   

You can combine with SQL JOIN clause to show department name with count.

07 January, 2016   

The INNER JOIN keyword return rows when there is at least one match in both tables.

18 January, 2012   

SQL GROUP BY Clause returns group of rows. An example code for SQL GROUP BY clause

20 February, 2012   

SQL select query to show records with specify date in where clause

07 September, 2014   

The "WITH CHECK OPTION" is used to indicate that Oracle will prevent any changes to the table or view that would produce rows that are not included in the subquery. When used in the subquery of a DML statement, you can specify this clause in a subquery in the FROM clause but not in subquery in the WHERE clause.

07 August, 2014   

All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted.

04 January, 2012   

SQL example Code for SELECT statement with HAVING clause

13 March, 2012   

PL/SQL code example Using the HAVING Clause

SQL code example to delete WordPress post revision from DB

20 February, 2012   

SQL select query with between date to show records in where clause

PL/SQL code example for using the MAX function with having clause

02 November, 2014   

The RETURNING clause was implemented as part of the Oracle 10g release and is used to return information about the effected rows after issuing Data Manipulation Language (DML) statements.

11 October, 2011   

In the same way you often need to format data being sent from Flash, you sometimes need to format data being received. This function takes a string and removes all spaces from it. Here we use the split method of the String class to split the string into an Array and then call the join method of the Array class to convert it back to a string....

If we wanted to select only certain entries of our table, then we would use the WHERE clause .

29 March, 2015   

When creating an index, the default method Oracle uses to sort the index is in ascending order (SORT). However, if the rows are already stored in the database in ascending order you can use the NOSORT clause to skip the sorting process. If neither SORT or NOSORT is provided, Oracle will use SORT as the clause.

18 August, 2011   

The example Python code to Rotate sequences left or right

MS SQL triggers for automatic Create and LastModified Dates

28 June, 2014   

Starting in Oracle 9i, you can use the case statement within an SQL statement. It has the functionality of an IF-THEN-ELSE statement.

23 March, 2016   

Get contents of table where the item does NOT exist in another table.

19 February, 2012   

Throwtest an application that demonstrates how to define, throw, and handle exceptions. This application doesn't do anything other than print out some text, but if you might want to study it and play around with it to learn more about how exceptions work in Java. See the usage instructions in the source code.