• Is it possible to run a query on two tables in two physical databases using MySQL?

    I understand that an Oracle database allows users to query on several physical databases. Does anyone know if there's a MySQL equivalent? I'm trying to run a query on two tables (which are in two different physical databases). Would it be possible to do this in MySQL?

    ITKE350,195 pointsBadges:
  • Generating an ER diagram using Oracle SQL Developer

    I'm trying to use Oracle SQL Developer to create an ER diagram for my Oracle database tables but I'm fairly new to Oracle / this tool. What would be the process of going about this? Thank you!

    ITKE350,195 pointsBadges:
  • View metadata of columns of a table in an Oracle database

    I'm looking for a query that allows me to view all the columns that are defined for a table in an Oracle database. Something along the lines of this: Table Name: Some_Table have 10 columns. So basically I want to how I can get the column names, data type and the constraints that are defined for the...

    ITKE350,195 pointsBadges:
  • Code to retrieve data in Oracle 10g

    I'm new in Oracle Forms and I want to enter the industry number and when I press the retrieve button, name and surname must display. Can you help?

    Otsile5 pointsBadges:
  • How to use LINQ against an Oracle database

    Right now, I'm able to connect with DataContext to my Oracle database. But I keep getting errors when I'm running the query against the database. I've already looked at the SQL generated and it's for MSSQL and not Oracle PSQL. Would anyone have a way to use LINQ against the Oracle database?

    ITKE350,195 pointsBadges:
  • Is there a tool to trace queries in Oracle?

    I've been working with SQL Server over the past year but now I need to migrate an application with an Oracle database. When I trace my application queries, I used the Profiler tool in SQL Server. What would I be able to use in Oracle?

    ITKE350,195 pointsBadges:
  • Deploy a .NET application that talks to an Oracle database

    Would there be a way to deploy a .NET application that talks to an Oracle database? If so, what would be required? Thanks for the help.

    ITKE350,195 pointsBadges:
  • How to create a database in Oracle 11g Expressed Edition?

    I recently installed Oracle 11g Expressed Edition onto my Windows 7 PC, along with SQL Developer. I'm trying to create a database with two tables and then use the Developer to insert and query the data. But when I go into Developer, it asks me to create a new connection, meaning that it thinks the...

    ITKE350,195 pointsBadges:
  • Connecting to a Oracle 11 database remotely

    I'm trying to connect to an Oracle 11 database remotely using the following piece of code but I'm unable to do so. But the same code works fine when I connect it to an Oracle 9 database. Am I missing something here? import lotus.domino.*; import java.sql.*; import oracle.jdbc.*; public class...

    ITKE350,195 pointsBadges:
  • How can I connect Oracle Form 10g with Oracle 10g Express Database?

    HOW  I CONNECT ORACLE FORM 10G WITH ORACLE 10G EXPRESS DATABASE .IT GIVES ERROR  TNS 12560 TNS PROTOCOL ERROR

    RAHULDEOLE75 pointsBadges:
  • Is it possible to kill all sessions connecting to an Oracle database?

    I'm looking for a SQL Plus script that can quickly kill off all external sessions connecting to my Oracle database without the supervision of an administrator. Anyone know how to do this?

    ITKE350,195 pointsBadges:
  • Trying to connect to an Oracle database through Visual Studio 2010

    I'm trying to connect to an Oracle database through Visual Studio 2010. The only thing is that I don't actually want to download Oracle. I've referenced System.Data.OracleClient but it's not doing it for me. I do have an Oracle SQL Developer IDE to run SQL queries against an Oracle DB. Here' the...

    ITKE350,195 pointsBadges:
  • How can I connect Android to an Oracle database?

    I really need to access data from an external Oracle database through an Android application (so I can actually update the local database application). I'm not sure what's the best way to do it. Should I create a web service to access it or is there another way?

    ITKE350,195 pointsBadges:
  • Check the data between two dates in an Oracle database

    I have an Oracle database and I need to execute a query to check the data between two different dates. Here's what I have: NAME START_DATE ------------- ------------- Small Widget 15-JAN-10 04.25.32.000000 PM Product 1 17-JAN-10 04.31.32.000000 PM select * from where start_date BETWEEN '15-JAN-10'...

    ITKE350,195 pointsBadges:
  • How do I check the maximum number of connections in an Oracle database?

    Would be the best way, using SQL, to actually check the maximum number of connections that are allowed in an Oracle database. I need it to show the current number of sessions and the total number allowed. Appreciate any help.

    ITKE350,195 pointsBadges:
  • How to load an Excel spreadsheet to an Oracle database

    Does anyone know of a free tool that I can use to load an Excel spreadsheet into a Oracle database? I already tried Oracle SQL developer but it keeps giving me a NullPointerException. Can someone help me out there?

    ITKE350,195 pointsBadges:
  • Performing a multi-row insert into Oracle 9

    I've been trying to find the easiest way to perform multi-row inserts into our Oracle database (it's Oracle 9). This code has been working for me in MySQL but it's not working in Oracle: INSERT INTO TMP_DIM_EXCH_RT (EXCH_WH_KEY, EXCH_NAT_KEY, EXCH_DATE, EXCH_RATE, FROM_CURCY_CD, TO_CURCY_CD,...

    ITKE350,195 pointsBadges:
  • How do I solve the ORA-00933: SQL command not properly ended error message?

    For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

    ITKE350,195 pointsBadges:
  • How can I get the last row of a table in an Oracle database?

    I have an Oracle 11g Express database and I'm having trouble getting the last row in one of my tables. Can anybody help me with this? Thanks so much.

    ITKE350,195 pointsBadges:
  • How to insert BLOB in an Oracle database using C#

    We have to persist a .CSV in our Oracle database but we're trying to not to use procedures (so we have a more testable application). Basically, we want to generate a file and put it in the database. Anyone know how to do this with code (particularly BLOB with C#)?

    ITKE350,195 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