connection usage

11:37 PM
  public void createTable() throws SQLException {     String createString =       "create table COFFEES " + "(COF_NAME varcha...

Advanced SQL Queries

11:10 PM
For Tables Defined in : http://dbms101.blogspot.com/2012/01/tutorial-db.html 1. Get list of customers who have not placed an order yet. SQL...

SQL Debugging

12:06 PM
1. Problem When using a GROUP BY clause every field in the SELECT list must be either: One of the GROUP BY terms - in this example custom...

Temporary Tablespace

11:30 AM
TEMPORARY Tablespaces and TEMPFILES REFERENCE :  http://www.orafaq.com/node/2 What are Temporary Tablespaces: Temporary tablespaces are...

DUAL Table in Oracle

11:01 PM
DUAL Details : http://en.wikipedia.org/wiki/DUAL_table SELECT 1 + 1 FROM DUAL; SELECT SYSDATE FROM DUAL; SELECT USER FROM DUAL...
Subscribe to: Posts ( Atom )
Powered by Blogger.