Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 70
Search took 0.01 seconds.
Search: Posts Made By: Justin Cave
Forum: SQL Language June 13th, 2005, 05:53 PM
Replies: 4
Views: 1,834
Posted By Justin Cave
Why? Particularly if there is a large volume of...

Why? Particularly if there is a large volume of data, most databases have facilities to generate and consume something like a deliited text file rather efficiently. Unless you have a tool that...
Forum: Oracle April 14th, 2005, 02:14 AM
Replies: 3
Views: 1,347
Posted By Justin Cave
If you have a table t1, you could create a table...

If you have a table t1, you could create a table that stored the changes to t1, i.e. t1_change.

You could then create a trigger on t1 that wrote data to t1_change. Exactly what you would need to...
Forum: Oracle April 14th, 2005, 01:06 AM
Replies: 3
Views: 1,347
Posted By Justin Cave
Unless you are storing some sort of identifier...

Unless you are storing some sort of identifier that tells you what is "new", you cannot get just the most recent data.

Potentially, you could add a trigger to the table that would insert a row...
Forum: SQL Language February 15th, 2005, 12:00 PM
Replies: 4
Views: 936
Posted By Justin Cave
Except that the original requirement envisions...

Except that the original requirement envisions one player on an arbitrarily large number of teams. That's the reason that you need the mapping table TEAM_PLAYER (which would probably be better named...
Forum: Oracle February 14th, 2005, 03:45 PM
Replies: 3
Views: 1,306
Posted By Justin Cave
Is there a reason that you are forcing the query...

Is there a reason that you are forcing the query to use the rule based optimizer rather than the cost based optimizer?

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
Forum: SQL Language February 12th, 2005, 06:48 PM
Replies: 4
Views: 936
Posted By Justin Cave
Normally, you would would not create the TEAMS...

Normally, you would would not create the TEAMS table with 22 player columns. You would create a PLAYER table with player information, a TEAM table with team information, and a TEAM_PLAYER table that...
Forum: SQL Language December 24th, 2004, 08:47 AM
Replies: 1
Views: 1,145
Posted By Justin Cave
You seem to have written a syntactically valid...

You seem to have written a syntactically valid SQL statement. Since you haven't explained the results you want and whether that differs from the results you are getting, though, it is impossible for...
Forum: Oracle December 14th, 2004, 11:48 AM
Replies: 1
Views: 1,591
Posted By Justin Cave
In theory, nothing would need to change in your...

In theory, nothing would need to change in your application code when your database migrates from one platform to another. You would want to test this in your environment, though, since there are...
Forum: Oracle December 5th, 2004, 04:58 AM
Replies: 1
Views: 2,600
Posted By Justin Cave
A view is nothing more than a stored query. To...

A view is nothing more than a stored query. To add a column, you need to modify the stored query underlying the view to add another column to the SELECT list.

Justin
Distributed Database...
Forum: SQL Language November 24th, 2004, 02:50 AM
Replies: 5
Views: 2,081
Posted By Justin Cave
Code for the views would be helpful... If...

Code for the views would be helpful...

If you could provide an export of the underlying tables and the code for the views/ indexes/ etc., that would be really cool. I hate trying to get query...
Forum: SQL Language November 22nd, 2004, 11:40 PM
Replies: 5
Views: 2,081
Posted By Justin Cave
What database and database version are you using?...

What database and database version are you using?

Can you give us a rough idea of the data volumes for each table, each query, and each condition?

Justin
Distributed Database Consulting, Inc....
Forum: SQL Language November 11th, 2004, 01:37 PM
Replies: 4
Views: 1,895
Posted By Justin Cave
A graphic of the text would work. The big...

A graphic of the text would work. The big technical problem would be page size and load time. You would also prevent people from being able to do something useful with the text (i.e. cut-and-paste...
Forum: SQL Language November 10th, 2004, 03:40 PM
Replies: 4
Views: 1,895
Posted By Justin Cave
This depends on the database you are using and...

This depends on the database you are using and the character set of the web site (among other things)...

Are you using SQL Server? Oracle? Something else?

What character set is the web site...
Forum: SQL Language November 1st, 2004, 03:00 AM
Replies: 5
Views: 1,030
Posted By Justin Cave
If you want to get the "next value" you have to...

If you want to get the "next value" you have to define an order for the rows that will allow Oracle to figure out what the next value is. Once you have done that, you can use the lead() analytic...
Forum: SQL Language October 25th, 2004, 06:35 PM
Replies: 5
Views: 1,030
Posted By Justin Cave
If you aren't ordering the data, then there is no...

If you aren't ordering the data, then there is no such thing as the "next row", at least to a relational database. If I do


SELECT *
FROM someTable


a database is free to return the rows in...
Forum: SQL Language October 24th, 2004, 01:19 AM
Replies: 3
Views: 639
Posted By Justin Cave
I believe that you would want SELECT * ...

I believe that you would want


SELECT *
FROM tblPatientVisits
WHERE MRNumber = (SELECT DISTINCT MRNumber
FROM tblReleases
WHERE LastName LIKE 'R%')
Forum: SQL Language October 21st, 2004, 02:56 PM
Replies: 5
Views: 1,030
Posted By Justin Cave
How you define the "next record". Are you doing...

How you define the "next record". Are you doing some sort of ordering of the data in your query, possibly based on the date column?

Justin
Distributed Database Consulting, Inc....
Forum: SQL Language October 18th, 2004, 10:06 AM
Replies: 6
Views: 1,388
Posted By Justin Cave
What version of Access? My understanding is that...

What version of Access? My understanding is that recent versions of Access support the LEFT OUTER JOIN syntax...



Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
Forum: SQL Language October 17th, 2004, 07:19 PM
Replies: 6
Views: 1,388
Posted By Justin Cave
In that case, you would need to add the...

In that case, you would need to add the appropriate outer join. Assuming your database supports the SQL 99 syntax for outer joins


SELECT course.courseID,
course.courseName,
COUNT(*) As...
Forum: SQL Language October 17th, 2004, 04:11 PM
Replies: 6
Views: 1,388
Posted By Justin Cave
SELECT course.courseID, course.courseName, ...

SELECT course.courseID,
course.courseName,
COUNT(*) As numberEnrolled
FROM tblCourses course,
tblRegister reg
WHERE reg.courseID = course.courseID
GROUP BY course.courseID, course.courseName...
Forum: SQL Language October 15th, 2004, 08:44 AM
Replies: 1
Views: 954
Posted By Justin Cave
Just add rows to the SELECT and GROUP BY clauses ...

Just add rows to the SELECT and GROUP BY clauses


SELECT col1, col2, COUNT(*) as Sum
FROM table
GROUP BY col1, col2
HAVING count(*) > 1


Justin
Forum: SQL Language October 15th, 2004, 08:07 AM
Replies: 5
Views: 749
Posted By Justin Cave
How do you parse the data, then? How would you...

How do you parse the data, then? How would you identify what should go in add1 from these two samples?

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
Forum: Oracle October 14th, 2004, 11:04 AM
Replies: 6
Views: 1,200
Posted By Justin Cave
You are likely to have a problem, then... Oracle...

You are likely to have a problem, then... Oracle PL/SQL and SQL Server T SQL are rather different languages, and there are particular differences in how stored procedures are created to return data...
Forum: Oracle October 13th, 2004, 09:35 AM
Replies: 3
Views: 9,299
Posted By Justin Cave
Locally managed tablespaces (LMT) do not get...

Locally managed tablespaces (LMT) do not get fragmented and objects in a LMT tablespacs do not have a PCT_INCREASE setting. It sounds like you are describing a dictionary managed tablespace (DMT).
...
Forum: Oracle October 13th, 2004, 09:31 AM
Replies: 6
Views: 1,200
Posted By Justin Cave
If you want an ADO.Net dataset, you would...

If you want an ADO.Net dataset, you would generally want to hsvr a REF CURSOR OUT parameter that opens and returns a cursor to the client application. That brings me back to my question about why...
Showing results 1 to 25 of 70

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.