• Nested Case statement in Oracle BI

    I am trying to create a nested case statement in Oracle BI (9.0.4) the statement works when I do it in Oracle SQL*Plus but will not let me keep the whole script in the Calculation.What do I need to doo to have this work in Oracle BI? The statement is as follows: select emp_name, (CASE WHEN...

    Nanapap5 pointsBadges:
  • Call Oracle Store Procedure from Reporting services

    Can u please tell me how to call a oracle stored procedure that accepts 2 in parms and returns a Ref cursor as out parameter exmple: CREATE OR REPLACE PROCEDURE GetReportData ( Id1 IN NUMBER, Id2 IN NUMBER, resultSet OUT sys_refcursor )

    PramodSR35 pointsBadges:
  • Oracle reports

    what is the method of run\call report on form in oracle developer 10g?

    Rat15 pointsBadges:
  • Oracle driver

    Do you know if a 32 bit oracle driver works on 64 bit computer?

    Alediamo10 pointsBadges:
  • How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?

    The root of the problem seems to be w3wp.exe interacting with the 10g client we use to attach to the 9i DB (due for upgrade to 10g soon). I can't really change the VB component since it's also required to run on Windows2000 - which it handles with no problems against the same DB. Also can't upgrade...

    Alexanderph5 pointsBadges:
  • CRM on demand versus on premises solutions?

    Can somebody give a quick comparison of CRM on-demand solutions vs on-premise solutions regarding their integration capabilities with ERP and other legacy systems such as SAP, Oracle Apps?

    CRM Ask the Expert250 pointsBadges:
  • Oracle Named User licenses required for load testing

    I want to do load testing of an third party application on an environment with an oracle named user license. Assuming I am going to use a load test program like LoadRunner, what is the relationship between the number of virtual users in the load test and the requirements for Oracle licenses on the...

    Emison5 pointsBadges:
  • Replication manager

    where to find replication manager to install with oracle 8i

    Krishmurali5 pointsBadges:
  • Table replication

    How i can Replicate the table in oracle 10g

    MuhammadFahim5 pointsBadges:
  • Thin Provisioning ?

    Interested in any feedback regarding the viability of Thin Provisioning ( via FC SAN attached, not NAS)in a large scale environment. Items of specific interest related to Win2k03,AIX Oracle/MSSQL What vendors solution are you using? Has it worked as expected? Has the added value of T.P overcome any...

    LostinStorage0 pointsBadges:
  • PL/SQL – select data – group by- having?

    I need to select all names where Value EITHER a or b. how do I do that?/thnks Sample: Num Name Value 1 Ann a 2 Ann b 3 Julia a 4 Julia b 5 Peter a 6 Jnohn b

    Julctm15 pointsBadges:
  • Not Return Any Record if Value Exists

    If I have a table that has the following data (f1 & f2 are the field names): f1 f2 a 1 a 2 a 0 b 1 b 2 b 3 I want to write a query that would not return b because b has a f2 = 3. So, in other words: I have a table with many records for each id. I do not want to return any records if the id has a...

    Rjwilcox45 pointsBadges:
  • reports erver in oracle 10g

    how to creat report server in oracle 10g & run the report

    Harshu5 pointsBadges:
  • Login error for workspace

    Hi All, I have installed and configured hyperion system 9 BI+. I can login shared services and essbase with admin/password. But i cant able to login workspace. 1.Is there any default username and password for workspace? 2.If not what are the steps to create login and password for workspace? Thanks...

    Malky5 pointsBadges:
  • how i will find the duplicate rows count from employee table in oracle9i.

    how i will find the duplicate rows count from employee table in oracle9i.

    gettosrinivas35 pointsBadges:
  • How to insert/delete/update data into VIEW using forms 6i

    i have created a view like create or replace view emp_dept as select emp.empno,emp.ename,dept.deptno,dept.dname from emp,dept where emp.deptno=dept.deptno; how to insert/delete/update data into the view emp_dept using forms 6i ?

    Mohan24835 pointsBadges:
  • date functions using Oracle

    Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format. ex, select year_mnth,benefits_paid from tablename where year_mnth in ('200603','200602','200601') note:it is in...

    Maha15 pointsBadges:
  • to write code

    i have created a table "stu" in which the following record exists. stu_id,stu_name,stu_course,stu_marks the stu_marks column output is as follows 822 758 789 658 822 879 598 825 589 785 795 795 658 789 988 what i want is to write query or code (function,procedure or anything) that when i execute it...

    Daudkhan5 pointsBadges:
  • my question

    How to find the repeating charactar or letter in a string like 'information' in pl/sql or sql .

    Maneswar15 pointsBadges:
  • PLSQL based method to capture emails from POP server

    I am using UTL_TCP package of PLSQL. I am able to connect to the POP server but I am unable to retrieve any email content. Using the UTL_TCP.available() method, I am getting the returned number of bytes as Zero inspite of their being an email. I tested the telnet commands againt the POP server &...

    Monk10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following