| Author |
Topic |
|
am2007
Starting Member
5 Posts |
 Posted - 2007-10-03 : 11:53:01
|
| Hello,I need help with a few sql questions, but you need to look at picture containing the tables and the relationships between them. How do I post or upload the picture first?Thanks. |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-03 : 12:01:32
|
Instead of a picture, script the tables DDL and paste it into the post. You can do this several ways, you can generate sql script in EM or SSMS for create or you can do SP_HELP <tablename> with results to text and paste the results (after you clean it up a bit).For more info to help you post check out what Brett put together:http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Future guru in the making. |
 |
|
|
Kristen
Test
22859 Posts |
|
|
am2007
Starting Member
5 Posts |
Posted - 2007-10-04 : 14:06:21
|
| Hi,Where do I get the software you are talking about? I looked at Oracle Enterprise Manager 10g Grid Control Release 3, but that requires installing an earlier verison. The questions I have don't seem too difficult, but being a newbie, it's hard for me to tell.Could you please let me know what exactly do I need to install, in order to generate the stuff you are looking for?Thanks. |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-04 : 14:10:42
|
| That's funny...I don't care who you are. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
am2007
Starting Member
5 Posts |
Posted - 2007-10-04 : 14:34:19
|
| where does it say that it's not an Oracle forum? or that, it is an MS SQL Server forum? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 14:47:20
|
| It says 'SQL Server Forums' on top of the screen. You should post your question in Oracle forum to get fast help. |
|
|
|
am2007
Starting Member
5 Posts |
Posted - 2007-10-04 : 14:55:51
|
| My questions aren't specific to any particular vendor's DB. So, I'm guessing it's ok to post questions here. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-10-04 : 15:03:36
|
quote:
Originally posted by am2007
where does it say that it's not an Oracle forum? or that, it is an MS SQL Server forum?
The forum description for the New to SQL Server forum is:"This forum is specifically for people that are working with SQL Server for the first time."It doesn't say it is not an Oracle forum. It also doesn't say it is not an Access, Sybase, MySQL, or DB2 forum.CODO ERGO SUM |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-04 : 15:19:34
|
| Post your question(s) anyway....we may be able to help. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-04 : 15:25:13
|
quote:
Originally posted by am2007
My questions aren't specific to any particular vendor's DB. So, I'm guessing it's ok to post questions here.
We will try and help if it is truly not application specific. We will still need your table structure in any case, in Oracle you can issue a DESC command on the table name in SQL Plus to provide that information.
Future guru in the making. |
|
|
|
am2007
Starting Member
5 Posts |
Posted - 2007-10-04 : 15:52:08
|
| The thing is, I do not have any database software installed on my home pc. So, I'm stuck at the point where I need to post the image of the relationships between the tables, without which there is no point asking questions. |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-04 : 15:55:56
|
| Simply type it out. Table A links to Table B by EmployeeID or something like that. If it's a simple question, someone here will be able to figure it out without all the DDL and data. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-04 : 15:57:31
|
| Let's say you post that picture and then someone out of the goodness of their heart looks at it and helps you out, that person here is going to provide a solution that works in T-SQL (SQL Server language), how are you going to convert it to Oracle with newbie SQL experience and no database software to test it?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Michael Raven
Starting Member
7 Posts |
Posted - 2007-10-05 : 02:48:36
|
| Well, if the person wants a picture why not :)?You can found some stuff for most common DB (include MS SQL and Oracle) servers that can make picture containing the tables and the relationships between them here[url]http://www.sqlmanager.net[/url] |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-05 : 08:40:36
|
I think he wanted to know how to post a picture on the forum.
Future guru in the making. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-05 : 11:18:53
|
| Well I, for one, am not prepared to type in the table and column names to try to reproduce the problem from a picture |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-10-05 : 19:10:22
|
| How come nobody tells this guy to click the "insert image" button on the posting page?? (am2007: you'll have to upload the pic somewhere first and then add the link to it in [ img ] [ /img ]-tags) Why are everybody so reluctant to help just because someone wants to add a simple picture??--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-05 : 19:44:20
|
Personally, I don't care if he uploads a picture, I was just offering alternatives that would be better for getting his questions answered and problems solved. But if it must be, try http://imageshack.us for hosting the file and then use the img tags as Lumbago suggested with the link imageshack creates for you.
Future guru in the making. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-05 : 20:32:26
|
quote:
Originally posted by Lumbago
Why are everybody so reluctant to help just because someone wants to add a simple picture??
Because that requires us to transfer the picture to writing so that we can work with the DDL. I'm not willing to do that anymore when the poster is able to do that for all of us. Why have all of the potential posters repeating this work?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Next Page
|
SQL questions
Here's a nice example: