| ClanKiller.com https://forums.plasmasky.com/ |
|
| SQL https://forums.plasmasky.com/viewtopic.php?f=8&t=1541 |
Page 1 of 1 |
| Author: | derf [ Tue Dec 06, 2005 11:39 am ] |
| Post subject: | SQL |
I want to practice SQL over xmas on my home PC. So far ive been using SQL*Plus on the computers at university. I downloaded Oracle 10g on my PC and tried logging onto SQL*Plus to no avail. Its just not that simple. Do any of you guys know how to get something based on SQL on my PC so i can practice querying? |
|
| Author: | ElevenBravo [ Tue Dec 06, 2005 1:51 pm ] |
| Post subject: | |
Try downloading Mysql. http://www.mysql.com/ Although Im not sure I understand you full dilema. You have some databases at your college in SQL*Plus that you want to move to your home pc? If so, export your SQL*Plus database into a text file then upload it into your pc. |
|
| Author: | Satis [ Tue Dec 06, 2005 5:57 pm ] |
| Post subject: | |
you said you tried "logging into sql*plus)? What's sql*plus? Some sort of db front end? If that's what you're looking for, there are a ton of front-ends that'll work with mysql and oracle. |
|
| Author: | derf [ Wed Dec 07, 2005 5:32 am ] |
| Post subject: | |
SQL*Plus is an Oracle command line utility used for executing SQL and PL/SQL commands. If it is as you say a 'front end' can you link me to more of these 'front end' thingys? |
|
| Author: | Satis [ Wed Dec 07, 2005 9:14 am ] |
| Post subject: | |
PHPMyAdmin http://www.phpmyadmin.net/home_page/index.php great one for php (web-based, so you'll need a web server and php installed too) Aqua Data Studio http://www.aquafold.com/ GUI utility that links into a huge number of databases. Has a very similar look and feel to MS-SQL Enterprise Manager. I REALLY like this one...I use it all the time at my job. |
|
| Author: | derf [ Sat Dec 10, 2005 6:08 pm ] |
| Post subject: | |
Ok, so ive downloaded MySQL. I guess i need to use the MySQL Command Line client to run queries on a database right? How do i make it point to a database? (text file). |
|
| Author: | Satis [ Sun Dec 11, 2005 11:04 am ] |
| Post subject: | |
http://dev.mysql.com/doc/refman/5.0/en/ ... ation.html |
|
| Author: | derf [ Fri Dec 16, 2005 9:39 am ] |
| Post subject: | |
Ok im at uni now. I came across a problem while writing a PROMPT for a report. Using: where c.customer_id = &customer_id And giving a value after, returns: invalid column name Example: WHERE c.customer_id = &customer_id AND a.account_id = c.account_id AND c.customer_id = ca.customer_id AND c.customer_id = co.customer_id AND co.order_id = o.order_id; Any ideas? |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|