Skip to content

Oratable

  • Home
    • SQL
    • PL/SQL
    • Data Dictionary
    • Datatypes
    • DBA
    • Exceptions
    • FAQ
    • Keywords
  • About
  • Contact

Database Design

The design of an overall database system, including the choice of data structures, identifying data relationships and defining models on the basis of these relationships.

The Difference between User and Schema in Oracle

Difference between User and Schema in Oracle

As an Oracle developer, you have probably wondered at some point: do user and schema in Oracle really mean the same thing? And if they do, why does Oracle have two names for it?

This post helps to clarify the sameness – or otherwise – of Oracle user and schema.

Read more

Categories Database Design, DBA, DDL 6 Comments
Newer posts
← Previous Page1 Page2

Popular Posts

  • How To Lock A Row In OracleHow to Lock a Row: SELECT FOR UPDATE
  • UTL_HTTP to Call a Web Service from PL/SQLUTL_HTTP to Call a Web Service from PL/SQL
  • UTL_FILE: Simple write to file exampleUTL_FILE: Write To File Example and Debugging Common Errors
  • LISTAGG for Converting Rows to Comma-Separated String in OracleLISTAGG for Converting Rows to Comma-Separated String
  • Oracle Database NameHow to Find Out Your Oracle Database Name

 

  • Analytics
  • Collections
  • Data Dictionary
  • Database Design
  • Datatypes
  • DBA
  • DDL
  • Dependencies
  • Exceptions
  • FAQ
  • Interview
  • Joins
  • JSON
  • Keywords
  • Miscellaneous
  • Object Types
  • ORA Errors
  • Parameters
  • Performance
  • PL/SQL
  • Pseudocolumns
  • Scripts
  • Sequences
  • SQL
  • Subqueries
  • Triggers
  • UTL packages
  • Views
  • XML DB

 

APEX case expression constraints correlated subqueries CTAS distinct dynamic SQL exists hierarchical queries inline views java materialized views multiset null handling Oracle XE popular regex rownum scalar subqueries soft delete with clause XML

Oracle Forums

  • Ask Tom
  • Oracle Forums
  • OraFAQ

Blogroll

  • Alberto Dell'Era
  • Amis Technology Blog
  • Data Warehousing with Oracle
  • JAVA, SQL AND JOOQ.
  • Jonathan Lewis
  • oracle-developer.net
  • SQL Maria
  • Sydney Oracle Lab
  • ThatJeffSmith
  • The Arup Nanda Blog

Recommended Reading

  • Effective Oracle By Design
    Effective Oracle By Design
    by Thomas Kyte
  • Cost Based Oracle Fundamentals
    CBO Fundamentals
    by Jonathan Lewis
About Oratable

Oratable is for learners and practitioners of Oracle, especially developers at a beginner level. You'll find here tips, tricks and tutorials about cool things you can do with the Oracle database.

Popular Posts Which objects depend on this table? 6 Reasons To Use PLSQL Packages
© 2013 - 2026 Oratable. All rights reserved.
Privacy Policy | Contact