This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 178997 - Can't run Oracle view queries.
Summary: Can't run Oracle view queries.
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: -S1S-
Hardware: PC Linux
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-12-23 00:41 UTC by nleck
Modified: 2010-07-15 11:26 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description nleck 2009-12-23 00:41:28 UTC 
--total cursors open, by session
select a.value, s.username, s.sid, s.serial#
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic#  and s.sid=a.sid
and b.name = 'opened cursors current';
Comment 1 Jiri Rechtacek 2010-07-15 11:26:01 UTC 
It works for me (NetBeans 6.9), try to run my bellow select from standard views and let me know if it works for you too or add details about your problem. Thanks

-- 
select a.filename, s.banner, b.tzname
from sys.V_$TIMEZONE_FILE a, sys.V_$TIMEZONE_NAMES b, sys.V_$VERSION s
where b.TZNAME like 'B%';