|
|
| Book details / order |
| INSTANT ORACLE |
This indispensable handy little book is a must have for programmers, database administrators and everyone working with oracle databases. it is a portable guide that addresses the language's complexity with an easy to follow format and numerous real world examples based on the most commonly used business database models.
it serves as a concise and quick reference to those who are stuck and need an answer quickly. it also helps those who just want to be sure that they are applying the sql syntax correctly.
inside, you'll find:
sql plus
data types
working with tables
data constraints
inserting, viewing, updating and deleting data
operators
character/string, numeric, date functions
grouping data
subqueries
joins
union, intersect and minus
this small and handy book conveniently stays in your back pocket or somewhere near your keyboard.
instant oracle efficiently condenses the details of its best selling companion book, oracle for professionals that delivers all of the basics and at the same time, serves those who want to harness the unexploited, overlooked power of oracle sql and pl/sql.
about the author
the author sharanam shah has 8+ years of it experience as a developer, database designer, technical writer, systems analyst and a lead architect. he currently consults with several software houses in mumbai, india, to help them design and manage database application.
--------------------------------------------------------------------------------------------------------------
1. about the oracle database
about the examples in this book
2. sql plus
3. data types
char(size)
varchar2(size)
date
timestamp
integer
number(p, s) / numeric(p, s)
decimal or dec
long
raw/long raw
binary_float
binary_double
nchar[(size)]
nvarchar2(size)
4. working with tables
creating table
creating temporary tables
creating a table from a table
destroying table
retrieving tables in the schema
describing table structures
viewing table information
altering table structures
adding new columns
drop a column
logically drop a column
modify existing columns
renaming tables
using alter table command
using rename command
renaming columns
5. data constraints
the unique key constraint
unique constraint-at column level
unique constraint-at table level
the primary key constraint
primary key-at column level
primary key-at table level
the foreign key constraint
foreign key-at column level
foreign key-at table level
constraints for data integrity
not null constraint
the check constraint
check constraint-at column level
check constraint-at table level
viewing defined constraints
the default constraint
6. inserting data
insert data in specific columns
copy data from another table
7. viewing data
viewing rows and columns
retrieve columns and rows
eliminating duplicate rows
data sorting
8. updating data
modifying all rows
9. deleting data
deleting all rows
deleting specific row(s)
truncating data in existing tables
10. operators
arithmetic operators
logical operators
comparison operators
equal to any member of
not equal to any member of
equal to any value
equal to every value
exists
test null values
the between operator
the like operator
operator precedence
11. character/string functions
12. numeric functions
13. date functions
14. grouping data
group by clause
having clause
15. subqueries
nested subqueries
16. joins
inner join
outer join
left outer join
right outer join
cross join
self join
non?equi join
17. union, intersect and minus
union clause
intersect clause
minus clause
Author : Sharanam shah
Publication : Spd
Isbn : 9789350230275
Store book number : 109
NRS 120.00
|
 |
|
|
|
|
|
|
|
| |
|
|
