• ORA-00979 error message in Oracle query

    In Oracle, I keep getting the ORA-00979 error message with my query. Here's what it looks like: SELECT cr.review_sk, cr.cs_sk, cr.full_name, tolist(to_char(cf.fact_date, 'mm/dd/yyyy')) "appt", cs.cs_id, cr.tracking_number from review cr, cs, fact cf where cr.cs_sk = cs.cs_sk and UPPER(cs.cs_id)...

    ITKE379,980 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:
  • Error message when starting up Oracle 11g database on Windows Server 2008 R2

    I'm running Windows Server 2008 R2 and when I'm trying to startup Oracle 11g database, I keep getting this error: SQL> startup ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2180024 bytes Variable Size 1996491848 bytes Database Buffers 1191182336 bytes Redo Buffers...

    ITKE379,980 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!

    ITKE379,980 pointsBadges:
  • Use RMI for extract in Oracle 8i

    Could we use the RMI "remote method invocation" over iiop to extract the information from data warehouse or from cloud? If it possible? How can I use it?

    omarmustafa5 pointsBadges:
  • How to see list of users who have access to certain tables in Oracle

    In Oracle, is there a way I can see a list of users who have access to certain tables (and who have been assigned a particular role)? Thank you very much.

    ITKE379,980 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?

    ITKE379,980 pointsBadges:
  • View pending changes to a table in Oracle

    I'm working a project in which I'm debugging through a batch process that's doing a lot of DML statements. However, it doesn't do a commit immediately. In Oracle, is there a way I can see pending changes from another session when the transaction isn't committed? Thanks!

    ITKE379,980 pointsBadges:
  • Microsoft Excel report generation from Oracle Forms 10g

    what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.

    Somnath895 pointsBadges:
  • If I search with and FK ID_Entity on a big table, takes 0.05s to return 2000 rows, but if I search with the FK and a Varchar2(1) takes too long!

    I have a table with 3000000 rows. With a Select count(1) from  Conceptos where id_entidad = 1 Takes 0.05s to return the number 2000 But if I search Select count(1) from  Conceptos where id_entidad = 1 and Esta_Aprobado = 'S' Then it takes 7s to return the same number I hace index over Id Entidad...

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

    ITKE379,980 pointsBadges:
  • Using Oracle in mechanical engineering

    How do I utilize Oracle in mechanical engineering?

    bkub015 pointsBadges:
  • Send database name from Oracle Forms 10g to Oracle Reports

    Dear all, Can I send a database name from Forms 10g to Reports, as parameters?

    Omrsft95 pointsBadges:
  • How to run Oracle 10g forms on browser

    Hello everyone, When I run form browser, it shows only Oracle forms. Please help me solve my problem.

    Scarletsys5 pointsBadges:
  • Oracle APEX: calendar size

    Hello, there's been a change to my calendar on apex where it's now half the size it used to be (before, it used to fill up the entire screen). I'm not sure what I changed... can someone help?!

    Skimm15 pointsBadges:
  • How to calculate the difference between two dates in Oracle SQL

    I have the following table in Oracle SQL: Filename - varchar Creation Date - Date format dd/mm/yyyy hh24:mi:ss Oldest cdr date - Date format dd/mm/yyyy hh24:mi:ss So I need to calculate the difference in hours, dates and also minutes between two dates. How can I do that? Thanks.

    ITKE379,980 pointsBadges:
  • Oracle: How to string to date with milliseconds

    I'm trying to convert the following string to date in Oracle: 2004-09-30 23:53:48,140000000 I've already using this: to_date('#', 'YYYY-MM-DD HH24:MI:SS,FF9') But I keep getting this error message: ORA-01821: date format not recognized. Would anybody have a suggestion on what I should do here?

    ITKE379,980 pointsBadges:
  • How to uninstall OracleserviceXE

    I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

    Desjacks5 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:

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