• 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:
  • view and temp. table which one works better in T-SQL?

    please tell me which one performs better view or temp table ?

    HL5 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • Database problem of Stop working

    We are working in Oracle 10g on Linux Debian 32 bit, A week back we had a problem that i was unable to access any tool of oracle in the morning, Everything was fine previously . when i try to write any command server was too slow and when i use sqlplus it is unable to run no reply then i use top...

    IRFANB1465 pointsBadges:
  • Oracle Application Server

    I need to install Oracle Application Server 10g on HP Proliant DL580 with dual-core 64-bit Intel Xeon processor (7140M), & with Windows 2003 64-bit. I couldn't find any version or release for such environment, but I found for the Itanium processors. Kindly advise me about the right version &...

    Saadeddine0 pointsBadges:
  • oracle installation in win98

    When i install personal oracle8i, i got an error message oracle database could not start up it may be the problem of virtual memory .I reinstalled windows 98 and increased virtual memory but i got same problem.the oter thing is already it worked proprly and idon't no when the problem occured.Please...

    Hard ware engineer5 pointsBadges:
  • security problem

    Hello, I have small workgroup having 10 computers in my office. I do some personal work in office like using yahoo messenger, checking personal e-mails and some online banking site. But how does one of my senior knows it? I do everything lonely and securely so that nobody in the office knows it....

    BinooDas123410 pointsBadges:
  • Enabling the AdvanceSecurity layer (SSL) between the weblogic and oracle.

    Hi ALL, we are trying to enable Oracle Advanced Security encryption (SSL) on the JDBC Oracle Thin driver with a WebLogic JDBC Connection Pool.we are using the weblogic8.1SP4 and oracleclient 10.2.0.1...Can anybody know what are the steps to be taken to do...means of any changes in wl...

    Karthik usa5 pointsBadges:
  • Exporting MS Access data to Oracle

    Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access 'Overflow' error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error....

    M15 pointsBadges:
  • Can Personal Oracle 7 or Oracle Developer/2000 be installed in XP?

    I have an older version of Oracle, Personal Oracle 7 and Oracle Developer/2000 which were designed for Windows 95 and NT. They will not install in XP (probably for obvious reasons). Is there a way to get them to install? Is there a patch or something that will allow me to install them??? Also.......

    Valhalla15 pointsBadges:
  • Oracle Data Import

    I am doing an import every week in the test and development database.The import is working fine in the test database.But while i import in the developement database .I am enountering with the errors.All the tables are getting imported successfully ,but after that i am getting the below import...

    Ajayjm5 pointsBadges:
  • Community Message: Answer these questions and earn Knowledge Points

    Hi all Here is a link to some questions that still need answers. Take a look a see if you can help out your peers and earn Knowledge Points with every answer. Remember the members that earn the most knowledge points have a chance to win some cool prizes in the contest we are having. You can find...

    ITKE347,595 pointsBadges:
  • %rowcount in 10G

    Can we use %rowcount in oracle 10G and if not what is the solution?

    Answerpls1230 pointsBadges:
  • how to store information in variables accessible to procedures in the packages??

    how do i store information in variables which are accesible by more than one procedures in the same package?? (i.e. i want to take input information using a procedure and i want to call other procedures internally which will use these input information to give results...) CAN ANYONE HELPME ON...

    Shankar o5 pointsBadges:
  • Logon automation

    I have several programs that where written in vb6 that are now required to be automated through a scheduler. It has been a while since I coded in vb6 and need to know a way to get access to the current logged on users credentials to pass on to a database loggon. the Oracle database is NOT set up to...

    blowerycolumbus10 pointsBadges:
  • retrieving data/tables through ODBC to Oracle

    HI I need to pull up oracle tables through ODBC in access is that possible? help.

    Tacoma for life0 pointsBadges:
  • passing parameters while connecting to Oracle

    We connect a large database about 2000 records of college students details our problem is while retrieving last record in the database.First,next and previous are working. Our exception is as follows:An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll...

    Srilalitha.Net5 pointsBadges:
  • how to determine oracle application server edition

    Hi - does anybody know how you can determine which edition of oracle application server is installed from the command line? Is this info in a config file? Cheers.

    Stevo5 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