Goeduhub Technologies Last Batch Student's Projects || COVID-19 Projects(AI-ML) || Go to your University  ||  Placement Preparation  
Free Online Tutorials ||  MACHINE LEARNING || Python || DBMS || OOPs || DSA || Java || Linux/Unix ||  C Programming
0 like 0 dislike
23 views

1 Answer

0 like 0 dislike
by Goeduhub's Expert (2.9k points)
selected by
 
Best answer

Download Oracle Database E-book free Click Here

The Oracle® Database Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified

Book created for educational purposes and is not affiliated with Oracle® Database group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners

Chapters

  1. Getting started with Oracle Database

  2. Getting started with PL/SQL
  3. Anonymous PL/SQL Block
  4. PL/SQL procedure
  5. Data Dictionary
  6. Dates
  7. Working with Dates
  8. DUAL table
  9. JOINS
  10. Handling NULL values
  11. String Manipulation
  12. IF-THEN-ELSE Statement
  13. Limiting the rows returned by a query (Pagination)
  14. Recursive Sub-Query Factoring using the WITH Clause (A.K.A. Common Table Expressions)
  15. Different ways to update records
  16. Update with Joins
  17. Functions
  18. Statistical functions
  19. Window Functions
  20. Creating a Context
  21. Splitting Delimited Strings
  22. Collections and Records
  23. Object Types
  24. Loop
  25. Cursors
  26. Sequences
  27. Indexes
  28. Hints
  29. Packages
  30. Exception Handling
  31. Error logging
  32. Database Links
  33. Table partitioning
  34. Oracle Advanced Queuing (AQ)
  35. constraints
  36. Autonomous Transactions
  37. Oracle MAF
  38. level query
  39. Hierarchical Retrieval With Oracle Database 12C
  40. Data Pump
  41. Bulk collect
  42. Real Application Security
  43. Assignments model and language
  44. Triggers
  45. Dynamic SQL

Related questions

0 like 0 dislike
1 answer 23 views
0 like 0 dislike
1 answer 17 views
0 like 0 dislike
1 answer 25 views
0 like 0 dislike
1 answer 22 views
0 like 0 dislike
1 answer 25 views
  Realize your learning potential with courses starting at ₹ 420
 Placements:   List of companies | Logical Reasoning Questions | Quantitative Aptitude Questions | General English Questions | Technical-MCQ and Interview Questions
 Online Free Training:  MACHINE LEARNINGPython Programming | Database Management System(DBMS) | Object Oriented Programming(OOPs) using C++ | Data Structures and Algorithms(DSA) | Java Programming | Linux/Unix | C Programming
Exams: List of Exams After Graduation | List of Engineering Entrance Examinations (UG/PG) | JEE Main | JEE Advanced | GATE | IES | ISROList of PSUs
 Download Previous Year Papers For:  GATE | IES | RAJASTHAN TECHNICAL UNIVERSITY (RTU-Kota)RPSC Technical Exams | ISRO
 Goeduhub
About Us | Contact Us   Social::   |  | 
...