A Digital Age Deserves A Digital Leader

What about Oracle ?

What about Oracle ?

Postby ginogsm » Thu Feb 19, 2004 7:43 pm

I have a DVD with Oracle 9I R2. Since my company will be making tutorials on Oracle at the second half of this year , I thought I might as well be prepared. I would like a first step to Oracle book. I'm a begginer with programming and therefor I can't really find out what's best for me. If anyone could suggest anything ^*^ ( weaver heared me ? :whistle )
PROfessional Member
User avatar
Posts: 4832
Joined: Tue Jan 13, 2004 7:41 am
Location: Frankfurt , Germany
Real Name: George

Postby Weaver » Thu Feb 19, 2004 10:24 pm

Saw you talking about this on our IRC channel. Sorry man, I am not too familiar with Oracle. I know MySQL and SQL syntax so I could help you out with queries and such. I can't recommend a book that I haven't read or dealt with personally, so I am pretty much useless.

In all honesty, I can recommend learning SQL first or at the same time. The "for Dummies" books are quite nice in this area. I have "SQL for Dummies" and it has treated me very well. I am sure there is a book called "Oracle for Dummies." The great things about these books is they assume you know next to nothing, great for beginners.

Sorry I can't help more.

-Weaver
Public Keys

The primary purpose of the DATA statement is to give names to constants; instead of referring to pi as 3.141592653589793 at every appearance, the variable PI can be given that value with a DATA statement and used instead of the longer form of the constant. This also simplifies modifying the program, should the value of pi change.
-- FORTRAN manual for Xerox Computers
PROfessional Member
User avatar
Posts: 1967
Joined: Wed Jun 19, 2002 12:05 am
Location: /home/weaver/

Postby ginogsm » Thu Feb 19, 2004 10:49 pm

To my knowledge MySQL is installed in my Fedor installation. Right ?
I'll try to get on with it from Fedora and let you know my progress.But ... where do I find MySQL's ( kind of ) programming enviroment in there. Or is it like I'll vi something to start ?
PROfessional Member
User avatar
Posts: 4832
Joined: Tue Jan 13, 2004 7:41 am
Location: Frankfurt , Germany
Real Name: George

Postby Weaver » Thu Feb 19, 2004 11:20 pm

The name of the program you use to interact with MySQL on the shell level is usually "mysql". Below is a sample of a "mysql" session.

Code: Select all
test@testbox:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 328 to server version: 3.23.52-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+------------+
| Database   |
+------------+
| bookmarks  |
| dbtest     |
| friends    |
| longhorn   |
| mydb       |
| mysql      |
| pafiledb   |
| test       |
| tpl_dltest |
| webmail    |
+------------+
10 rows in set (0.01 sec)

mysql> use bookmarks;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------+
| Tables_in_bookmarks |
+---------------------+
| bookmarks           |
+---------------------+
1 row in set (0.00 sec)

mysql> describe bookmarks;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | smallint(6)  |      | PRI | NULL    | auto_increment |
| folder   | varchar(30)  | YES  |     | NULL    |                |
| linkname | varchar(50)  | YES  |     | NULL    |                |
| linkurl  | varchar(255) | YES  |     | NULL    |                |
| approved | char(3)      |      |     | no      |                |
+----------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> select id, folder, linkname from bookmarks;
+----+-------------+----------------------------------------+
| id | folder      | linkname                               |
+----+-------------+----------------------------------------+
|  1 | Linux       |                                        |
|  2 | Network     |                                        |
|  3 | Programming |                                        |
|  4 | PHP_Dev     |                                        |
|  5 | PHP_Dev     | PHP Builder                            |
|  6 | Security    |                                        |
|  8 | Security    | comp.os.linux.security FAQ             |
|  9 | Wireless    |                                        |
| 11 | Wireless    | NoCat WAP Portal System                |
| 13 | Programming | IBM Secure Programmer                  |
| 14 | Xbox        |                                        |
| 15 | Xbox        | xbox-scene                             |
| 16 | Cracking    |                                        |
| 17 | Cracking    | MegaGames Cracking Thread              |
| 18 | Cracking    | The Krobar Collection                  |
| 19 | Linux       | DOS Emulation under Linux              |
| 20 | Windows     |                                        |
| 21 | Windows     | Removing MSN Messenger from Windows XP |
| 22 | GAMAGE      |                                        |
| 23 | GAMAGE      | Game Music PC NES SNES                 |
| 24 | Network     | MUTE anonymous p2p (ants)              |
| 25 |             | Primary Colors                         |
| 26 | Network     | Mozilla Firebird FAQ (Java Fix, etc.)  |
+----+-------------+----------------------------------------+
23 rows in set (0.00 sec)

mysql>



-Weaver
Public Keys

The primary purpose of the DATA statement is to give names to constants; instead of referring to pi as 3.141592653589793 at every appearance, the variable PI can be given that value with a DATA statement and used instead of the longer form of the constant. This also simplifies modifying the program, should the value of pi change.
-- FORTRAN manual for Xerox Computers
PROfessional Member
User avatar
Posts: 1967
Joined: Wed Jun 19, 2002 12:05 am
Location: /home/weaver/

Postby ginogsm » Thu Feb 19, 2004 11:22 pm

Thanx a lot man. I'll let you know how I'm getting on with it.
Image
<a href="http://www.vistamania.org/" target="_blank"><img src="http://parcom.pro-networks.org/images/vistamania35zu.gif" border="0"></a>
Image
PROfessional Member
User avatar
Posts: 4832
Joined: Tue Jan 13, 2004 7:41 am
Location: Frankfurt , Germany
Real Name: George

Return to HTML, CSS, and Scripts

Who is online

Users browsing this forum: No registered users and 0 guests