Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How can we query Oracle OLAP cube from .NET?

701826May 16 2009 — edited May 20 2009
Hi,

Is there a library or provider for querying an OLAP cube from a .NET
application?

Does it support MDX?

Thanks,
Yash

Comments

Hoek
Unfortunatly no 11g for me here but on 10.2.0.4 I get immediate results:
SQL> with t as (select '0' str from dual)
  2  select *
  3  from t
  4  where regexp_like (str, '^d{0,2}*$');

no rows selected

SQL> with t as (select '0' str from dual)
  2  select *
  3  from t
  4  where regexp_like (str, 'd{0,2}*');

S
-
0
Does the second version also hang on your database?
1 person found this helpful
Solomon Yakobson
Works fine on:
SQL> select * from v$version
  2  /
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE    11.1.0.6.0      Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

SQL> with T as (
  2  select '0' str from dual)
  3  select *
  4  from T
  5  where regexp_like (str, '^d{0,2}*$')
  6  /

no rows selected

SQL>
SY.
1 person found this helpful
Frank Kulash
Answer
Hi,
CharlesRoos wrote:
Why Oracle 11 hangs on this statement, statement never ends execution:
with T as (
select '0' str from dual)
select *
from T
where regexp_like (str, '^d{0,2}*$')
Does it start execution? In SQL*Plus, you have to end the statement with a ; or put a / on the next line.

It works for me.

What is the * near the end of the 2nd argument supposed to do?
'd' means the lower-case letter 'd'. To indicate a digit, you can use '\d' (with a \ ).
Marked as Answer by WestDrayton · Sep 27 2020
Solomon Yakobson
And, btw it should be '^<font color=red>\</font>d{0,2}*$'. Now if you did have a backslash and it was a posting typo and you use SQL*Plus check if SET PAUSE is ON. If it is, you must hit enter to get result page.

SY.
1 person found this helpful
WestDrayton
Ok, thx,
i did something wrong myself here.
Aketi Jyuuzou 
select * from V$version;

BANNER
--------------------------------------------------------
Oracle Database 11g Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production 
NLSRTL Version 11.2.0.1.0 - Production
Wow! My oracle hangs too. 
select *
  from dual where RegExp_Like('0','^a{0,2}*$');
But actually,This regex is wrong regex. 
a{0,2}*
1 person found this helpful
WestDrayton
Does it really went to sandclock on your Ora11 too?
I thought i had some other issues why i got the statement 5 hours running in my oracle.

I am afraid to run this statement again. but seems it is a asystem bug then.

Edited by: CharlesRoos on Apr 22, 2010 11:56 PM
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 17 2009
Added on May 16 2009
#data-warehousing, #olap
3 comments
2,554 views