how to access fields of table along with their datatypes in oracle
Dear Oracle gurus I am using oracle 9I. i want to access fields of table along with their datatypes at runtime.. to see structure of table ‘desc’ command i used.. but at runtime how i can know datatypes or fields of a table. Thanks in advance Shailesh

Answer Question   |  July 1, 2008  10:09 AM
Developer 2000, Oracle 9i, Oracle Developer 2000, Oracle development

Update deactiviting and throwing ora-600 error
ORA-00600: internal error code, arguments: [25012], [5], [524], [], [], [], [], [] Current SQL statement for this session: UPDATE “JEST” SET “INACT” = :A0 , “CHGNR” = :A1 WHERE “MANDT” = :A2 AND “OBJNR” = :A3 AND “STAT” = :A4

Answer Question   |  July 2, 2008  8:52 AM
ORA-00600, Oracle development, Oracle error messages, Oracle SQL

Anyone Have Experiences With Running Oracle in a Sun Solaris Container/Zone
We are a SAP / Solaris environment. We thinking about virtualizing our SAP environments as part of our upgrade to ERP 6.0 using Solaris Zones/Containers. There are two schools of thought as far as the database instances; virtualize the Oracle instance along with the SAP instance or seperate the ORacle databases onto a single physical [...]

Answer Question   |  June 30, 2008  2:13 PM
Oracle, Oracle 10g, SAP, Solaris, Solaris 10, Virtualization

Community Update: New Contest Announcement.
Now is your chance to win an Amazon gift card based on your activity in the IT Knowledge Exchange Community. Remember: the more you ask, answer or discuss questions, the more Knowledge Points you will earn. This is how the contest works: The top 10 most active members from now until the end of July [...]

Answer Question   |  July 31, 2008  1:40 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Storage, Virtualization, VoIP

oracle 10g v sybase ase 15
what are the differences between the two products relating to cost, integration, database size, number of concurrent users, performance and features

Answer Question   |  February 23, 2011  11:48 AM
Database, Oracle 10g, Sybase ASE 15

Oracle/Unix What are the advantages of automated testing tools for oracle database on a Unix Solaris environment?.
What are the advantages of automated testing tools for oracle database on a Unix Solaris environment?.

Answer Question   |  July 8, 2008  3:29 PM
Oracle, Oracle performance, Unix, Unix Solaris

Need career advise ORACLE or SAP?
Hi everybody, I am CPA Candidate and live in texas usa. Now a days, lot of companies ask me questions like: do you know oracle financial? Do you know SAP blah blah. People suggesting me to learn these software skills & I know nothing about these fields. Please suggest –where from I should start career [...]

Answer Question   |  December 28, 2010  6:24 AM
IT careers, Oracle certifications, SAP careers

Compile Forms 6i 32 Bit in Oracle 9i 64 bit
When I try to compile .fmb file using forms builder (Forms [32 Bit] Version 6.0.8.11.3 (Production) ) against Oracle9i Enterprise Edition Release 9.2.0.7.0 – 64bit Production, while compilation is going on, window is getting closed, no error is either getting displayed or error file is generated.

Answer Question   |  June 27, 2008  2:28 AM
Oracle 9i, Oracle 9i Enterprise Edition 9.2.0.7.0, Oracle Forms, Oracle Forms 6i

BW load performance
BW data load performance using Oracle 10g and windows 2003 env. how to improve CPU, DB, dialog response time? any notes for Oracle patches, SAP any notes?

Answer Question   |  June 26, 2008  3:05 PM
Oracle 10g, SAP BW, Windows Server 2003

3 tier character report printing not possible in 10g
i made a character report in 10g , if i run in report builder then its printing is fine. but when i print report using 3 tier (using pdf format) then all setting are disturbed.

Answer Question   |  June 26, 2008  3:47 AM
Oracle 10g, Oracle developers, Oracle Reports

sql quries
i m a beginer in computer science.so how can i make grip on oracle sql plus is there any website or any electronic book that contains preset quries on sql which can help me in working in sql i want a guide book which has quries to start and work in sql plus and developer.

Answer Question   |  June 26, 2008  1:21 AM
Oracle, Oracle SQL, SQL Query, SQLPlus

Export parameters TABLESPACES, TRANSPORT_TABLESPACE in Oracle 9i
Do we need to set the parameters TABLESPACES, TRANSPORT_TABLESPACE to export table spaces and transportable table spaces meta data even when the parameter FULL = y. Please suggest me what to do for this case.

Answer Question   |  August 23, 2008  5:53 AM
Oracle 9i, Oracle 9i export parameters, Oracle import/export, TABLESPACES, TRANSPORT_TABLESPACE

Microsoft Access and Oracle
Can tables created in Access or Excel be imported into Oracle?

Answer Question   |  June 24, 2008  8:49 PM
Access, Microsoft Excel, Oracle, Oracle import/export

People Soft
Is there a People Soft Tutorial available?

Answer Question   |  June 23, 2008  9:45 PM
PeopleSoft, Tutorials

Looking for the user interface in SQL Server 2005 Developer Edition
I just installed SQL Server 2005 Developer Edition and I can’t find the user interface. I’m looking for the place I’d type queries as I did in SQL Server 2000 Enterprise Manager. Where can I find the UI?

Answer Question   |  June 23, 2008  3:28 PM
Enterprise Manager, SQL Server 2005, SQL Server Enterprise Manager, UI, User Interface

Most common oracle DBA tool.
which tool is most common for database(oracle) administration , instead of OEM?

Answer Question   |  September 12, 2008  3:19 AM
Oracle administration, Oracle DBA

How to capture emails with attachments from the POP server using Pl/SQL ?
I am able to retrieve emails from POP server using UTL-TCP package of PL/SQL. I am also able to retrieve Attachment with the email, but the contents of the Attachment are displayed as some random string of characters. Can anyone tell me how can I access the contents of the Attachment in understandable format ?

Answer Question   |  June 26, 2008  5:06 PM
PL/SQL, POP server, POP3, UTL-TCP

Nested SQL with multiple table join does not work with wildcard searches
Dear sir(s): Currently I am working with iBatis with Oracle 10g as the backend. I have a number of jsps or Web pages which take various input parameters in the format of #xxxxxxxx# where xxxxxxxx represents the dataitem from the Javascript. In my sqlmap, there is a complex join involving nested SELECT statements. The nesting [...]

Answer Question   |  June 18, 2008  12:46 PM
iBATIS, Object Relational Mapping, Oracle 10g, Oracle development, Oracle SQL, ORM, Wildcards

How to call a report made in Reports 6i into a Forms 6i Form.
I need to call a Report made in Reports 6i into a Form made in Forms 6i.

Answer Question   |  May 1, 2012  9:11 AM
D2K 6i, Developer 2000, Oracle Forms, Oracle Reports

Oracle driver
Do you know if a 32 bit oracle driver works on 64 bit computer?

Answer Question   |  September 28, 2008  10:56 PM
64-bit processors, Database, Oracle drivers