• oracle multi-field row query with more than one row

    I have a table that specifies the year, and a quantity for each month, in the same row. I need to get a 12 month rolling average, which involves particular fields from one row, and addition fields from another, based on the sysdate. There are several tables that need to be joined to ensure I have...

    Seashellm150 pointsBadges:
  • Using shell execute from Visual Basic

    How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland

    Rolandsk5 pointsBadges:
  • I need help with how to programmatically backup a database

    I’m trying to programmatically backup a database using the following command: expdp system/system_password directory=dir_exp job_name=jobexp SCHEMAS=my_schema where "system_password" is the actual "system" password and "my_schema" is the name of the schema I want to export. How can I verify in an...

    OracleATE190 pointsBadges:
  • Running Procedures within the PL/SQL program

    WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

    Nimsalwayz5 pointsBadges:
  • calling reports

    i am trying to call oracle 9i report through 9i forms but getting the error: REP-0503 YOU DID NOT SPECIFY THE NAME OF THE REPORT please help me and tell me the complete steps of calling the report through forms

    Majid5 pointsBadges:
  • connect sys as sysdba

    how to connect sys as sysdba in toad software and in isqlplus. When i tried in isqlplus and in toad by connecting as "sys as sysdba" i got the error. please give me a solution.

    Itsee10 pointsBadges:
  • BLOB Data move from Oracle 9i to Oracle 10g

    I want to move BLOB data from oracle9i to oracle 10g through java application. I am getting following error : java.sql.SQLException: ORA-00942: table or view does not exist. Using JDK1.5 & ojdbc5.jar

    AUpadhyay5 pointsBadges:
  • Calling a report from form

    Hello all We recently have migrated from oracle 6i to 9i DS. We have some forms which are calling a report. I have used the run_report_object() instead of run_product() in 9i. Previously the forms were displaying the reports properly. But I have re-installed the windows and oracle due to some...

    Rakh80 pointsBadges:
  • Options available for implementing external account authentication with Windows AD with Oracle on Linux

    Scenario: Windows desktop user logs in to the Windows domain and is authenticated by Windows Active Directory. The same user then lauches a Citrix session to connect to an application running on a Windows Citrix server and is authenticated using Windows passthrough authentication. The application...

    JPGDBA19685 pointsBadges:
  • Oracle 10g, Export problem through OEM

    Hi, i'm trying to export my database and my user is DBA role user, and it has all the roles other than GLOBAL_AQ_USER_ROLE. After specifying all the parameters when i submit the job, it displays the following error. if i do the same steps with SYS user it works fine. "ORA-20204 usr does not exist:...

    SalmanBaig0 pointsBadges:
  • oar-01033

    ORA-01033 and from I understand from reading posts..i'm to log in as sys/password as sysdba. When I do this, sqlplus is returning the error message: ORA -01031 Insufficient privileges. I've tried several different usernames...but SYS should work as i've used this many many times in the past "as...

    Maitreya5 pointsBadges:
  • About oracle editions

    i would like to install oracle 10g in personal desktop,but i saw in oracle site 10g express edition,standard edition and enterprize edition.what was the differences between them and if i want to install which one better?

    80715 pointsBadges:
  • Subquery?

    I used to think I was good with sql as I have used it for quite a few years with informix, but now I am trying to create an sqlplus with oracle and some things are not working the same. I have 3 tables. customer general customer detail location I have used a join to list all the required customer...

    MizzGail85 pointsBadges:
  • JDE World

    How to write a credit memo. Are they made up of line types and doc types?

    Tjm666610 pointsBadges:
  • i need help urgently

    hello fellow IT friends,i just installed oracle10g on window xp, and i cant seem to open my enterprise manager.am a new user of this software can someone help me?

    Iruedo055 pointsBadges:
  • Truncate or not Truncate SQL

    What are the pros/cons of truncate a table export/import to just drop table?

    Jay Dog5 pointsBadges:
  • ASM State in GMON Trace File

    Oracle RAC using ASM: Red Hat Enterprise (RHEL 4.4) I have having problems bringing up a diskgroup in ASM. When I try to mount it, ASM hangs. When I review the GMON trace file, it shows the diskgroup trying to mount and is says "Member state = 4". What's a member state and what...

    Dwaltr900 pointsBadges:
  • view color codes

    Hello... i m beginner in lotus notes and would like to know how to change/set color code to particular row in the view based on formula or condition...?? For ex. if the column value is vacant i have to set green color for that entire row in the view. if the column value is occupied it should red in...

    NotesBeginner5 pointsBadges:
  • What is the PRAGMA_INIT exception?

    What is the PRAGMA_INIT exception? Thank you.

    OracleATE190 pointsBadges:
  • Running RMAN (Oracle Enterprise Edition) over network fails with ORA-12560

    Running RMAN (Oracle Enterprise Edition) over network fails with ORA-12560 - TNS Protocol Adapter error. In RMAN cmd file I've tried re-directing to OraHome with \dev-oraclec$oracleora92 as well as directly to the mapped drive: Z:oracleora92. Both fail with same error. I also set...

    OracleATE190 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.