When i type 'ed' or 'edit' in oracle i did n't presented by any editor,what is the problem?
Latest Answer: SQL*Plus is a client program and interactive interpreter designed for interacting with Oracle databases. SQL is a standard data access language used to describe data access to a variety of databases. They have nothing to do with each other."SQL*Plus" ...
Latest Answer: 8i-materilized views, instead of triggers, support internet, granting of columns
9i-timestamp, rename of column, new datatypes, rank, dense_rank, 9i joins ...
Latest Answer: Isolated join is a join which is not connected to any of the context. ...
What is your server configration ?What is your SGA size ?what is Shared pool size ?How much size have you configured for oracle_block ?
Latest Answer: A materialized view (MV) is similar to a view but the data is actually stored on disk (view that materializes). Materialized views are often used for summary and pre-joined tables, or just to make a snapshot of a table available on a remote system. A ...
Latest Answer: Truncate and delete both are used to delete the records from the table. The difference is Truncate never fire delete trigger placed on the table.Truncate resets the high water mark for the table and will not generate any redo.Truncate can not be recoverable.Only ...
Latest Answer: First you have to understand that Oracle is a MVCC (multiversion concurrency control) or "repeatable read" database system. Queries are returned with all rown consistent with respect to the point in time (SCN) you bagan the query (or earlier with "flashback ...
Latest Answer: Following this as an example let us see how the select execution happens in
database.
SELECT ename,sal,job FROM emp
WHERE job='clerk'
ORDER BY sal;
How does the query execution occur?
SQL*plus checks the syntax on client side.
If syntax ...
View page << Previous 4 5 6 7 [8] 9 Next >>

Go Top