Windows

convert query results to excel format

Hi, I am trying to query users with more than 4 transactions in the past quarter and bring up their address so the marketing department may send out osme mail to them. I am however told that our publishing hose wants these address in excel format. How do I convert/store the query relts into excel...

Count Distinct Rows on Multiple Columns

I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane ...

How to get into SAP for experieced IT professional

I am in IT for 18 years doing development work under UNIX with C/C++/ORACLE/PL-SQL etc. Have done analysis/design work and feel pretty good about my logic and design ability. I want to break into SAP and get a job after some training. I would appreciate your suggestion to help me get into it. ...

RUN TIME ERROR 339

I have an application written in Visual Basic. The application runs on windows XP system with oracle 8i and Crystal report 8.5 The application suppose to interface with an oracle 8i database. In attempt to run the application it gives this error: 'Run-Time Error 339 component 'CRYSTL32.OCX' or one...

Executing a Function or Procedure from ouside Oracle

I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...

ORA-12535

My database runs on 9i.There are remote databases that connected to it.Today all of them are failing to connect because of the error message ora-12535.I increased the CONNECT_TIMEOUT but error still persists.I even set it to zero (0) and the system hangs indefinately.tnsping to these remote...

Urgent Help: web-Forms 6i don't work after Upgrading the db from 8i to 10g

Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

Meaning of SAP Acronyms

Hello GURUS, I am looking for an expansion of the following SAP acronyms CSV - It is not Comma Seperated Values - as used in EXCEL or in any flatfile input into SAP BW (Could it be Computer System Validation?) FRS - Can anyone help me with these - Thanks and your help will be appreciated

Maintain discount condition in SAP

Discount rate has been maintained for a vendor in the system but not applicable to all types of material. May I know how to make it applicable to all types of material for that particular vendor? Thanks.

ORACLE NOT RECOGNIZING NEW RAM

We installed more memory on our Windows Enterprise Server but Oracle does not recognize the new memory. I know this because when I select ?host? from Enterprise Manager?s home page the host memory is listed as 2g and it should be 6g. If I try to use the new memory by increasing the sga_max_size...

How to get SAP certified

Hi, I want a career in SAP. I have an Associates degree in Graphic Design but work as tech support for a telcom company for 6 years. I dont want to pursue networking or programming, but something geared more towards business. My question is, should I get a SAP certification or should I pursue a...

Career in SAP

Hi Jon i am Master of commerce and Post Graduate Diploma in Computer Programming and computing statistics from Pakistan. After completing my education since 1997 i am working as IT Technician in a power generation comapny. i have planned to go Australia after 6 months. Kindly guide me either SAP...

Help Module Selection(SD,CRM,Basis)

My qualification is MBA(IT & Marketing), have exp in BPO for 1.5 years, Could you please tell which module to choose, SD,CRM or Basis. Should to do CRM - is SD knowledge and work exp is must. Please guide.

Oracle Application or Database on its own server.

Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be...

Running a script at specified runtime

I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

Is our "technology" SAP compatible?

Good day, everyone. No, I don't know exactly what that question means either, which is why I'm asking for help! We are a recruiting/staffing firm, bidding on a contract with a company which uses SAP. They want to know if "Our technology is SAP Compatible". Sigh. We are using a staffing...

How do I get started with SAP HR ?

I have done my MBA in Human Resources and have 6 months experience in IT Recruitment .I was a Web developer for 2 yrs in the past before doing my MBA. I now plan to enhance my career by doing a SAP (HR) course which will help me work as a SAP HR Functional consultant . I need tips to get started...

inserts through a database link

Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance...

Configuring isql *plus

Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik