• Update table to remove invalid char type (tab) Oracle

    I need to update a table I have in oracle that has an invalid character type in it. It looks like it is a tab character. Can someone give me a script to update this field in the table to remove a tab character from a field and replace it with a space - I assume? Very few rows have this 'bad' data...

    Meb10 pointsBadges:
  • Embedded SQL in a Cobol program using a sub-select in the select clause

    The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = SB_CURRICULUM_STR.F_LEARNER AND SOVLCUR_CURRENT_IND = 'Y' SSRMEET_ROOM_CODE FROM SSBSECT, SSRMEET, SGRSPRT WHERE...

    Warpmail5 pointsBadges:
  • CREATE BACKUP OF SPECIFIC DATA IN ORCALE DATABASE USING JAVA COMMAND OR PROCEDURE

    RESPECTED SIR, i am doing a project. My front end is java and back end is oracle. In my project i stored data in oracle. but I want to create it's back. plz give my a procedure in java to create backup of my data file. which is operate from java front end.

    Juned5 pointsBadges:
  • forms 9i help

    hey , i want to know is there any way to change the java window applet size by any built in and change the oracle picture as well as toolbar.so plzzzz let me know its kind of urgent... thanks in advance nishant

    Nishant835 pointsBadges:
  • Oracel 9i Undo

    How can i determine if the undo is setup properly and how can i determine if it is online

    fartman50 pointsBadges:
  • 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:
  • Build 09.00.3239.00 (cumulative update)

    I just patched my servers to this build and noticed that the time used to 'Delete files based on the age of the file at task run time' within a maintenance cleanup task is screwed up. Hours become days, days become weeks, weeks become months when the Maintenance Plan executes. Anyone else noticed...

    Kurthp195 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 10.2.0.3 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:

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