• Oracle 10g on Windows 2003 virtual server

    We have installed a SQL server on Windows 2003 virtual server and there were performance issues. Will oracle 10g make a significant difference in terms of performance? Are there known issues concerning 10g DB running on Microsoft 2003 virtual server? thanks

    Markv5 pointsBadges:
  • VB.NET ans ORACLE database

    Hi all. I know, that there is a big risk of asking a silly question, but I try to connect to a ORACLE 10g database witch MS Visual Basic 2005 Express Edition and all programming examples I found do not work. Is this a configuration that does not work? Or what software do I need exactly? What should...

    Flyer15 pointsBadges:
  • SQLServer equivalent to dba_role_privs, dba_user_privs, dba_object_privs ???

    Is there a SQLServer equivalent to being able to retrieve internal application specific metadata that to the users/roles v.s. object privs (select, insert, update, delete, execute, etc.) ? In oracle it's achieved by forming SQL selecting data from the appropriate "dba_" views. In SqlServer this can...

    DaveSTC0 pointsBadges:
  • Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • Validation Error – Oracle database on Windows Server 2003

    I am trying to log into an oracle database residing on a windows 2003 server through enterprise manager. I keep getting the error Validation error - �. I have added my username to the "log on as bacth job" properties. but I still keep getting this error. Please help

    Niimajor25 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE345,300 pointsBadges:
  • Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

    Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrate an Oracle database to SQL2005

    I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!!

    mnman66265 pointsBadges:
  • How to export all Oracle users from EBS?

    I want to print all the Oracle users in our EBS. How to do it? Thx.

    QAQA65 pointsBadges:
  • Oracle Query: Return a date eg 29 February 2008

    Hi How can I return the last day of the second month of the current year in Oracle Thanks in advance

    Csshahie5 pointsBadges:
  • How to pass data from JDE to web page

    There is a requirement wherein data which is on a JDE World screen should be passed to a web page when a function key is pressed. On pressing of the particular function key, data which is on the JDE World screen must be passed to and displayed on the web page. I need ideas about how this can be...

    AS400 - Ask the Expert485 pointsBadges:
  • login persmission Windows Server 2003

    I am trying to log into a windows 2003 server through oracle enterprise manager. I get a wrong username and/or password error. I use the same credentials to login alright when I use remote desktop. Are there any permissions or rights I need to change or grant in the server to be able to login....

    Niimajor25 pointsBadges:
  • Top products in eProcurement field

    I am an Ariba consultant with experience in Buyer,Contracts and sourcing. If I need to change the career to a different application that is in good demand in market and having similar functional knowledge, which are the ones that you would recommend? Could you tell me the SAP products that share...

    Lekha5 pointsBadges:
  • Oracel import question

    what happens if i import a particular table into a user schema which already contains the same table?

    fartman50 pointsBadges:
  • Update table to remove invalid char type (tab) Oracle

    I need to update a table I have in oracle that has an invalid character type in it. It looks like it is a tab character. Can someone give me a script to update this field in the table to remove a tab character from a field and replace it with a space - I assume? Very few rows have this 'bad' data...

    Meb10 pointsBadges:
  • Embedded SQL in a Cobol program using a sub-select in the select clause

    The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = SB_CURRICULUM_STR.F_LEARNER AND SOVLCUR_CURRENT_IND = 'Y' SSRMEET_ROOM_CODE FROM SSBSECT, SSRMEET, SGRSPRT WHERE...

    Warpmail5 pointsBadges:
  • CREATE BACKUP OF SPECIFIC DATA IN ORCALE DATABASE USING JAVA COMMAND OR PROCEDURE

    RESPECTED SIR, i am doing a project. My front end is java and back end is oracle. In my project i stored data in oracle. but I want to create it's back. plz give my a procedure in java to create backup of my data file. which is operate from java front end.

    Juned5 pointsBadges:
  • forms 9i help

    hey , i want to know is there any way to change the java window applet size by any built in and change the oracle picture as well as toolbar.so plzzzz let me know its kind of urgent... thanks in advance nishant

    Nishant835 pointsBadges:
  • Oracel 9i Undo

    How can i determine if the undo is setup properly and how can i determine if it is online

    fartman50 pointsBadges:
  • oracle multi-field row query with more than one row

    I have a table that specifies the year, and a quantity for each month, in the same row. I need to get a 12 month rolling average, which involves particular fields from one row, and addition fields from another, based on the sysdate. There are several tables that need to be joined to ensure I have...

    Seashellm150 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