unable to install Oracle 10g in Windows 7
How can i install unable to install Oracle 10g in Windows 7

Answer Question   |  July 20, 2010  5:26 AM
Oracle 10g, Oracle 10g administration, Oracle installation, Windows 7, Windows 7 in 2010

Large number rounding in Oracle 10g
Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code.  When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some reason the number rounds up. For example if the [...]

Answer Question   |  July 19, 2010  8:27 PM
Oracle 10g administration, Oracle 10g Database, Oracle database administration, SQL Plus, TOAD

Inserting parent and child tables at a time
Is there any way to insert parent and child tables data with select statement? On record in parent table and n number of records in child table. Please let me know if possible.

Answer Question   |  February 22, 2013  6:41 AM
Oracle Database, Oracle Statements, TOAD

Migrating from Microsoft applications to Oracle
How can I easily convert my SQL 2005 databases to Oracle’s latest iteration? We are moving away from Microsoft applications and want to migrate to Oracle. What do I need to do to prepare?

Answer Question   |  July 15, 2010  6:10 PM
Oracle Application Server, SQL 2005 Database, SQL Server 2005, Windows Application Server

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 HH:MI:SS AM’).  I am trying to save :MAIN_BLOCK.USER_DATE as “25-MAY-2010 11:00:00 AM” as the user entered in the form textboxes and is saving “25-MAY-2010 [...]

Answer Question   |  July 15, 2010  3:12 PM
Database management, Oracle 10g Database, Oracle 11g Database, Oracle Forms 10g

Best practices of RAID configuration of StorEdge HDS 9960 and Oracle 10g R2
Hello, What are the best practices of RAID configuration of HDS 9960 storage and Oracle. Currently we are using now Mirroring RIAD 1+0 with 4 disks (2+2). will the second option of Mirroring 4+4 give us better performance than 2+2 disks? Thanks in advance. P.S. the Oracle instance is OLTP.

Answer Question   |  July 29, 2010  11:28 AM
Database mirroring, HDS 9960, OLTP in Oracle, Oracle 10g, RAID, RAID configuration

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.

Answer Question   |  July 15, 2010  8:16 AM
Oracle Developer 2000, Software performance, Subprogram

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????

Answer Question   |  July 15, 2010  9:33 PM
AS/400 Query, Query Manager, STRQMQRY

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 11am-2pm ET  for Microsoft Business Ready Security – Identity Access Management. He [...]

Answer Question   |  July 14, 2010  3:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange server software, Identity and access management, Linux, Lotus Domino, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

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.

Answer Question   |  July 15, 2010  5:27 PM
AS/400 upgrades, Oracle Database Migration, Tape Backups, Tape libraries

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 expert chat.

Answer Question   |  July 12, 2010  2:27 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Endpoint security, Exchange server software, Linux, Lotus Domino, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

convert oracle reports to excel
How do i corvert oracle reports to excel

Answer Question   |  July 8, 2011  10:35 AM
Data conversion, excel, Oracle Reports, Oracle Reports Builder

How to connect to database inside VMWare from the web applications
Hi All, I have VMWare in my desktop which contains the Oracle database. And in general my desktop is in network with the server having web based applications. Now I want to fetch the data from this VMWare database in my application. Can we establish JDBC connection from the application to this database. Can we [...]

Answer Question   |  July 21, 2010  12:34 PM
DSN connection, Java Database, JDBC, Oracle Database, VMware, Web Dynpro

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

Answer Question   |  July 6, 2010  7:11 PM
Oracle 12, Oracle Bandwidth Requirements, Oracle installation

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 INSERTING THEN INSERT INTO TSAU_MSGES_STATISTICS(PORTCODE,MSG_ID,DOCTYPE,MSGTYPE,SUBMISSION_TIME) VALUES(:NEW.PORTCODE, :NEW.MSG_ID, :NEW.DOCTYPE, :NEW.MSGTYPE, :NEW.INS_TIME ); END IF; IF UPDATING [...]

Answer Question   |  July 7, 2010  11:50 AM
Oracle applications, Oracle developers, Timestamp, TOAD

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

Answer Question   |  July 6, 2010  2:03 PM
Oracle 8i, Oracle administration

Oracle data missing, over 500GB worth.
Instance of Oracle on HP-UX 11.11, Oracle version 9.2.0.8, has lost hundreds of GB of data. Manual/accidental deletion is not possible as the process would take a long time to execute. Error logs do not show much, AUD$ log doesn’t show any user activity during the window of time (roughly 24 hours). an ORA-1650 error [...]

Answer Question   |  July 20, 2010  8:45 PM
Oracle 9, Oracle administration, Oracle errors

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.

Answer Question   |  July 2, 2010  8:10 AM
D2K 6i, File recovery, FMX, Oracle 6i, Patch management

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) all are timestamp type how to update(Processed_time) in tableB by [...]

Answer Question   |  July 1, 2010  11:46 AM
Oracle PL/SQL, Oracle SQL Developer, Oracle triggers, SQL Trigger

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

Answer Question   |  July 1, 2010  7:01 AM
Oracle Database 10g, Oracle developers, Oracle Forms 10g, Oracle Forms Error Messages