• Oracle DBA or SAP Basis Administrator?

    I completed M.Sc Computers in 2000 but did not get a chance to work in software field till sep 2007. Now I am working in a software firm as Senior software engineer supporting Peoplesoft. Prior to this job I worked for a reputed BPO.My current job role activities are almost similar to a DBA and...

    SAP vs. Oracle5 pointsBadges:
  • list sales by year

    You are to generate a set of sales reports using the tables above. 1) Build a rpeort of sales by year (you can use order total colum) 2) Expand this to include the employee name of the sales rep so now you will show sales by rep by year 3) Also get the sale reps job descriptio and see what type of...

    Kkd7775 pointsBadges:
  • Duplicate Spatial Data

    I"m looking for some help on how to find duplicate geometry for area, line and point features that are stored in an spatial SDO database. Any help would be greately appreciated. Regards, Sam

    SamAvella30 pointsBadges:
  • Moving oracle database

    HI, We have planned to move our oracle 10g production database from Solaris to Aix bix. So experts, please suggest any best practices that you follow or any scripts that should be run before moving it or any documentation or case study that will help us to do the work more efficiently. Thanks a lot.

    8320 pointsBadges:
  • performance tunning

    Dear sir/mam, From last 2 weeks,ur database performance id very slow.plz guide me how to solve the problem. i giving ddetails of spreports,it may be help to resolve the problems. give me solutions as soon as possible. STATSPACK report for DB Name DB Id Instance Inst Num Release OPS Host...

    PERFORMANCE TUNNING5 pointsBadges:
  • SAP HR

    Hi, what are the tables in SAP HR to select the name and salery with sql on oracle

    Wolloc5 pointsBadges:
  • Oracle Installation on Portable Media

    Hello Friends, I am working on Oracle 9i (Rel - 2). I am thinking of developing an application in which I can install Oracle on a portable media (Eg. Portable Hard Disk) and create a databse on the same. First of all, I want to know whether it is possible to install the Oracle on a portable media....

    Girishdadlani5 pointsBadges:
  • Connecting oracle forms 6i with 10g XE database

    I would like to know from anyone out there how to cnfigure an oracle client with developer 6i to communicate with server with oracle 10g XE.

    Omuga5 pointsBadges:
  • HOw to Find Duplicate Geometry in Oracle Spatial

    If anyone knows a SQL statement for Oracle spatial on how to find duplicate geometry for area, line and point features, I would much appreciate it if she\he can share this with me. A million thanks in advance... Regards, Sam

    SamAvella30 pointsBadges:
  • Oracle 6i problem in deploying forms

    Hi, i am new to oracle. i have Forms in oracle 6i that i want to deployed on a web server. i have the option of Program->Run Form -> Web but this is giving the FRM-99999: Error 18121. on checking the release notes and implementing the IView interface its not working. Please, help to solve my...

    Rakh80 pointsBadges:
  • SQL (Oracle) Date Constraints

    Can someone tell me how to create a constraint to prevent entering a date prior to 1 Jan 2007? I am tryin g to do it in a create script. Thanks Lock

    Lock10 pointsBadges:
  • If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import

    If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import ? where as Oracle 10g has defaultly 8kb block size and Oracle 8i has 2kb Block size so it can import 8i database to 10g without any problem or we have to create additional 2kb block size...

    134915 pointsBadges:
  • C#.Net

    Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...

    Cmcwag0 pointsBadges:
  • Hyperion Planning and AAS

    I just took over the Hyperion Desktop administration in the last few months. I am still learning the systems and studios to function appropriatley with Hyperion products. I have been working with IT on data transition information, but we have both come to a dead end with this problem. Whenever I...

    Bcissel5 pointsBadges:
  • Migration Plan for 9i Linux to 10g Solaris

    Does anyone have a migration plan for an Oracle 9i to 10g Migration. Migration will be from Linux running 9i to Solaris running 10g.

    MLC5 pointsBadges:
  • Oracle 10.2.0.2 on AIX5L

    we installed oracle 10.2.0.2 on AIX 5l, we heard that there are performance issues with indexing (Oracle may pick the wrong index) . Has anyone had similar experiences and if so, what patches have you applied to resolve the problem?

    Jpenn5 pointsBadges:
  • Connecting from VB6 to a remote Oracle Database

    We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our...

    Gcasner5 pointsBadges:
  • Microsoft Access – Find and Replace Issue

    In Microsoft Access 2007, the "Search Fields As Formatted" check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find...

    Santino35 pointsBadges:
  • Using SELECT statements

    Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?

    OracleATE190 pointsBadges:
  • ROW_NUMBER in SQLServer

    In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...

    FrankKulash1,240 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following