|
|
 |
= 7 days or newer |
|
 |
= 14 - 7 days old |
Documentation
|
|
Using Oracle provided extensions, you can construct complex hierarchical operations on a tree-structured data. With Oracle Database 10g, new features have been added to Oracle’s support for hierarchical queries. In this article, we will discuss these new features in detail, with examples.
|
|
|
|
Data integrity allows to define certain data quality requirements that the data in the database needs to meet. If a user tries to insert data that doesn't meet these requirements, Oracle will not allow so.
|
|
|
|
Oracle's SQL trace facility allows an administrator to see what SQL is being run by an application, even if he has only limited access to the program. This knowledge can be used to optimise database performance or to suggest improvements to software developers, or sometimes just to understand what is going on.
|
|
|
|
How many of you have asked yourself what SQL is all about anyway? Join me as I begin a venture down the road of understanding SQL and how to take advantage of this language.
|
|
|
|
At the core of most queries is an underlying table structure. Part II discusses how we can issue the most basic of SELECT statements to extract information from a database table.
|
|
|
|
We do not always want to SELECT everything from a table. The matter of finding the information required is a function of implementing the optional WHERE clause of the SELECT statement.
|
|
|
|
As your database grows so will the need to get information from more than one table. This article shows you the different join options and some simple examples to raise your familiarity.
|
|
|
|
A pseudocolumn is a column that looks like a column but really is not a column. What! Stick around and find out what a pseudocolumn really is.
|
|
|
|
It is not a question as to whether or not hierarchical models are good or bad. We will all come across them no matter where we go. However, querying these structures has often baffled many practitioners. Not just in understanding the model behind them but in querying them properly. Before we begin with the SQL required to query hierarchical table structures it is always good to understand what they are.
|
|
|
|
The distributed locking is one of the most complicated issues in using Oracle RAC. Its complexity did not reduce at whole since the OPS times. Most of the issues may be resolved by running sql statements via gv$ and x$ tables. However in order to resolve the most complicated problems you or oracle support should use system state dumps and oradebug. In this short topic we will explain relatively simple case of distributed lock problem. Shortly we will present two additional topics regarding usage of "oradebug lkdebug" statement and another topic about reading results of "oradebug -g all hanganalyze 3" and "oradebug -g all dump systemstate 10" respectively.
|
|
|
|
|
|
|
|
|
|
Page Views
|
|
1,535 today
|
|
2,067 yesterday
|
|
74,891 last month
|
|
13,246,866 total
|
|
|
|
