• Replace a variable part of a string in a varchar2 field

    I have a vendor Oracle table containing data as follows column name: PVC_Value value = TRKCASETRK;6,0,0,0,0,0,0;;20801911;32004910;43175007;2,2;0;59647;1,30;0;0;3002 As you can see this field contains data delimited by semi-colons (for 13 elements) I need to relace the 7th and 10th elements in this...

    JoeA15 pointsBadges:
  • Page Down/Page Up Lockup in P9612 (Function Keys Security)

    Hi there, can anyone pls enlighten me on whether it is possible to "lock" the scroll up/scroll down function keys on a certain program screen in JDE World version (A7.33). For example, I don't want users to be able to display the next records in P4310 screen when they pressed the page/down or page...

    Vher5 pointsBadges:
  • Oracle E-Business Suite R12

    Can Oracle E-business Suite R12 run on-line real time like SAP?

    Coordinate5 pointsBadges:
  • Oracle Reports duplicate labels

    Using the oracle reports mailing label style, i would like to print an entire sheet of labels using the SAME record. each record prints an entire page of duplicate labels. best way to do it?

    Mgable5 pointsBadges:
  • Updating Microsoft SQL Server tables from Oracle generates error

    i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: "NAME": invalid identifier.

    Balecha10 pointsBadges:
  • Want to know about Oracle Reporting

    Can anybody tell me sth about ORACLE report generation using Oracle 8i ?

    ProgrammerCETENoida10 pointsBadges:
  • relationship between two or more forms in DS10g

    i want to create relationship between two or more forms in DS10g for example i want acces one field like Emp_ID on other form how can i do?

    Rat15 pointsBadges:
  • Errors: Violation of UNIQUE KEY constraint ‘UN_FILENAME’. Cannot insert duplicate key in object

    when i am migrating data from oracle9i to SQL2005 i am getting the error Errors: Violation of UNIQUE KEY constraint 'UN_FILENAME'. Cannot insert duplicate key in object how should i solve the problem

    Lava5 pointsBadges:
  • install oracle 8i with ram more than 2G

    I get error while i try to install oracle 8i like unable to calculate memory

    091554214745 pointsBadges:
  • automate Oracle database backup on Windows 2000 server

    Hello, I have to make a cold backup of our test database. The database is oracle 8.1.7 on a Windows 2000 server. I have made bat files to do this and have scheduled them in the Windows scheduled tasks application. This works fine. I check to see if my jobs have run successfully by looking the the...

    Mariane10 pointsBadges:
  • Spooling Oracle Output via SQL DTS

    I am able to execute a stored procedure that resides in a database on an Oracle server via a DTS Package on a SQL Server. I would like to be able to spool the output to a .log file on a different server. Is this possible using DTS?

    Broskek5 pointsBadges:
  • Migrating from Sybase to Oracle 10g

    I know the a little more than the basics of DBing but not as much as an OCA or OCP. I need to know how to migrate data over from Sybase to Oracle 10g on a very large scale! Please help! I do not want to use a conversion software because there are many updates to the Oracle architechture already....

    BasicDBA5 pointsBadges:

    I am trying to do an update statement with a where clause that has a number table column in a string list. The string when displayed is ####, ####, ####; with no quote marks. This is in a when-button-pressed trigger in a form. It appears to work when the list only has 1 number in it, but returns...

    Papalpha5 pointsBadges:

    I'm in an upgrade project from 11.5.7 to 12.0.4, the client has some major customizations using the existing link between MTL_MATERIAL_TRANSACTIONS and GL_INTERFACE like the reference21 in GL_INTERFACE = batch_id in MTL_MATERIAL_TRANSACTIONS and the reference23 in GL_INERFACE = TRANSACTION_ID in...

    Tanque5 pointsBadges:
  • Oracle EBS pritner

    Why printers connect to EBS often disabled? It looks like in a couple of day an Oracle user will report she can't print a check or a report. EBS=11.5.10, Linux, 9i.

    QAQA65 pointsBadges:
  • Oracle initialization error while running Java files

    I am facing no issues while compiling the java file. However while running the same, I am facing the following error. java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress. Any pointers for the same?

    JagdishK5 pointsBadges:
  • How can we startup our DB if any one redologs is corrupted totally 2 redologs

    how can we startup our DB if any one redologs is corrupted totally 2 redologs.the corrupted redo is in archivemode.1st redo is corrupt tat is in current use of archive mode

    Kkvsaathish5 pointsBadges:
  • I would like to know the procedure name

    How to know the procedure name of itself? for example, ------------------------------ create or replace procedure my_proc1 is begin dbms_output.put_line (' procedure name =>' || xxxxxx ) ; end; ----------------------------- i want to print 'my proc1' as procedure name through...

    Gregori15 pointsBadges:
  • ORA-12560: TNS:protocol adapter error

    I recently downloaded Oracle Designer from oracle website. When I use the default username and password, it give me the following error ORA-12560: TNS:protocol adapter error RME-00220: Failed to connect to Repository What should I do to solve this problem

    Develolper5 pointsBadges:
  • Urgent Help

    I have some doubts related to oracle database..... I am in ECC 5 implementation project (OS: Windows, DB: Oracle) My Question....... After Installing ECC 5 the default database size is around 50 GB, some 300 GB HDD is allotted to database , the client is saying to utilize the remaining 250 GB (300...

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