Attention: PROnetworks has upgraded our forum from phpbb2 to phpbb3!!

Please head over to our new converted forum at: http://www.pronetworks.org/forums/

This old forum will remain 'read-only' until approximately February 2009. We look forward to seeing you at the new forum!
Author Message
ginogsm
George Tzivelekis
PostPosted: Thu Feb 19, 2004 3:43 pm Reply with quote

Support Team
 
 


Joined: 13 Jan 2004
Posts: 17248
Location: Athens , Hellas
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 thumbsup ( weaver heared me ? whistle )
 
Back to top
Weaver
PostPosted: Thu Feb 19, 2004 6:24 pm Reply with quote

PROfessional Member
 
 


Joined: 18 Jun 2002
Posts: 2587
Location: /home/weaver/
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
 
Back to top
ginogsm
George Tzivelekis
PostPosted: Thu Feb 19, 2004 6:49 pm Reply with quote

Support Team
 
 


Joined: 13 Jan 2004
Posts: 17248
Location: Athens , Hellas
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 ?
 
Back to top
Weaver
PostPosted: Thu Feb 19, 2004 7:20 pm Reply with quote

PROfessional Member
 
 


Joined: 18 Jun 2002
Posts: 2587
Location: /home/weaver/
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:

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
 
Back to top
ginogsm
George Tzivelekis
PostPosted: Thu Feb 19, 2004 7:22 pm Reply with quote

Support Team
 
 


Joined: 13 Jan 2004
Posts: 17248
Location: Athens , Hellas
Thanx a lot man. I'll let you know how I'm getting on with it.
 
Back to top
Back to top
Index >> Webmaster Domain & Code Room >> What about Oracle ?

Page 1 of 1

 


Tired of the Ads? Registered users have 80% less adverts.