• Linked Server Query Returns Incomplete Results

    I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select * from...

    Apickel350 pointsBadges:
  • Automatically Oracle database server shuts down and starts again in 30 minutes

    How can I optimize my Oracle database?

    dagdus160 pointsBadges:
  • Oracle: Difference between SYS and System accounts

    I'm pretty new to Oracle and as I understand, the two ways to connect to Oracle (as an administrator) using SQL PLUS: 1.sqlplus sys as sysdba 2.sqlplus system/manager So, what's the difference between these two? When should I use each other? Thanks!

    ITKE380,545 pointsBadges:
  • Oracle: Track changes that are made to database

    In Oracle, how can I keep track of changes that are made to my database? This would include: Objects, packages, etc. Should I use a trigger? Or some other software?

    ITKE380,545 pointsBadges:
  • Oracle: See list of databases

    In Oracle, is there a way I can see a list of my databases? Something like MySQL's SHOW DATABASE statement? I need to find the databases in a cluster too. Thank you.

    ITKE380,545 pointsBadges:
  • How to insert looping data in Oracle database using VB.NET?

    Dim cmd = New OracleCommand For i = 0 To DataGridView1.Rows.Count - 1 Sql = "INSERT INTO TM_EMPLOYEE_INFO (V_EMPLOYEE_NO, " Sql = Sql & "V_NAME_TRAINEE,N_GENDER,V_COMPANY) " Sql = Sql & " VALUES('" & DataGridView1.Rows(i).Cells(0).Value & "', " Sql = Sql & "'" &...

    ajpascual195 pointsBadges:
  • Oracle 11G database installation error

    I am new to Oracle database. While trying to install the database software, I get: DIM-00019: create service error ORA-12560: TNS:protocol adapter error I have been trying for a long time to install the database but cannot. How do I install the database?

    prashantmishra29015 pointsBadges:
  • How to use POS.NET for a BARCODE SCANNER in a VB.NET application

    Hi! I have an old office project... Its Point of sale software built in VB.net over oracle db express edition. Its really cool but lucks the barcode scanner functionality. Some customers are demading for that functionality.....bla bla bla!!!  ...Devices I've programmed 4 in the past usually comes...

    49cubes45 pointsBadges:
  • Duplicate values in an Oracle database

    Is there a SQL statement that would return duplicate values for a given column / count of their occurrences in an Oracle database? Thank you very much.

    ITKE380,545 pointsBadges:
  • Oracle: Getting list of all tables

    In an Oracle database, is there a query that would display the name of all the tables in it? Thanks so much!

    ITKE380,545 pointsBadges:
  • Roadmap for Oracle database

    Hello, Can you tell me where I can the roadmap for Oracle Client and Oracle database? Thank you!

    ablouin5 pointsBadges:
  • Display date in Oracle Toad

    How to display all the months between two dates. My fromdate format is 'mon-yyyy' and todate format is 'dd-mon-yyyy'. Please suggest.

    Deb4u50 pointsBadges:
  • Connecting ASP application with Oracle database

    I would like to know how to connect my ASP application with Oracle DB. Still now I'm connecting with MS Access only.

  • Oracle 12c Export

    Why is it so easy to use the CLI to export the database but very complicated, and still do not how, to use the GUI clickables?

    roger8120 pointsBadges:
  • Manually apply archived logs to an other Oracle database

    We have a production db (Oracle 11rg2) on one AIX 7 server. The database is in archive mode. We another server with exactly the same configuration (also the DB, filesystems, etc ) as the production server. We did a cold backup of the production server and restored it to the "backup" server. So the...

    Marior5 pointsBadges:
  • Tutorial questions and answers

    Queries on Oracle database black screen?

    comp210 pointsBadges:
  • Store .wav file in a Oracle DB

    I want a Java program to store a .wav file to be stored in Oracle. I know that we use blob, but my problem is I want to know the things to do in between upload and the insert statement used to store in the DB.

    Ragas60 pointsBadges:
  • How to run form Oracle developer 10g

    I have installed Oracle database 10g and Oracle developer in same machine named "admin". I am able to execute a form through web from the same machine as follows. http://admin:8889/forms90/f90servlet but I am getting only a message "Oracle Application Services successfully installed". Not getting...

    magdiitu5 pointsBadges:
  • Would like to upgrade to 10.2.0.4 from 9.2.0.7

    I have 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated. Thanks!

    Kanif15 pointsBadges:
  • Make login form in VB.NET 2005

    How to make login form in VB.NET 2005 and check the values in Oracle database?

    Shaz255 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