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
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
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
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
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
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
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
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
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
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
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
How do i corvert oracle reports to excel
Answer Question | July 8, 2011 10:35 AM
Data conversion, excel, Oracle Reports, Oracle Reports Builder
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
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
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
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
Instance of Oracle on HP-UX 11.11, Oracle version 18.104.22.168, 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 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
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
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