Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 
Oracle
SQL Scripts Oracle 9i and 10g
Before you set up EA for use with Oracle, we recommend you run the Tools | Data Management | Data Integrity tool on the base project you wish to upsize to Oracle. This will ensure data is 'clean' before uploading.

Posted : Oct/25/2009   By: pankaj    Category: Oracle    Total Views :67   Vote Up: 0   Vote Down: 0

Database Modeling in UML
When it comes to providing reliable, flexible and efficient object persistence for software systems, today's designers and architects are faced with many choices. From the technological perspective, the choice is usually

Posted : Oct/25/2009    By: pankaj    Category: Oracle   Total Views :68   Vote Up: 0   Vote Down: 0

Oracle SQL Built-In Functions Character/String Functions
Oracle SQL Built-In Functions Character/String Functions Function Description Example

Posted : Oct/07/2009   By: pankaj    Category: Oracle    Total Views :110   Vote Up: 4   Vote Down: 0

Data Dictionary Tutorial
This document presents Oracle's data dictionary, also called the system catalogue. The data dictionary is the repository of all the meta-data relevant to the objects stored in the database-and also of information concern

Posted : Oct/07/2009    By: pankaj    Category: Oracle   Total Views :63   Vote Up: 0   Vote Down: 0

PL/SQL Tutorial
PL/SQL is a database-oriented programming language that extends Oracle SQL with procedural capabilities. We will review in this lab the fundamental features of the language and learn how to integrate it with SQL to help s

Posted : Oct/07/2009   By: pankaj    Category: Oracle    Total Views :56   Vote Up: 0   Vote Down: 0

Oracle SQL Tutorial
During this tutorial you will build on your databases knowledge by learning the fundamentals of Oracle, one of the most widely used database management system in industry.

Posted : Oct/07/2009    By: pankaj    Category: Oracle   Total Views :74   Vote Up: 0   Vote Down: 0

Oracle Database 10g Express Edition Tutorial
This tutorial prepares the Oracle Database 10g Express Edition Developer to perform common development and administrative tasks of Oracle Database 10g Express Edition. Learning Objectives After taking this tutorial, y

Posted : Oct/07/2009   By: pankaj    Category: Oracle    Total Views :67   Vote Up: 0   Vote Down: 0

Hierarchical Queries
Using the CONNECT BY and START WITH Clauses The syntax for the CONNECT BY and START WITH clauses of a SELECT statement is as follows: SELECT [LEVEL], column, expression, ... FROM table [WHERE where_clause] [[ST

Posted : Oct/07/2009    By: pankaj    Category: Oracle   Total Views :61   Vote Up: 1   Vote Down: 0

Writing Multiple Row Subqueries
A multiple row subquery returns one or more rows to the outer SQL statement. The outer query may use the IN, ANY, or ALL operator to handle a subquery that returns multiple rows.

Posted : Oct/07/2009   By: pankaj    Category: Oracle    Total Views :58   Vote Up: 0   Vote Down: 0

Writing Single Row Subqueries
A single row subquery is one that returns zero or one row to the outer SQL statement. You may place a subquery in a WHERE clause, a HAVING clause, or a FROM clause of a SELECT statement.

Posted : Oct/07/2009    By: pankaj    Category: Oracle   Total Views :64   Vote Up: 0   Vote Down: 0

« Previous12Next »
 
 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge