|
More site info...
Oracle Development | Forum profile
|
|
Forum profile page for Oracle Development on http://www.devshed.com.
This report page is the aggregated overview from a single forum: Oracle Development, located on the Message Board at http://www.devshed.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Oracle Development" on the Message Board at http://www.devshed.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Oracle Development:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
8
|
45
|
110
|
|
Post:
|
26
|
81
|
222
|
|
|
Oracle Development Posting activity graph:
|
Top authors during last week:
user's latest post:
Help with two queries
Published (2009-11-27 18:33:00)
You were right in using a derived table to limit the rows because the rownum is "handed out" before ordering the result. You don't need to apply the count() again, if you have already retrieved it in the inner query, just give the column an alias and use it in the outer select: Code: SELECT s.std_num, s.birth_date, mentor_count FROM ( SELECT s1.std_num, s1.birth_date, COUNT(s2.super_id) as mentor_count FROM Student s...
user's latest post:
Recursion
Published (2009-11-27 06:53:00)
In case anyone is interest I have managed to find an answer that works. Code: SELECT rtrim(reverse(replace(sys_connect_by_path(reverse(narr), '//'), '//', ' '))) FROM table1 START WITH parent is null CONNECT BY prior oid = parent; By using CONNECT BY to navigate to the leaves of the hierarchy and using the sys_connect_by_path function you can return the full path from the root to the leaf node, then it's a...
|
|
|
|
Latest active threads on Oracle Development::
Started 2 days, 3 hours ago (2009-11-27 18:33:00)
by shammat
You were right in using a derived table to limit the rows because the rownum is "handed out" before ordering the result.
You don't need to apply the count() again, if you have already retrieved it in the inner query, just give the column an alias and use it in the outer select:
Code:
SELECT s.std_num,
s.birth_date,
mentor_count
FROM (
...
Started 2 days, 15 hours ago (2009-11-27 06:53:00)
by pleasehold
In case anyone is interest I have managed to find an answer that works.
Code:
SELECT
rtrim(reverse(replace(sys_connect_by_path(reverse( narr), '//'), '//', ' ')))
FROM
table1
START WITH
parent is null
CONNECT BY
prior oid = parent;
By using CONNECT BY to navigate to the leaves of the hierarchy and using the sys_connect_by_path...
Started 5 days, 8 hours ago (2009-11-24 14:04:00)
by mateoc15's Avatar
I have a query more or less like this:
Code:
SELECT field1,
COUNT(x) AS COUNT
FROM my_table
GROUP BY field1;
For field1 I want to get a count, but if field1 is like 'ABC%' then I want to combine all of those.
So if I have the following:
ABC1 | 5
ABC2 | 10
XYZ1 | 3
I want results like this:
ABC | 15
XYZ1 | 3
I've tried using some ...
Started 6 days, 15 hours ago (2009-11-23 06:20:00)
by debasisdas
Started 1 week, 2 days ago (2009-11-20 07:13:00)
by swampBoogie
Started 1 month, 1 week ago (2009-10-21 17:25:00)
by introtosql
Hello, as the title says, I am fairly new to SQl. I am taking fundamentals of SQL at my college and we are using Oracle 10g express edition and I have this one homework problem that i can't figure out, nor does the book help...
Basically the table is for a book company and it lists book title, book code, type, price, publisher code (not in that order) And this one question asks ...
Started 1 week, 6 days ago (2009-11-16 17:43:00)
by Guelphdad's Avatar
Started 1 month, 3 weeks ago (2009-10-03 17:40:00)
by mateoc15's Avatar
Started 2 weeks, 3 days ago (2009-11-12 06:29:00)
by scotland87
Quote: Originally Posted by silent123 I have a pl/sql stored procedure.Want to prevent procedure from running again if its already running.So how to check Procedure already running or not ?
Have a look at this thread on an other forum...Google is your friend btw, it was the first hit when i entered your exact question!
http://dbaspot.com/forums/...
|
|
Hot threads for last week on Oracle Development::
Started 5 days, 8 hours ago (2009-11-24 14:04:00)
by mateoc15's Avatar
I have a query more or less like this:
Code:
SELECT field1,
COUNT(x) AS COUNT
FROM my_table
GROUP BY field1;
For field1 I want to get a count, but if field1 is like 'ABC%' then I want to combine all of those.
So if I have the following:
ABC1 | 5
ABC2 | 10
XYZ1 | 3
I want results like this:
ABC | 15
XYZ1 | 3
I've tried using some ...
Started 6 days, 15 hours ago (2009-11-23 06:20:00)
by debasisdas
Started 2 days, 3 hours ago (2009-11-27 18:33:00)
by shammat
You were right in using a derived table to limit the rows because the rownum is "handed out" before ordering the result.
You don't need to apply the count() again, if you have already retrieved it in the inner query, just give the column an alias and use it in the outer select:
Code:
SELECT s.std_num,
s.birth_date,
mentor_count
FROM (
...
Started 2 days, 15 hours ago (2009-11-27 06:53:00)
by pleasehold
In case anyone is interest I have managed to find an answer that works.
Code:
SELECT
rtrim(reverse(replace(sys_connect_by_path(reverse( narr), '//'), '//', ' ')))
FROM
table1
START WITH
parent is null
CONNECT BY
prior oid = parent;
By using CONNECT BY to navigate to the leaves of the hierarchy and using the sys_connect_by_path...
|
|
Size: 983 bytes
