Translating SAP Table names
Does anyone have experience of translating the german table/column names in a SAP /Oracle database

Answer Question   |  November 18, 2010  8:30 AM
Data translation, Oracle, Oracle 10g, Oracle Database, SAP, SAP Tables

Can I direct query the Oracle database with SQL Plus?
I am about to start work on a SAP system which has an underlying Oracle(version 10) database. I would like to know if it straightforward to query the Oracle database directly iusing SQL*Plus for example ?

Answer Question   |  November 18, 2010  8:23 AM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix

Crystal Reports 8.5 Cannot insert Field or Text Objects
I have been using 8.5 for years without any problem. Recently I have been unable to create any new reports. I am not allowed to insert any field or text objects. I am also unable to modify any of the existing thousands of reports. I have reinstalled a number of times. It will work for [...]

Answer Question   |  November 24, 2011  9:13 PM
Crystal Reports 8.5, Crystal Reports error messages, Crystal Reports Errors, Oracle 10, Windows XP

ORA-06550 and PLS-00103 error
declare  rent_paid_date DATE;  rent_due_date DATE; create or replace procedure due_date(in_rn_ssn NUMBER, in_home_id NUMBER, in_rent_paid_date DATE, in_rent_due_date DATE, in_rental_fees NUMBER) as  fees rent_collector.late_fees%TYPE;  new_fees number := 0; begin  select sum(late_fees) into fees  from rent_collector  where rn_ssn = in_rn_ssn and  home_id = in_home_id and  rent_paid_date = in_rent_paid_date and  rent_due_date = in_rent_due_date and  rental_fees = in_rental_fees;  if rent_paid_date [...]

Answer Question   |  November 18, 2010  5:24 PM
ORA-06550, Oracle, Oracle Error Codes, Oracle error messages, Oracle errors

What is a good book for SQL?
which is the Good book for SQL?

Answer Question   |  December 5, 2010  4:52 AM
IT Books, Oracle, Oracle Books, SQL, SQL Server

Terminate SQL exception, if it is running more than a specified time.
Whether we can forcefully terminate an sql statement during its execution if it is running for a long time or running more than a specified time?

Answer Question   |  November 15, 2010  10:03 AM
Oracle 9i, Oracle performance, Oracle SQL, SQL Exception, SQL statement

Oracle Reports 6i
Currently my report is being displayed in landscape style. i want it to be displayed by rotating it in a 90degree angle. For example, say my current report is ‘|’. I want to display it as ‘-’. The reason behind it was, the increase in the number of columns. Do we need to make any [...]

Answer Question   |  November 17, 2010  6:26 AM
Oracle Reports, Oracle Reports 6i, Oracle Reports Developer, Oracle Views

Error Message ORA-00903 in SQL table
Here is my query:   select guestid, guestfname, guestlname from guest where tourid = 6; It says tourid is an invalid identifier. TourID is a defined attribute in a table called Tour. I’d be grateful for any help.

Answer Question   |  November 15, 2010  11:53 PM
ORA-00903, SQL, SQL Plus, SQL tables

Oracle Essbase multi dimential data retrieval
Need to retrieve actual adn budget data by company business unit then by GL account using Essbase. Have been advised internally that Essbase gets confused with the dimensional (cross reference) request so will not retrieve the data. Does anyone out there have any idea what I am talking about and do you have any ideas what [...]

Answer Question   |  November 15, 2010  10:43 PM
Essbase, Online Analytical Processing, Oracle, Oracle Essbase, Oracle OLAP

Crystal report 9 formula issue
I have a crystal report using two Lawson OLEDB queries, with employee.employee and supervisor.employee. Please let me know how can I write a formula which shows the employee which is listed in the report is a supervisor or not. The report does not shows the supervisor.employee field.

Answer Question   |  November 17, 2010  2:21 PM
Crystal formula, Crystal Reports, Crystal Reports 9, Crystal Reports formulas, OraOLEDB

Invalid credentials in Oracle Database 10g?
I installed Oracle database 10g Express edition successfully and While installing it asked password only. But now it is asking User Name and Password. i know password but i dint gave any username. what it might be.

Answer Question   |  November 11, 2010  11:31 AM
Oracle administration, Oracle Database, Oracle Database 10g, Oracle User Profiles

Oracle Database 10g Express Edition error while login
Hi, I downloaded Oracle Database 10g  Express Edition from Oracle site and i successfully installed in my system but while login i showed an error like “could not establish connection by network card” Please suggest me “how to install it”.

Answer Question   |  June 11, 2011  11:09 AM
Oracle 10g, Oracle Database 10g, Oracle Developer 10g Express Edition, Oracle installation

Internal mailing system with ASP.NET and Oracle database
i want to know how to implement an internal mailing system using ASP.NET and Oracle Database.

Answer Question   |  November 11, 2010  9:08 AM
ASP.NET, ASP.NET Web applications, Oracle Database, Oracle database design

Merging Organizations in Oracle
How is the best way to merge two orgs in Oracle?

Answer Question   |  November 12, 2010  7:34 AM
MERGE statement, Oracle, Oracle administration

jrew.exe has stopped working when iam tryin to install oracle 8i on Windows Server 2008
jrew.exe has stopped working when iam tryin to install oracle8i on WINDOWS 2008 SERVER

Answer Question   |  November 11, 2010  6:55 AM
Oracle 8i, Oracle 8i Installation, Oracle installation, Windows Server 2008

Career in Java
I have done Core Java and J2EE courses. But got job in other platform. Here I am working on report generation using OBIEE tool. I am thinking to change over to Java platform. Is my decision is good? If good, suggest me how to change, i mean how and what  shoul I study?

Answer Question   |  November 11, 2010  6:17 AM
J2EE, Java, Java developer, OBIEE

I know SQL, should I learn Oracle database?
I know SQL but i am not master in that.I know only basics of SQL. Can I start to study Oracle database directly? if so please suggest me some good way to learn.

Answer Question   |  November 11, 2010  11:23 AM
Oracle Careers, Oracle certifications, Oracle Database, SQL Server

Removing default window in Oracle Forms 10g
how to remove default window1 in 10g forms?

Answer Question   |  November 10, 2010  7:39 PM
Oracle, Oracle 10g, Oracle default parameters, Oracle Forms 10g

Code to retrieve data in Oracle 10g
im new in oracle forms and i want to enter the industry number and when i press the retrieve button, name and surname must display, can you help.

Answer Question   |  November 9, 2010  8:49 AM
Oracle 10g, Oracle Data Access, Oracle Database, Oracle Database 10g, Oracle Forms 10g

We’ll trade you an Xbox 360 for your knowledge!
The holidays are approaching and so is your next chance to win an Xbox 360 by simply doing what you do around IT Knowledge Exchange. Between today and December 15th, the three members who accumulate the most knowledge points will win some great prizes:   1st Prize: Xbox 360 with 250GB hard drive & Kinect [...]

Answer Question   |  December 1, 2010  3:12 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, Knowledge Point Challenge, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server, XBOX Contest