Q. Who da man ?
A. YOU da man.
Spot on. My script now looks like this and I keep to keep my beloved whitespace...
This is great as I use makefiles to deploy my scripts (locally) and if I couldn't get it to work then I'd be in deep doodoo.
echo exit | sqlplus...
Right. Ignore my posts, I shouldn't have posted anything at all with my brain currently at half mast. Normally I try everything out _before_ I post a reply but I thought I could get away with winging it and all I've done is confuse myself. I'm off to bed.
Sorry, I've had a long day and not thinking straight, yes, you are on the right track...I got confused by th layout of thw query.
This is also untested but looks like what you've already got. Well done :-)
SELECT DISTINCT
m.CompanyName,
LEFT(m.ID, 8) AS ARNO,
SUM(subs.sub_cnt) AS sub_cnt...
I've had a brief look and the only thing that seems to leap out at me is that LEFT OUTER JOIN you have between your 2 sub and comp derived tables, I think that this bit...
GROUP BY Adv_MemNo) AS subs ON subs.adv_memno = LEFT(m.ID, 8) LEFT OUTER JOIN
should read
GROUP BY Adv_MemNo) AS subs ON...
New question please. I'd like to run a script that creates a database object from the command line. Simple.
Now this is from the operating system command line (which happens to be Windows), not SQL Developer, not TOAD, not PL/SQL.
And before you ask yup I've done the usual (google, resident...
Solved it. What a performance. The view 'REPORTING.vw_work_order_sample_result' had a number of dependent views, one of which had an ORDER BY clause put in while I was testing it's output. Obviously a view with an order by is a no-no (I vaguely remember being a bit surprised at the time that it...
Help, I've been using Oracle for 3 weeks and can't get a simple query to work. Googled it, asked the local database guru, looked at Oracle ref books, searched forum threads, gave up :-)
Its only when I use a column from the joined table that the query fails - never seen anything like it...
Sure, from your description I'm taking it that you are talking about a drillthrough report as opposed to an embedded subreport.
Add a report parameter to the second report specifying the person's unique identifier, then select the report component in the main report you wish to use for the link...
1 Can I drill through to a report not in the same directory as the existing report?
Yes, you can do this by setting the folder as well as the report name, for example I specify the following relative path+report name to have many main reports call a subreport in a subfolder...
One crucial question I forgot to ask:
"What is the purpose in ordering the result set ?"
If you don't need to do it then the problem goes away!
"Possible to get a copy of the query plan for the select containing the order by clause ?"
Sorry, should hqve been clearer, what I am after is the...
The pks are the book_key fields in both tables..."
Yes, I think I'm going to have to pass on this one and leave it with r937. If book_key is the pk for both tables then I'm not sure how you would relate a book to its author using just these two entities.
good luck
Yes, once again I have no idea why I am using all these brackets! My own code never uses reserved words for object naming and I never alias a table with its own name. Weird.
More importantly, in addition to the above comments note that
while the brackets, and the alias used in line 6 are merely...
From what I understand of the schema this should do the trick - but, respectfully, I think the model needs to separate the relationship between author and book into a separate entity.
DECLARE @author_name VARCHAR(100); SET @author_name = 'Limeback, Rudy'
SELECT
book.[book_type]...
Posting an answer is a little tricky I'm a little unclear how you are modelling this.
One possible structure for this would be:
Author
======
author_id
author_name
Book
====
book_id
book_name
book_type
BookAuthor (assoc entity)
==========
author_id
book_id
If you can post the schema that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.