• STRQMQRY: The variable should appear without quotes

    In my cl the strqmqry I am passing 2 variables that are character but should be numeric when the query runs.............now they have the quotes around them.................how do I get the quotes out of there so they are treated as numeric????

    Harrigan5 pointsBadges:
  • Need to save dates in Oracle Forms 10g without modifying data values

    I am trying to save date and time as entered by the users example: In the insert and update triggers of my block my statement is: :MAIN_BLOCK.USER_DATE := TO_DATE(TO_CHAR(:MAIN_BLOCK.USER_DATE,'DD-MON-YYYY')||' '||:MAIN_BLOCK.HOUR||':'||:MAIN_BLOCK.MIN||':00 '||:MAIN_BLOCK.MERIDIAN,'DD-MON-YYYY...

    Starletmyra15 pointsBadges:
  • Suggestions for modern replacement of AS/400

    We are looking to retire our AS/400 machine, what is a suitable replacement? Our aging AS/400 machine is on its last legs. What modern system is a good fit? We have Oracle data on it for our front end server. Everything is backed up to tape library.

    ITKE342,835 pointsBadges:
  • Developer 2000 error- program too large

    how do i increase the size of developer 2000 form 5.0 using when button pressed trigger coz when compiling i m getting error program too large n if the answer is defining subprogram then tell me stepwise answer.

    Ktktkt10 pointsBadges:
  • Sponsor Post: Join Us for the Identity Access Management Live Expert Chat on 7/20 at 11am ET

    To compete in the new economy, organizations need to provide efficient and secure access to their internal applications and data for external entities, such as business partners, customers, and mobile employees. Join Microsoft's Senior Technical Product Manager, Brjann Brekkan, on July 20 from...

    ITKE342,835 pointsBadges:
  • Oracle Forms and Reports

    I would like to know whether is there any web site which offers free practice exercises on Oracle Forms and Reports?

    Genie5 pointsBadges:
  • How to prepare for OCA

    I want to become a DBA .can you please advice me how should i proceed ?Should i start with giving certification exams?

    Poojamalik5 pointsBadges:
  • Sponsor Post: Secure End Point Live Expert Chat – Tomorrow @ 11am ET

    Join this expert chat tomorrow, July 13th from 11am-2pm ET, to learn how Microsoft Forefront solutions protect client and server operating systems from emerging threats and information loss, while enabling more secure access from virtually anywhere. Click here for reminder email to access the...

    ITKE342,835 pointsBadges:
  • Oracle Financials

    what is market for oracle financial, because i plan to study the orcale financial already studied the sap. can i study or improve the knowledge in sap. please help

    SEKARVALAR55 pointsBadges:
  • How i want to save image from directory to database oracle using php ?

    How i want to save image from directory to database oracle using php ?

    PHP1235 pointsBadges:
  • Sponsor Post: Cloud Migration Pros and Cons Live Chat Today

    Today's live chat from 1-3 pm EST provides an exclusive opportunity to get your cloud migration questions answered directly from industry experts. Get tips on how to improve your ability to recover in any type of loss or disaster while keeping your budget in check and gain insight into: Data...

    EmNichs3,250 pointsBadges:
  • Oracle-developers

    WHILE ASSIGNING A VALUE TO PROCESSED_TIME=:NEW.JMS_TIMESTAMP-:NEW.INS_TIME (All are timestamp type ) how to subtract that one.  CREATE OR REPLACE TRIGGER SAUUSER.TRG_MSGES_STATISTICS AFTER UPDATE OR UPDATE ON SAUUSER.TSAU_PRE_MSGES REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE BEGIN IF...

    RizwanSharief30 pointsBadges:
  • Oracle Bandwidth requirements

    Please can you advise what Bandwidth requirements are necessary to implement Oracle R12 for HR/Payroll/Projects & Finance?

    Requirements5 pointsBadges:
  • make an id in oracle 8

    i m the user of oracle 8i..i want to make an separate account in oracle.. how i can make an account..please tell me if u knoww..  

    Mayu30 pointsBadges:
  • we are using a oracle D2k 6i based software and by mistake some one has changed a .fmx patch to open with notepad. Can I recover the files affected?

    we are using a oracle D2k 6i based software and by mistake some one has changed a .fmx patch to open with notepad and now all the files with such extension has been changed. so please tell me how to recover the file.

    Belli10 pointsBadges:
  • Error – FRM-18103:

    Hi, I have installed Oracle 11g Database and installed Oracle Developer suite 10g .. Error - FRM-18103:Failed to initialize the Development Environment I have installed Oracle 11g and Oracle Developer Suite 10g in separate oracle homes. When I try to open Oracle form builder I am receiving...

    Senthil1235 pointsBadges:
  • ORACLE-TRIGGERS

    Hello, im going to create a trigger(insert or update) for a tableA, when it fires inserted or updated columns are should be insert or update into another table say tableB, one column(Processed_time) in tableB where its value will be by subtrcting two columns in tableA(response_time,Submission_time)...

    RizwanSharief30 pointsBadges:
  • ERROR -HTTP Listner is not running on RAHULDEOLE.rahul at port 8888.PLEASE STAR THE LISTENER OR CHECK YOUR UNTIME PROGRAMS

    Hi Friends, I have an error while running Oracle Forms 10 - HTTP Listner is not running on RAHULDEOLE.rahul at port 8888.Please start the listner or check your runtime program? Help will be appericable,it will saves time. RAHUL DEOLE

    RAHULDEOLE75 pointsBadges:
  • Getting the error unable to perform query ora 00904 on an item of previous form which is already deleted.

    using oracle 6i i save as a form to make another one and deleted all the items,triggers and other programme units,lovs from it. I added new items and new data source to its block. But its giving the error unable to perform query ora 00904 on an item of previous form which is already deleted. I have...

    Mariaali10 pointsBadges:
  • r47011 performance 9.0: Anything new in 9.0 that would cause R47011 to run incredibly slow

    Anything new in 9.0 that would cause R47011 to run incredibly slow

    Brmk10 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