• AS400 to Oracle query

    Can I query a Oracle database directly from AS400 using interactive SQL.Will I need to install any driver or is there a way around?

    Atti123135 pointsBadges:
  • Code Conversion from JDE OneWorld to JDE World

    We are migrating from JDE OneWorld B732 to A7.3, we have some custom objects created in OneWorld. We are migrating these objects from OneWorld to World. Do we have some tools/some helping tool to convert the code from OneWorld to World or it is only feasible manually.

    78910115 pointsBadges:
  • How can i keep sys_guid() unique in multiple table insert

    I want to use unique sys_guid() for insert multiple table but out put are difference sys_guid() drop table T1; drop table T2; drop table T3; create table T1 (ROW_ID varchar2(50)); create table T2 (ROW_ID varchar2(50)); create table T3 (ROW_ID varchar2(50)); insert all into T1 values (NEW_ROW_ID)...

    arnuwan15 pointsBadges:
  • Advise in shifting from Iseries to PL/SQL developer

    Hi, Currently, I am working in Iseries and have 3.5 years of experience as RPG and CL developer. Now, because of the shrinking usage of Iseries I am planning to shift my profession as PL/SQL developer. Could anyone advise whether it will be a wise decision to continue my profession in Iseries or...

    asastr0915 pointsBadges:
  • Parameter Manipulation – Turning ‘abc’ type string into a number

    I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ' - ' || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN...

    tmbdnelson70 pointsBadges:
  • Linking columns from a report

    I want to use the column link tab to transfer the report information to a form for possible update. How can I have 14 fields from a report auto populate a form for update?

    LaTanya5 pointsBadges:
  • JInitiator and StickyKeys

    We are testing our Oracle Forms application for 508 compliance and the following issue came up: The user cannot access the menu with the keyboard when StickyKeys is turned on. I have looked on the Accessibility site for Oracle Forms and it says that Oracle Forms should inherit all operating system...

    StrawberryFields15 pointsBadges:
  • Develop Oracle application by 4GL

    I am a good developer in 4gl under Informix under platform UNIX. I want to transfer to Oracle 10g under Windows 2003 Server. Would you please give me tools to write my own 4gl program in using Oracle database under Windows.

    Hamdyzawam5 pointsBadges:
  • 32 bit to 64 bit Oracle 10g

    Our company is having 32 bit applications (client/server(powerbuilder/oracle) and web (asp.net/php)) connecting to 32 bit server (oracle 10g) . We are thinking of migrating to 64 bit server . Will it be any problem connecting to a 64 bit application with our existing applications(32 bit) Thanks

    5sal5 pointsBadges:
  • Upgrade to Oracle/Intel: Go Linux vs Windows

    We are planning upgrade our main database cluster (rs6000/aix) to Oracle on Intel, research done give a lot of papers from dell, hp, intel that about roi of moving out of risc/unix but there is no clear evidence about performance issues between LINUX and Windows Server as the selected OS. Do you...

    Romerogt0 pointsBadges:
  • $$PLSQL_UNIT

    Dear All, I know that using the $$PLSQL_UNIT, I can get the current procedure executing. but there is a problem when i use it to get the procedure name inside the package. it only returns the Package name not the procedure name. How can I get the PACKAGE.PROCEDUE_NAME? Please help. Ahmad Saeed...

    AhmadSaeed5 pointsBadges:
  • Cannot connect to Oracle listener on Virtual PC

    Hi all, from my Win7 host, I cannot connect to port 1521 for Oracle 11g SE running under a virtual PC running in XP mode. Neither SQL-Plus nor SQL Developer get a connection, although the db is running and locally reachable as tested with SQL-Plus on the guest system. SQL Developer says ”The...

    TheLibran15 pointsBadges:
  • Oracle10g,VB6.0,dell-laptop,connection error

    I have a Dell-Inspiron. when I try to connect VB 6.0 and Oracle 10g, I get a TNS error. I have been getting this error for other dell laptops alone. What change should I make?

    incessear5 pointsBadges:
  • About search button

    How can I add search (torch) button on my custom oracle form?

    umesh444chavan5 pointsBadges:
  • Can anyone tell me what is the difference between oracle 10g and oracle 11g in way of comparison

    Please, can anyone tell me what is the difference between Oracle 10g and Oracle 11g in way of comparison?

    161220 pointsBadges:
  • create messages

    How do I create messages in oracle 10g using developer 6i?

    mamatos310 pointsBadges:
  • Ora error

    Hi, when Exporting one of the Tables I faced with these errors: EXP-00056: Oravle error 12801 ora-12801: error signaled in parallel query server p003. ora-00028: your session has been killed. I appreciate if you would help me.

    yara858750 pointsBadges:
  • Connect VB6 with Oracle 10g

    How to connect VB6 with oracle 10g with source code?

    itravi5 pointsBadges:
  • Complex sort for SQL Query?

    I have a table: MY_TABLE IDENTIFIER (VARCHAR) NAME (VARCHAR2) DATE (DATE) SELECT NAME, IDENTIFIER, DATE FROM MY_TABLE ORDER BY IDENTIFIER, DATE; So that works great for ordering the identifiers (basically making them look like a grouping in the output). Then sorting them by date (makes it sort...

    KGNickl50 pointsBadges:
  • How to change page length of report?

    Im trying to create report in reports6i and I just want to know how to adjust the page LENGTH from 66 to 56.

    bluebird1075 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