Blogs about: Sql Reference
Featured Blog
The NEW Developer Resource Cheat Sheet! Tools and Resources
A very popular cheat sheet. Thanks to: cheat-sheet.org Web Development Cascading Style Sheets CSS – single page – available in pdf and png formats. CSS 1 – pdf – two pages. CSS… more →
HostedFTP.com - News
The NEW Developer Resource Cheat Sheet! Tools and Resources
hostedftp wrote 11 months ago: A very popular cheat sheet. Thanks to: cheat-sheet.org Web Development Cascading Style Sheets CSS … more →
Row Numbering and Ranking Functions
enginzorlu wrote 1 year ago: 1. ROWNUM without Analytic Function select employee_id, name , salary, ROWNUM from employees ORDER B … more →
Case expression in sql
enginzorlu wrote 2 years ago: We can use case expression in PL/SQL basically or as a sql expression to extend query flexibility. B … more →
Synonyms
enginzorlu wrote 2 years ago: When you reference an object in a SQL command that is owned by another user, you must preface the … more →
Indexes
enginzorlu wrote 2 years ago: A database index is a table that contains data values, along with a corresponding column that spec … more →
Database Views
enginzorlu wrote 2 years ago: A view does not physically exist in the database. It is derived from other database tables. W … more →
Selecting Records For Update
enginzorlu wrote 2 years ago: When you enter a SELECT command to query database records, no locks are placed on the selected … more →
Using Set Operators to Combine Query Results
enginzorlu wrote 2 years ago: Set Operator Purpose UNION Returns all rows from both queries, but displays duplicate rows only once … more →
Creating Nested Query
enginzorlu wrote 2 years ago: A nested query is created when a second query, called a subquery, is nested within a main query. T … more →
Joining Multiple Tables
enginzorlu wrote 2 years ago: The general syntax of a SELECT statement that joins two tables is : SELECT column1, column2, … FROM … more →
Oracle SQL Group Functions
enginzorlu wrote 2 years ago: Function Description Example Result AVG (fieldname) Returns the average value of a numeric column’s … more →
Using Calculations in Query
enginzorlu wrote 2 years ago: SELECT inv_id, item_size, color, price,qoh, price * qoh FROM inventory WHERE item_id = 897; SELECT s … more →
Sorting Query Output
enginzorlu wrote 2 years ago: ORDER BY columnname; If records are sorted in numerical column, it is ascending numerical sort. If r … more →
Search Operations
enginzorlu wrote 2 years ago: Using Search Conditions in SELECT Commands SELECT f_first, f_mi, f_last, FROM faculty WHERE f_rank = … more →
Retrieving Data From A Single Table
enginzorlu wrote 2 years ago: SELECT colun1, column2, …. FROM ownername.tablename WHERE search _condition; You can suppress … more →
Using Oracle Data Dictionary Views
enginzorlu wrote 2 years ago: The data dictionary views are divided into three general categories based on the user’s object privi … more →
Integrity Constraints
enginzorlu wrote 2 years ago: general syntax : CONSTRAINT constraint_name PRIMARY KEY CONSTRAINT constraint_name PRIMARY KEY ( fie … more →
Database Table Definitions And Data Types
enginzorlu wrote 2 years ago: Invalid SQL Table and FIELD Names Description STUDENT TABLE Spaces not permitted STUDENT-TABLE Hyphe … more →
Oracle System Privileges
enginzorlu wrote 2 years ago: Oracle System Privileges Privilege Level Purpose CREATE SESSION User Connecting to the Oracle databa … more →
