• 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...

    ITKE406,430 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?

    ITKE406,430 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.

    ITKE406,430 pointsBadges:
  • How to insert CSV file into Oracle database through PL/SQL procedure

    Hi all, I have a CSV file and I have to insert its data into the Oracle database. Is it possible through creating procedure if yes then give me any solution, I need it urgently. Thanks in advance.

    mollarubia5 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!

    ITKE406,430 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?

    ITKE406,430 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.

    ITKE406,430 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!

    ITKE406,430 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:

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