OraQA

Oracle Question and Answer

  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed

Author Archive

« Previous Entries
Next Entries »

What is the difference between SYS and SYSTEM database user accounts?

How to generate a histogram using SQL

Can I consume web services from within an Oracle database?

What is the max line length when calling DBMS_OUTPUT.PUT_LINE?

What is the max buffer size that can be set when calling DBMS_OUTPUT.ENABLE?

Is TRUNCATE TABLE t same as DELETE FROM t?

What is the difference between V$ and GV$, also V$ and V_$?

Can I commit a transaction inside a database trigger?

How to paginate through an ordered result set

How to get the OS of the database server

What is the difference between a database and an instance?

How to seperate character data from numeric data

How to return rows in a random order

What are the different ways to generate rows?

How to SELECT from a comma delimited list

« Previous Entries
Next Entries »