What about Oracle ?
5 posts
• Page 1 of 1
What about Oracle ?
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 ? )
- ginogsm
- PROfessional Member
- Posts: 4832
- Joined: Tue Jan 13, 2004 7:41 am
- Location: Frankfurt , Germany
- Real Name: George
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
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
- Weaver
- PROfessional Member
- Posts: 1967
- Joined: Wed Jun 19, 2002 12:05 am
- Location: /home/weaver/
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 ?
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 ?
- ginogsm
- PROfessional Member
- Posts: 4832
- Joined: Tue Jan 13, 2004 7:41 am
- Location: Frankfurt , Germany
- Real Name: George
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.
-Weaver
- 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
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
- Weaver
- PROfessional Member
- Posts: 1967
- Joined: Wed Jun 19, 2002 12:05 am
- Location: /home/weaver/
Thanx a lot man. I'll let you know how I'm getting on with it.
<a href="http://www.vistamania.org/" target="_blank"><img src="http://parcom.pro-networks.org/images/vistamania35zu.gif" border="0"></a>
- ginogsm
- PROfessional Member
- Posts: 4832
- Joined: Tue Jan 13, 2004 7:41 am
- Location: Frankfurt , Germany
- Real Name: George
5 posts
• Page 1 of 1
Return to HTML, CSS, and Scripts
Who is online
Users browsing this forum: No registered users and 8 guests