• Sending an email alert to addresses in the database and getting a return email as notification

    Dear Sir/Madam, I have this PL/SQL Store Procedure that sends out email with query result in HTML table format to email addresses in my database but I want to be notified what was the data send to each customer email every time a email is send. Can anybody help me with how to get this done?

    ADagoseh25 pointsBadges:
  • Oracle reports

    What is the method of run\call report on form in Oracle Developer 10g?

    Rat15 pointsBadges:
  • ORA-01002: fetch out of sequence

    We have a procedure in production working but in testing, both are failing: create or replace PROCEDURE Crown_spu (p_nbrec IN NUMBER, p_recordset OUT Crown_Types.Crown_cursor) AS w_batchid VARCHAR2(20); w_nbrec NUMBER := 0; w_seq NUMBER := 0; CURSOR c_feedback IS SELECT Eventid_0, Eventkey_0,...

    MikeBerry15 pointsBadges:
  • Oracle: Count on only one table within select

    I have the following SQL and want to add to the query a count of records for each of the tables selected out of the user_tables, basically count(*). I've tried several things, but am getting only a count of 1. Any help would be appreciated. select substr(a.table_name,1,15) , substr(b.t$desc,1,40) 2...

    nemsmith30 pointsBadges:
  • Stored procedure to transfer data in Oracle SQL Developer

    How can I write a stored procedure to transfer data from staging table to target table in Oracle SQL Developer? stagging table (stagcoindesk) to (coindesk) target table. Was thinking about this code: CREATE PROCEDURE YourProcedure AS TRUNCATE TABLE YourTable INSERT INTO YourTable SELECT * FROM...

    dreamersai5 pointsBadges:
  • Unicode on AS/400 RPGLE

    We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).

    Normap2275 pointsBadges:
  • Tune the Oracle query

    SELECT a.custno, a.stockto, a.dayname, TO_CHAR (a.rad, 'IYYY') || TO_CHAR (a.rad, 'IW') "WEEKNO", a.rad, -- COUNT (NVL (a.load_number_last, a.cono)) "TDY_LOAD_CNT", SUM (a.load_count) "TDY_LOAD_CNT", NVL (TO_NUMBER (b.avail), 0) "TDY_CAP", DECODE (TRUNC (a.rad), TRUNC (SYSDATE),...

    delphi1235 pointsBadges:
  • I forgotten my user name and password of Oracle 10g express edition.

    I'm using oracle 10g express edition, I forgotten my username and password so please suggest me any idea to recover the username and password or tell me any other possibilities to reset the username and password.

    Sreekannan5 pointsBadges:
  • Oracle FK Dependencies

    A query I run accesses multiple tables. One of those tables has a FK dependency on a column, which is populated by the application and hardcoded as a single value for all records. So in the where clause when im joining all the tables to get the data required, it is only pulling data for that...

    Rishik015 pointsBadges:
  • Large NQS_*.TMP files

    Hello,I am BI Developer/Consultant and i am currently cluless on the issues with large NQS_*.TMP files in OBIEE. I am currently on obiee - 11g - 11.1.1.7. I see that after selecting a dashboard report, a NQS_*.TMP file is created in...

    moehashim5 pointsBadges:
  • Cannot reinstall Oracle 10g

    When I successfully removed Oracle 10g from CMD, I tried to install again but it takes a lot time to install and a page. Showing creating and starting database services appears for a long time with same progress bar. It doesn't increase at all? It seems to be paused.

    djmistry5 pointsBadges:
  • SAP APO automation to Financial Planning Systems

    Is it practical to assume that SAP APO can export demand planning information to higher level Financial Planning models? Presently, APO exports huge excel files that finance users need to transform and load into various Oracle Essbase applications.

    ScharrEPMConsulting5 pointsBadges:
  • Procedure to send reminder emails

    I tried executing the below script as procedure, but it throws error as in "PL/SQL: ORA-00942: table or view does not exist". This error is coming on line where I am using dba_users table along with a table in which I have stored the email_addresses. For e.g :- CURSOR c1 IS SELECT...

    sunshine125 pointsBadges:
  • Oracle error ORA-01034 and ORA-27101

    I tired to connect but I'm not able to connect. I'm getting the following error: ORA-01034 - Oracle not available / ORA 27101 - shared memory realm. This is in Windows 7 with version Oracle 11g. I have started it up and mounted it but still not useful for me.

    HEMANT20165 pointsBadges:
  • When did createdBy become a reserved word in Oracle Service Cloud?

    It seems that createdBy is a reserved word in the May 16 release. We just upgraded from November14 and the addition of this field as a reserved word has come as a complete surprise.

    NeilVenn5 pointsBadges:
  • Can’t download Oracle Express in my country?

    Can anyone help me how to download oracle expess in my country. It show this message: Thank you for accessing the Oracle Software Delivery Cloud. Due to your country location, we are unable to process your request. If you have an active support contract, you may request physical media by either...

    yinsambat5 pointsBadges:
  • Rename the Oracle 10g database user

    Hi. I want to rename the database user(username)without deleting the user and again creating in ORACLE 10g database??? plz, help me

    S1989082060 pointsBadges:
  • Oracle SQL: Retrieve data for previous week

    I am trying to retrieve data for the previous week. I need to get the previous week starting on Monday and ending on Sunday. How can I retrieve the data from Monday to Sunday? For example, today is 10-Aug-2016. So, I need details from 1-Aug-2016 to 5-Aug-2016 as week day, and 6-Aug-2016 to...

    rajeshgudla5 pointsBadges:
  • Can I clone a user in the same Oracle database?

    I have the need for a SQL query that will clone an Oracle user. For the source, I already have a user that has the necessary privileges. Would there be a way to clone the user but with a different username in the same database?

    ITKE828,980 pointsBadges:
  • How to clone an Oracle user

    I have to clone an Oracle user but I'm not sure of the process. Is there a SQL query to do this? Basically - this user will have the same privileges but just with a different username. Thank you.

    ITKE828,980 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.

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

Following