• Discuss the impact of Oracle-Sun with your peers and SearchOracle.com Editors

    Oracle has announced that it has reached an agreement to acquire Sun Microsystems for $7.4 billion. Please use the discussion comments below to discuss the Oracle/Sun deal with fellow members and the SearchOracle.com editors. Please use the Add to Discussion button (not the answer section) to...

    OracleATE190 pointsBadges:
  • How To execute procedure

    I have procedure iven below Output of the procedure below is multiple rows but i am getting only 1st row how to use concept of SYS_REFCURSOR over here CREATE OR REPLACE procedure Vishal_PROC_sp1 (kpiid in number, val1 out varchar2, val2 OUT Number) as cursor c1 is select...

    Hanrahul85 pointsBadges:
  • Oracle 10g process each record exactly on time multiple processes

    I have over 400 records added to a table in a minute. A processed flag is set in each record as they are processed. I want to process each record exactly one time. I want to process the records in small groups with multiple processes; that may run on disparate machines. It is desirable to process...

    Wileecanislatrans15 pointsBadges:
  • Conecting Oracle through dynamic IP

    I want to connect 2pcs's having oracle 9i (sever version) installed in them ,through a broadband connection(ie. a dynamic IP). Can any one show me the way.

    Meettan5 pointsBadges:
  • Oracle Reports 6i mask

    Oracle Reports 6i mask

    Aziiz6005 pointsBadges:
  • How number of processors correlated to Oracle database size

    Is there a guideline to determine how many processors to use (in unix OS) according to the Oracle database size?

    62625 pointsBadges:
  • calling reports in pl/sql code

    how to call reports 6i report from pl/sql code procedure in pdf format

    P0095 pointsBadges:
  • how to send email from oracle report 6i

    how to send email from oracle report 6i separate page for each employee e.g employee pay slip?

    Dsf5 pointsBadges:
  • convertion of excel into report generating tool

    how to convert excel sheet into oracle report generating tool

    Ar5 pointsBadges:
  • Validation error in Oracle10g

    If I try creating additional listener. It will opt for my OS credential(system username and password) and each time I enter it, it will give me this error"Validation error" and followed by another error message "oracle executable manager stopped working and was closed". please what will I do? How...

    TUMUCH5 pointsBadges:
  • Oracle EE Named User Plus Licensing

    I want to license 50 users (NUP) on 2 new Oracle systems (on separate servers). Because of Named User Plus minimums on each server I require: 100 NUP licenses (for server/system 1 & 50 NUP licences for system/server 2) - Total 150 NUP licenses. My question is, how should this model take into...

    Davidpbarrett5 pointsBadges:
  • Is the Oracle client 9 compatible with Forms 6i

    We have a conflict between windows 2003, citrix and oracle forms 6i and have over come this by installing client 9.2.0.1.0 however I don't believe this is a supported combination and need to know what problems we may encounter

    Dizzy5 pointsBadges:
  • Query for tab canvas block

    I have a Form with a tab canvas for the detail and a multi row master block. when scrolling through the rows in the master block the detail block (tab canvas) isnot executing the query (only by steping on the detail block is the query preformed)

    Ifatgat5 pointsBadges:
  • excuting sql loader from runrmtcmd from as400 to unix

    I am tryint to execute a sql loader process on a Unix machine from the AS400. Here is the code, RUNRMTCMD CMD('cd /home/dekbf/e3data;$sqlldr ekbf/ekbf + control=EPINTORD2CTL.CTL') RMTLOCNAME('191.0.0.9' + *IP) RMTUSER('dekbf') RMTPWD('ekbf') Here is the error returned, ksh: ekbf/ekbf: not found.

    Rzierler5 pointsBadges:
  • Oracle SQL question

    I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't like...

    Wanderer95775 pointsBadges:
  • Oracle Communication between 11g and 8i

    We are considering upgrading one of our database from 8i to either 10g or 11g. We know currently that the 10g client is compatible with 8i communication because we have two performance tools database(GRID and I3) which are 10 and they appear to have no issues. However we were wondering if there is...

    Kantermark5 pointsBadges:
  • Would like to upgrade to 10.2.0.4 from 9.2.0.7

    Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks

    Kanif15 pointsBadges:
  • Multiple Tables to Bulk Import .sql script

    I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select multiple...

    ADMIntegrated5 pointsBadges:
  • Can I run Seconds on an Alert in Oracle Forms 6i

    I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.

    SuperRad40 pointsBadges:
  • Database

    How do I create an oracle database?

    PSS10 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