Oracle Queries [message #276079] |
Tue, 23 October 2007 19:37 |
discussion_id
Messages: 7 Registered: October 2007
|
Junior Member |
|
|
Hi,
I have downloaded Oracle 10G version.
I am able to run the basic SQL queries. I have few general questions.
1. How do I get to SQL*PLUS to create reports? Is it part of the express edition or should I download another version?
2. Is there a Oracle exam that can be cleared and added to my resume? If you have any details can you please reply back?
- In the certification can I just take PL/SQL or any other sections or is it for all the sections?
- Any websites for questions to be expected?
Thanks a lot!!!
[Updated on: Tue, 23 October 2007 19:37] Report message to a moderator
|
|
|
|
Re: Oracle Queries [message #276149 is a reply to message #276084] |
Wed, 24 October 2007 02:19 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
SQL*Plus has limited reporting capabilities. Those reports will work, of course, but you might want to check Reports Builder or Discoverer. Those are GUI tools which will enable you to create ... "better looking" reports, where you can combine several queries, write your own formulas, etc.
However, here it is: SQL*Plus User's Guide and Reference book. Check chapter 6 - Formatting SQL*Plus Reports.
As of your second question, read the OraFAQ Forum Guide. In the "braindumps" section you'll find Oracle Certification links. Also, there is the Homework, Training and Certification forum here - visit it.
|
|
|