• Oracle Query: Return a date eg 29 February 2008

    Hi How can I return the last day of the second month of the current year in Oracle Thanks in advance

    Csshahie5 pointsBadges:
  • How to pass data from JDE to web page

    There is a requirement wherein data which is on a JDE World screen should be passed to a web page when a function key is pressed. On pressing of the particular function key, data which is on the JDE World screen must be passed to and displayed on the web page. I need ideas about how this can be...

    AS400 - Ask the Expert485 pointsBadges:
  • login persmission Windows Server 2003

    I am trying to log into a windows 2003 server through oracle enterprise manager. I get a wrong username and/or password error. I use the same credentials to login alright when I use remote desktop. Are there any permissions or rights I need to change or grant in the server to be able to login....

    Niimajor25 pointsBadges:
  • Top products in eProcurement field

    I am an Ariba consultant with experience in Buyer,Contracts and sourcing. If I need to change the career to a different application that is in good demand in market and having similar functional knowledge, which are the ones that you would recommend? Could you tell me the SAP products that share...

    Lekha5 pointsBadges:
  • Oracel import question

    what happens if i import a particular table into a user schema which already contains the same table?

    fartman50 pointsBadges:
  • 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:
  • 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:

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