Tutorial questions and answers
Queries on Oracle database black screen?

Answer Question   |  December 17, 2012  11:07 AM
Oracle, Oracle Database

Scrip an select from linked Oracle database in Management studio gives multiply fields
In SQL Server 2008 R2 Management studio under Linked servers I want to script a select from an Oracle database table. The result is that many of the fields occur three times. What can the reason for that be? See this example: SELECT [RATETYPE],[RATETYPE],[RATETYPE]             ,[FROMCURRENCY],[FROMCURRENCY],[FROMCURRENCY]       ,[TOCURRENCY],[TOCURRENCY],[TOCURRENCY]       ,[VALIDFROM],[VALIDFROM],[VALIDFROM],[EXCHRATE]       ,[FROMFACTOR]       ,[TOFACTOR]       ,[CREATIONDATE],[CREATIONDATE],[CREATIONDATE] [...]

Answer Question   |  May 30, 2012  11:42 AM
Oracle Database, SQL Server 2008 R2

Failed Link to External Data
I was able to link to all external data in ODBC Oracle database but one table that has more than 32 indexes. How can I link to this table? Please advise. Thanks

Answer Question   |  April 26, 2012  2:52 AM
ODBC Oracle, Oracle Database

login form for Oracle
hi,  i want to create a login form that validates the username and password from the database.  the username and passwors are stoed in the database. table:login column: empid, password

Answer Question   |  February 27, 2012  3:46 PM
Oracle, Oracle Database, Oracle Forms

cubes and databases
What exactly is a cube and how does it work

Answer Question   |  February 28, 2012  5:14 AM
Oracle 6, Oracle Database

connecting Plustech scanner with oracle forms6i
Hi,I need to know the statement of using Plustech scanner with foms6i, how I can scan image and stored it inthe oracle database?

Answer Question   |  February 28, 2012  5:45 AM
Oracle Database, Oracle Forms 6i

How to recover from ORA 01033 Oracle installation or shutdown in progress error
After UPS failure my database failed and given ORA-01033 error. I stopped all Oracle services and copied ORA data file to another server, having same database name and SID. The old Oracle was in C Drive and new is in E Drive. I am getting the same error. Can I recover my data anyway. Please [...]

Answer Question   |  April 19, 2013  2:55 PM
Oracle 8i, Oracle Database, Oracle error messages

problem about using Oracle Form 6i to connect Oracle Database 10g express.
Sorry to interrupt all of you. I have encountered a problem about using Oracle Form 6i to connect Oracle Database 10g express. As I would like to I use Oracle Net8 Easy Config to create a connection. According to “tnsnames.ora”, the paramater of connection is as follows; XE =   (DESCRIPTION =     (ADDRESS = [...]

Answer Question   |  October 11, 2011  4:20 PM
Oracle 10g, Oracle 10g administration, Oracle Database, Oracle Forms 6i

What is the next step after installing oracle application server?
hi , first i installed (oracle database 10g) then i installed (oracle application server 10g)  in my computer (windows server 2003) and i want to run the form’s , note that  theese form’s i desgned it in other computer i need to know what is the steps to configure and run the form’s without installing [...]

Answer Question   |  March 31, 2012  4:38 PM
Oracle, Oracle 10g, Oracle Application Server, Oracle Database, Oracle Database 10g

How to find the time (timestamp) , when the datafile status changed to RECOVER?
Hi All, Oracle Database Version : 9.2.0.8.0 Some of the datafiles status have been changed to ‘RECOVER’, because the datafiles are physically missing… Now, how can i find that when (timestamp) the status of the datafiles have been changed, as i am unable to find when the datafiles have been physically lost? Please consider both [...]

Answer Question   |  March 31, 2012  3:01 AM
AS/400 TimeStamp, Oracle, Oracle Database

Connects the oracle from java applets
if any necessary to install thin driver for connect to the oracle database from an applet. But my applet and oracle running on the same host…I face difficult problems when i connecct the database from an applet.Pls help me…..    

Answer Question   |  June 15, 2011  10:38 AM
Database connectivity, Java applets, Oracle connectivity, Oracle Database

Unable to establish connection to Oracle database 10g XE
Hi All, I have successfully Installed Oracle 10 g XE. When I Click ‘Go to Database Homepage’ to access the database the webpage shows an Error message “unable to establish a connection.”  What could be the possible reasons for this error? and How can I fix it? Appreciate your HELP ! Thanks in Advance, Chandan 

Answer Question   |  June 13, 2011  4:09 PM
Oracle 10g Database, Oracle Database, Oracle Database 10g, Oracle XE, Windows XP

Oracle Forms/Reports 10G/11G on Oracle Database 9i
Can I use Oracle Forms/Reports 10G/11G on Oracle Database 9i?

Answer Question   |  June 6, 2011  1:31 PM
Oracle Database, Oracle Forms, Oracle Reports, Oracle Reports 10g

Auditing Oracle 10g and above
Is it possible to fully audit Oracle Databases without Oracle’s audit tools? At least on 10g and above, many of the configuration files that could be reveiwed and audited for content and permissions no longer exist or are not used. Init.ora, sqlnet.ora are no longer used, and I suspect I will find others as I [...]

Answer Question   |  May 25, 2011  7:15 PM
Auditing, Oracle 10g, Oracle 10g administration, Oracle Database, Oracle Database 10g, Oracle security

Oracle fails due to disk partition is full. Data now is corrupted.
Hi all, I have a big trouble with one application that is working in a wrong way due to Oracle failure. Oracle is running on AIX. I just have access to see the disk partitions on the server with df command but I have no access to see Oracle logs. I can see that one [...]

Answer Question   |  May 26, 2011  5:06 PM
AIX, Corrupted database, Oracle, Oracle Database, Oracle database administration, Oracle error messages, Oracle errors

Oracle and form
i made a project in oracle backend and frontend both; how can i install fmx file on others pc and access to oracle?

Answer Question   |  May 2, 2011  11:01 AM
FMX, Oracle Database, Oracle Forms, Oracle projects

Native SQL
I want to insert picture into oracle database from sap usinf native sql.I use string field but ı take conversion error?How can I insert ?

Answer Question   |  March 17, 2011  1:34 PM
Oracle, Oracle Database, Oracle errors, SQL Server

Converting Oracle report to excel
how to oracle d2k report convert to excel ?

Answer Question   |  February 22, 2011  9:54 AM
Oracle Application Server, Oracle Database, Oracle Reports

How to insert an image file into an Oracle 8i database
insert picture into oracle table

Answer Question   |  February 11, 2011  4:10 AM
Oracle 8i, Oracle 8i image storage, Oracle administration, Oracle Database, Oracle image storage

IT career planning for SAP
Dear Sir, This question may have been asked to you million time sorry for that. Which career path in SAP I should choose to enter into the SAP domain. I have 10 yr of IT experience.. 6 to 7 year of coding and design in microsoft technologies like vb, asp, .net etc. Good knowledge of [...]

Answer Question   |  March 8, 2012  11:33 PM
IT career planning, Oracle Database, SAP careers, SAP certifications