|
|
shabbir
There are times when duplicate rows somehow creep into the table. The best scenario to happen this is when the data is to be imported from some other table or data and the Constraints are removed so that data import successfully.
Now in Oracle you can delete the duplicate entries by just...
|
|
5 |
94,988 |
|
|
|
Sanskruti
Data integrity is about enforcing data validation rules such as checking that a percentage amount is between 0 and 100 and to ensure that invalid data does not get into your tables. Historically, these rules were enforced by the application programs themselves and the same rules were checked...
|
|
3 |
5,488 |
|
|
|
kidas
Introduction
Oracle provides two collection types: nested tables and varying arrays or VARRAYS. A collection is an ordered group of elements of the same type. Each element from the group can be accessed using a unique subscript. The element types of a collection can be either built-in...
|
|
2 |
2,314 |
|
|
|
Sanskruti
Introduction
SQL*Plus (pronounced "sequel plus") is an interactive tool for the Oracle RDBMS environment. SQL*Plus can be used simply to process SQL statements one at a time, process SQL statements interactively with end users, utilize PL/SQL for procedural processing of SQL statements, list...
|
|
7 |
6,815 |
|
|
|
shabbir
I would be doing this in a new user and so first you need to have the administrative priviledges to create new user. By default the Scott user does not have the priviledges and you need to login using the System user.
Create New User In Oracle
Create User <UserName> Identified by ; ...
|
01-08-2009 08:33 PM
by game 
|
5 |
11,326 |
|
|
 |
pradeep
When you install an Oracle database, you automatically install an Apache 1.3 HTTP server on which the database relies for many of its products and features. It seems to be a waste of resources to install a second Web server for database-driven Web site development on a single machine. It would be...
|
|
3 |
5,033 |
|
|
|
Sanskruti
Introduction
PL/SQL exception handling is a mechanism for dealing with run-time errors encountered during procedure execution. Use of this mechanism enables execution to continue if the error is not severe enough to cause procedure termination. The decision to enable a procedure to continue...
|
11-25-2008 09:37 PM
by kidas
|
3 |
6,254 |
|
|
|
Sanskruti
A datatype is a classification of a particular type of information or data. Each value manipulated by Oracle has a datatype. The datatype of a value associates a fixed set of properties with the value. These properties cause Oracle to treat values of one datatype differently from values of another....
|
11-25-2008 09:19 PM
by kidas
|
6 |
18,044 |
|
|
|
Sanskruti
Introduction
PL/SQL uses cursors for all database information access statements. The language supports the use of both implicit and explicit cursors. Implicit cursors are those established for which explicit cursors are not declared. You must use explicit cursors or cursor FOR loops in all...
|
11-25-2008 08:46 PM
by kidas
|
6 |
4,362 |
|
|
|
shabbir
If I say Oracle is the best database system available then there will be hardly any one who will disagree with me. Oracle 8 / 8i were the best database systems and the biggest bug in Oracle 8 is, there is no uninstaller and after you install the Oracle 8 personal you don’t have an option of...
|
|
4 |
11,900 |
|
|
|
pradeep
When you use SELECT in a PL/SQL block, it's important to make sure that exactly one row will always be returned by your query. If more than one row is returned, the TOO_MANY_ROWS exception occurs. There are four ways to make sure your code is safe from this error...
Oracle's PL/SQL language...
|
|
2 |
4,043 |
