• 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:
  • Oracle 6i form button

    Hello, I have an Oracle form 6i containing Print Button that print bills, the problem is where I press the button it doesn't work at all for some bills not all of them. Also, when I run the report from report builder it prints well. Therefore, I think the problem is on the button but I don't know...

    musabocp5 pointsBadges:
  • Oracle first or SQL

    Hello Everybody, I would like to learn Oracle. The question is: should I learn SQL before I start to learn Oracle? Why? Thankx Zaid

    Zaid198140 pointsBadges:
  • Oracle r12′s new features

    Does anyone know: What are Oracle R12's new features?

    RonitB15 pointsBadges:
  • Oracle 10g in Windows 7

    Can we be able to install Oracle 10g Express edition in Windows 7 Home Basic of 64 bit Intel i5 processor?

    vivekanandhan5 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