Teach Yourself SQL/PL SQL Using Oracle 8i and 9i with SQLJ

Bayross, Ivan

Editore: BPB Publications, 2003
ISBN 10: 8176566918 / ISBN 13: 9788176566919
Usato / Quantità: 0
Copie del libro da altre librerie
Mostra tutte le  copie di questo libro

Libro

Purtroppo questa copia non è più disponibile. Di seguito ti proponiamo una lista di copie simili.

Descrizione:

Gently used. Expect delivery in 2-3 weeks. Codice inventario libreria

Su questo libro:

Book ratings provided by Goodreads):
3,82 valutazione media
(92 valutazioni)

Riassunto: The Book Has Been Written To Provide An Excellent Grounding To Those Who Wish To Learn Sql, Pl/Sql And Sqlj Using Oracle 8I Or 9I. Like All His Earlier Books This Book Also Has Several Illustrative Examples, Which Have A Logical Link Between Them.Each Set Of Examples Helps Build Skills That Will Take The Reader To The Next Set Of Examples, Which In Turn Leads Upwards Until A Strong Programming Foundation Using The Natural Language Of Oracle8I Or 9I Has Been Established.Each Topic Is Very Liberally Sprinkled With Examples That Are Mapped To Applications, Which Fit In The Real World.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Dati bibliografici

Titolo: Teach Yourself SQL/PL SQL Using Oracle 8i ...
Casa editrice: BPB Publications
Data di pubblicazione: 2003
Condizione libro: very good

I migliori risultati di ricerca su AbeBooks

1.

Ivan Bayross
Editore: BPB Publications (2010)
ISBN 10: 8176566918 ISBN 13: 9788176566919
Nuovi Softcover Prima edizione Quantità: > 20
Da
BookVistas
(New Delhi, DELHI, India)
Valutazione libreria
[?]

Descrizione libro BPB Publications, 2010. Softcover. Condizione libro: New. First edition. The book has been written to provide an excellent grounding to those who wish to Learn SQL, PL/SQL and SQLJ using Oracle 8i or 9i. Like all his earlier Books this book also has several illustrative examples, which have a logical link between them. Each set of examples helps build skills that will take the reader to the next set of examples, which in turn leads upwards until a strong Programming foundation using the Natural Language of Oracle 8i or 9i has been established. Each topic is very liberally sprinkled with examples that are mapped to applications, which fit in the real world. If a grounding in Java is required a Study of ?Web Enabled commercial Application Development Using Java 2.0? written by lvan Bayross is recommended. Contents Section A : SQL : I. Creating THE SQL Framework : The Oracle 81 Framework 1. Installation of Oracle 81 on Windows NT 2. Changing the Default Password for Sys 3. Activating/Deactivating the Oracle 81 Engine : i. Disabling Automatic Startup ii. Enabling A Service on Demand iii. Manually Enabling the Oracle 8i Services Under Win NT 4. Uninstalling Oracle 81 From Windows NT 5. Tablespaces in Oracle 81 : i. Logical Structures of The Database ii. The Oracle System Tablespace iii. Tablespace Usage iv, The Create Command for TABLESPACES v. Creating A Tablespace Using SQL *Plus 6. Creating Tablespace Through DBA Studio 7. Creating a DBA Login ID 8. Creating a User 9. Accessing Oracle 81 from a Remote Client : i. Creating A Connection To A Database From A Remote Client 10. Self Review Questions II. Setting up Interactive SQL *Plus Tool : 1. Invoking SQL *Plus 2. Creating a Desktop Shortcut to SQL *Plus : i. SQL Syntax or Command Based Attributes ii. Environment Related Attributes iii. Report Related Attributes iv. Printing Attributes v. Database Backup And Recovery Related Attributes vi. Miscellaneous Attributes 3. Working with the SQL *Plus ASCII Editor : i. Assigning A User Defined ASCII Editor For SQL *Plus ii. Saving The SQL Query To A User Defined File 4. Self Review Questions III. Interactive SQL Part I : 1. I Table Fundamentals : i. Oracle Data Types ii. The Create Table Command iii. Inserting Data Into Tables 2. Viewing Data in the Tables : i. All Rows Ana" All Columns 3. Filtering Table Data : i. Selected Columns and All Rows ii. Selected Rows and All Columns iii. Selected Columns and Selected Rows iv. Eliminating Duplicate Rows When Using a Select Statement v. Sorting Data in a Table 4. Creating a Table from a Table 5. Inserting Data INTO A TABLE FROM ANOTHER TABLE : i. Insertion of a Data Set Into a Table from Another Table 6. Delete Operations : i. Removal of All Rows ii. Removal of a Specified Row/s 7. Updating the Contents of a Table 8. Modifying the Structure of Tables : i. Adding New Columns ii. Dropping a column from a table iii. Modifying Existing Columns iv. Restrictions on the Alter 9. Renaming Tables 10. Truncating Tables 11. Destroying Tables 12. Examining Objects Created by a User : i. Finding Out The Table/s Created by a User ii. Finding Out The Column Details Of A Table Created 13. Self Review Questions 14. Hands on Exercises IV. Interactive SQL Part II : 1. Data Constraints : i. Applying Data Constraints 2. Types of Data Constraints : i. The Primary Key constraint ii. The Foreign Key Constraint 3. Business Rule Constraints : i. Column Level Constraints ii. Table Level Constraints iii. Null value Concepts iv. Not Null Constraint Defined at the Column Level v. The Unique Constraint vi. The Primary Key Constraint173 vii. The Foreign Key Constraint175 viii. Insert Or Update Operation In The Foreign Key Table ix. Delete Operation On The Primary Key Table x. Assigning User Defined Names to Constraints xi. The Check Constraint Printed Pages: 932. Codice libro della libreria 52971

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 9,94
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,99
Da: India a: U.S.A.
Destinazione, tempi e costi

2.

Bayross
Editore: BPaperback Publications
ISBN 10: 8176566918 ISBN 13: 9788176566919
Nuovi Quantità: > 20
Da
BookVistas
(New Delhi, DELHI, India)
Valutazione libreria
[?]

Descrizione libro BPaperback Publications. Condizione libro: New. Codice libro della libreria BPaperback-9788176566919

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 9,94
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,99
Da: India a: U.S.A.
Destinazione, tempi e costi

3.

Ivan Bayross
Editore: BPB Publications (2010)
ISBN 10: 8176566918 ISBN 13: 9788176566919
Nuovi Softcover Prima edizione Quantità: > 20
Da
A - Z Books
(New Delhi, DELHI, India)
Valutazione libreria
[?]

Descrizione libro BPB Publications, 2010. Softcover. Condizione libro: New. First edition. The book has been written to provide an excellent grounding to those who wish to Learn SQL, PL/SQL and SQLJ using Oracle 8i or 9i. Like all his earlier Books this book also has several illustrative examples, which have a logical link between them. Each set of examples helps build skills that will take the reader to the next set of examples, which in turn leads upwards until a strong Programming foundation using the Natural Language of Oracle 8i or 9i has been established. Each topic is very liberally sprinkled with examples that are mapped to applications, which fit in the real world. If a grounding in Java is required a Study of “Web Enabled commercial Application Development Using Java 2.0” written by lvan Bayross is recommended. Contents Section A : SQL : I. Creating THE SQL Framework : The Oracle 81 Framework 1. Installation of Oracle 81 on Windows NT 2. Changing the Default Password for Sys 3. Activating/Deactivating the Oracle 81 Engine : i. Disabling Automatic Startup ii. Enabling A Service on Demand iii. Manually Enabling the Oracle 8i Services Under Win NT 4. Uninstalling Oracle 81 From Windows NT 5. Tablespaces in Oracle 81 : i. Logical Structures of The Database ii. The Oracle System Tablespace iii. Tablespace Usage iv, The Create Command for TABLESPACES v. Creating A Tablespace Using SQL *Plus 6. Creating Tablespace Through DBA Studio 7. Creating a DBA Login ID 8. Creating a User 9. Accessing Oracle 81 from a Remote Client : i. Creating A Connection To A Database From A Remote Client 10. Self Review Questions II. Setting up Interactive SQL *Plus Tool : 1. Invoking SQL *Plus 2. Creating a Desktop Shortcut to SQL *Plus : i. SQL Syntax or Command Based Attributes ii. Environment Related Attributes iii. Report Related Attributes iv. Printing Attributes v. Database Backup And Recovery Related Attributes vi. Miscellaneous Attributes 3. Working with the SQL *Plus ASCII Editor : i. Assigning A User Defined ASCII Editor For SQL *Plus ii. Saving The SQL Query To A User Defined File 4. Self Review Questions III. Interactive SQL Part I : 1. I Table Fundamentals : i. Oracle Data Types ii. The Create Table Command iii. Inserting Data Into Tables 2. Viewing Data in the Tables : i. All Rows Ana" All Columns 3. Filtering Table Data : i. Selected Columns and All Rows ii. Selected Rows and All Columns iii. Selected Columns and Selected Rows iv. Eliminating Duplicate Rows When Using a Select Statement v. Sorting Data in a Table 4. Creating a Table from a Table 5. Inserting Data INTO A TABLE FROM ANOTHER TABLE : i. Insertion of a Data Set Into a Table from Another Table 6. Delete Operations : i. Removal of All Rows ii. Removal of a Specified Row/s 7. Updating the Contents of a Table 8. Modifying the Structure of Tables : i. Adding New Columns ii. Dropping a column from a table iii. Modifying Existing Columns iv. Restrictions on the Alter 9. Renaming Tables 10. Truncating Tables 11. Destroying Tables 12. Examining Objects Created by a User : i. Finding Out The Table/s Created by a User ii. Finding Out The Column Details Of A Table Created 13. Self Review Questions 14. Hands on Exercises IV. Interactive SQL Part II : 1. Data Constraints : i. Applying Data Constraints 2. Types of Data Constraints : i. The Primary Key constraint ii. The Foreign Key Constraint 3. Business Rule Constraints : i. Column Level Constraints ii. Table Level Constraints iii. Null value Concepts iv. Not Null Constraint Defined at the Column Level v. The Unique Constraint vi. The Primary Key Constraint173 vii. The Foreign Key Constraint175 viii. Insert Or Update Operation In The Foreign Key Table ix. Delete Operation On The Primary Key Table x. Assigning User Defined Names to Constraints xi. The Check Constraint Printed Pages: 932. Codice libro della libreria 52971

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 9,94
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 4,99
Da: India a: U.S.A.
Destinazione, tempi e costi

4.

Bayross
Editore: BPaperback Publications
ISBN 10: 8176566918 ISBN 13: 9788176566919
Nuovi Quantità: > 20
Da
A - Z Books
(New Delhi, DELHI, India)
Valutazione libreria
[?]

Descrizione libro BPaperback Publications. Condizione libro: New. Codice libro della libreria BPaperback-9788176566919

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 9,94
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 4,99
Da: India a: U.S.A.
Destinazione, tempi e costi