Author Topic: Guidance and resources for posters [in Oracle]  (Read 145 times)

0 Members and 1 Guest are viewing this topic.

Offline CyborgRepublic

  • Full Member
  • *
  • Posts: 202
  • Karma: +0/-0
    • View Profile
Guidance and resources for posters [in Oracle]
« on: September 10, 2008, 08:29:33 AM »
Guidance and resources for posters
Before you post:
* Try using the Search button to see if a similar question has already been answered
* Try reading the relevant parts of the Oracle documentation (see links below)
* Try performing a Google search

When you post:
* Give your post a meaningful title, so that people have some idea what it will be about. Titles like "Please help!" and "Newbie query" aren\'t very useful.
* Posts should contain OS name & version
* Posts should contain Oracle software version number to 4 decimal places
* Posts should contain cut & paste copies of actual inputs & output messages
* Use vb Code tags to make your post more readable. The most important of these is the code tag, which makes both code and examples clearer by using a proportional font and maintaining spacing - e.g. instead of this:

SQL> select *
2 from emp
3 where deptno = 10;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- ----------- ---------- ---------- ----------
7782 CLARK MANAGER 7839 09-JUN-1981 2450 10
7934 MILLER CLERK 7782 23-JAN-1982 1300 10

...you get this:
Code:

SQL> select * 2 from emp 3 where deptno = 10; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- ----------- ---------- ---------- ---------- 7782 CLARK MANAGER 7839 09-JUN-1981 2450 10 7934 MILLER CLERK 7782 23-JAN-1982 1300 10


Useful links:

Oracle Online Documentation:
Oracle 8.1.7
Oracle 9.2
Oracle 10.1

Other Resources (thanks to Saravanan.R for many of these):
http://www.orafaq.com/
http://www.oracle-base.com/Index.php
http://www.ixora.com.au/q+a/index.html
http://www.llcsystems.com/FAQ.htm
http://www.arikaplan.com/oracle.html
http://www.csee.umbc.edu/help/
http://www.ss64.com/index.html
http://news.dcn-asu.ru/BOOKS/

An Introduction to Oracle SQL Statement Tuning (Bill Magee)
Introduction to Data Modelling (University of Texas)

Other forums:
Quest PL/SQL Pipeline
SourceCode republic
comp.databases.oracle

Please feel free to suggest other tips and links; I will update this post from time to time.

Techronnati | where technology never sleeps

Guidance and resources for posters [in Oracle]
« on: September 10, 2008, 08:29:33 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
114 Views
Last post August 24, 2008, 04:33:09 PM
by h2obubbler
0 Replies
133 Views
Last post September 10, 2008, 06:34:26 AM
by JusticeLeague
0 Replies
124 Views
Last post October 06, 2008, 04:52:13 AM
by GBTalk
1 Replies
163 Views
Last post February 23, 2009, 11:51:30 AM
by techguy
0 Replies
130 Views
Last post November 01, 2008, 07:57:35 AM
by Corps

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.