• 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:
  • 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:
  • how can i resolve oracle error 00103

    I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP. CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCHER WHERE BUSINESS_UNIT=...

    150919745 pointsBadges:
  • batch queries in oracle

    We are developing a .NET web application and have decided to use CSLA as our business architecture framework. Because CSLA is based on Microsoft technology, it is designed to work with MS sql. Much of the framework uses batch queries to grab multiple result sets in one query but it appears that...

    Dhworth5 pointsBadges:
  • SQL query ORACLE report “Active Users”

    I have problems analysing the standard Oracle report "Active Users". I want to get my users into excel but the report lay out sucks. How can i get this report directly from the database?

    Jkort5 pointsBadges:
  • ORA-02068 and 03113

    I have dblink in local database 10.2.0.3 pointing to remote database 9.2. There is a view in local database which is based on tables on remote database using dblink. When I run the select on that view, it fails with ORA-02068 and 03113. It works intermittently. It works most of the time with less...

    Skkumar25 pointsBadges:
  • SQL Plus

    I have a subquery that works but I need to change some parameters. Specifically 2 fields in a different table. When I do, using aliases, it stops working, "Invalid Identifier". The first select gets all the fields from 2 tables then the subquery uses the 2nd table. Table B has some fields as well...

    Gator255 pointsBadges:
  • Oracle Reference to Table_Name, Column_Name, etc by reference to variable

    Does Oracle prohibit reference to Table_Name, Column_Name, etc by reference to a declared variable? I am trying to create a simple routine to print documentation whenever any changes are made to the database using the following routine: DECLARE CURSOR Table_cursor is SELECT * FROM TABS WHERE...

    Sweetpea0 pointsBadges:
  • constraints

    sir ,how can we find tables those which are related each other exactly(while training) not apps tables ,simply in 9i db environment(user defined tables)

    Maneswar15 pointsBadges:
  • how can i update ?

    when update in form (master_details) in details block i found error frm-40735 when button pressed trigger raised unhandled exception ora-00001

    Camba5 pointsBadges:
  • JDE GL Accounts

    How do you add GL accounts in JDE?

    Cathykcsoft5 pointsBadges:
  • Host Credentials

    whenever i use enterprise manager to perform backup or other functions on my laptops it usually requests for host credentials.whenever i give it my operating systems credentials it gives me an error message.what could be the problem?Nothing can be done with the enterprise manager without using the...

    Diamond105 pointsBadges:
  • oracle form:export to excel

    I have an oracle form,i need the code of a function that exports a given SQL query into Excel sheet on a button click action.

    Itbassem5 pointsBadges:
  • ORA-1034: Oracle is not available error with SQL Plus

    I had installed Oracle 9i in Windows XP Professional Edition. Whenever I start SQL plus(GUI) it says, ORA-1034 error, "Oracle is not available, Shared memory realm does not exist" In the services I saw that an associate database service is running. Thank you.

    OracleATE190 pointsBadges:
  • Items in Pending Transactions of Inventory Module

    Hi, We have items in Pending transactions of Inventory Module, they cannot be progressed because The Sales order is already cancelled. The problem is our item reservable is decreased because some of the items were stuck in pending transactions. I tried to use this but it did not work : i2471362.sql

    Execute5 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