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
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
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
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
which is the Good book for SQL?
Answer Question | December 5, 2010 4:52 AM
IT Books, Oracle, Oracle Books, SQL, SQL Server
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
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
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
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
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
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
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
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
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 oracle8i on WINDOWS 2008 SERVER
Answer Question | November 11, 2010 6:55 AM
Oracle 8i, Oracle 8i Installation, Oracle installation, Windows Server 2008
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 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
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
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
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