• Oracle: Find value for each UserID that has latest date

    In my Oracle table, I have three different columns: UserID, Value and Date. I'm trying to get the value for each UserID (that has the latest date). How can I do that? Can I use SQL?

    ITKE440,635 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.

    ITKE440,635 pointsBadges:
  • Oracle: Items in shared pool being flashed or removed

    Under what circumstances, are my items in the shared pool being flashed or removed?

    abrahamawusi5 pointsBadges:
  • Oracle forms runtime fmx is not able to connect to database

    Hi, I installed forms and reports 6i on my system. I could able to connect to data using forms builder and developed form.When trying to open fmx file, its asking for logn credentials and when i give credentials its giving me ora-12222 error.Pls help me out in this.

    skchiv715 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:
  • SAP training for an Oracle DBA

    Hello, I am an Oracle DBA with experience in SQL, Reporting and Business intelligence and want to break into SAP, but as a novice in SAP, please suggest the best model to start with, putting the following into consideration: More financial reward. Where I can fit into easily (technically). Where I...

    oluwafemi25 pointsBadges:
  • username and password is asking oracle 10g database

    i installed oracle 10g dba clint side in my pc, but username, password and string is asking pls help me sir/madam

    Unix5 pointsBadges:
  • Oracle Version 11.1 and 11.2

    Is Oracle Version 11.1. 1 and 2 still being used?

    Smitha10795 pointsBadges:
  • Insert data into newly created Oracle 10g tables

    I have created a database for scenario. I have 6 tables created. I am having difficulty inserting the data.

    Ray30syed5 pointsBadges:
  • How can I reset a sequence in Oracle?

    Hello, Does anyone happen to know if I could reset a sequence in Oracle? I understand how to do it in PostgreSQL: ALTER SEQUENCE serial RESTART WITH 0; Thank you very much!

    ITKE440,635 pointsBadges:
  • Finding data from a table that is linked with another table using foreign keys

    I want to see all the customer names and their city who have an account in a specified bank. Problem is my customers are listed in one table and accounts are listed in another. But I do have another table called depositor where it only store account name and customer name. How can I see customers...

    Rezoan5 pointsBadges:
  • 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)...

    ITKE440,635 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...

    ITKE440,635 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!

    ITKE440,635 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.

    ITKE440,635 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?

    ITKE440,635 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!

    ITKE440,635 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.