• Name of server my Oracle database is hosted on

    I'm in desperate need here for some help: How can I find the name of the actually server my Oracle database is hosted on? Thank you so much!!

    ITKE827,840 pointsBadges:
  • Confirm what version the Oracle Database is in SQL

    My partner and I are currently creating an installer for a new application. Basically, a user gets to select a data source for their configuration -> nominate what database it is. But here's what we have to do: Basically make sure that the database is Oracle / the version too (this will be done...

    ITKE827,840 pointsBadges:
  • Searching Oracle 11g database for string in tables

    I'm trying to search my Oracle 11g database for a string in all of my columns and tables. Here's the query I'm using: BEGIN FOR t IN (SELECT table_name, column_name FROM all_tables) LOOP EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM '||t.table_name||' WHERE '||t.column_name||' = :1' INTO match_count...

    ITKE827,840 pointsBadges:
  • Can an Oracle database work with Microsoft Entity Framework?

    Apologizes for the short question (I don't have enough information) but I'm working with Oracle database. Can I have it work with Microsoft Entity Framework? If so, what's the process I have to go through?

    ITKE827,840 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.

    ITKE827,840 pointsBadges:
  • 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!

    ITKE827,840 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?

    ITKE827,840 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.

    ITKE827,840 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!

    ITKE827,840 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:

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.

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

Following