• 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?

    ITKE434,520 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.

    ITKE434,520 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • Remote printing on Micros software

    When using Micros software by Oracle and printing remotely using Logmein, specifically running and auto sequence report, the report appears correct on the screen, when printing however, garbage prints.

    mwelsh5 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:
  • Which Oracle course should I take for my career?

    I know SQL and PL/SQL (beginner). Which else course should be advantage to get a job as a fresher? Should I do Oracle APPS(ebs)?

    gyana20105 pointsBadges:
  • Interface DB2 to Oracle

    Dear all, I  have an 02 database (Oracle database 11 and DB2). I'm using inquiry command SQL in DB2 select about 2 million records very fast but interface to ORACLE by Database gateway transaction process very slow. Please give me reccommend or doccument. Thanks for help

    Hvphong031160 pointsBadges:
  • How do I solve the ORA-00933: SQL command not properly ended error message?

    For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

    ITKE434,520 pointsBadges:
  • OU not appearing in LOV while creating Inventory Organization

    Hi, I've created the Operating Unit from Accounting Setup screen and this is not visible from Organizations form. Also, when I'm trying to create the Inventory Organization from Inventory-> Setup -> Organizations-> Organizations Operating Unit is not appearing in the LOV. I've setup the...

    aanchi885 pointsBadges:
  • Which career to choose: SAP FI or Oracle E-Business Suite

    Hi My name is Amol from PUNE and I have completed my B.Com with ICWAI Intermediate and currently in the final stage of giving attempts of final exam. I'm also working in a company in the Finance department for the past 2 years & 9 months. I want to know which course I should pick up...I'm...

    khatokara5 pointsBadges:
  • rep-002

    I am getting error "rep-002:Unable to retrieve a string from the report builder message file " while opening a existing report in Reports 9i...How to solve this?

    Yegneshv5 pointsBadges:
  • How to create multiple Oracle 11g databases

    Our department is currently using Oracle 11g and all of us are using it (including developers). But here's the issue - we can't buy several different licenses for each person. Would I be able to create one specific data for each person?

    ITKE434,520 pointsBadges:
  • Free Oracle Assessment Exams

    Can someone tell me where I can find free Oracle Assessment exams in preparation for Oracle certifications?

    Stewary5 pointsBadges:
  • Setting Oracle database to auto-commit

    Is there a way for me to find out if my Oracle database is set to auto-commit? If it is, how can I turn that off too? Thanks!

    ITKE434,520 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