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

    ITKE434,585 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!

    ITKE434,585 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:
  • 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:
  • 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.

    ITKE434,585 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?

    ITKE434,585 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:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • Oracle: How to import schema to replace identical schema but retain unique identifier?

    I have spatial (SDO) data that I would like to import from one schema into another identical schema. My problem is that I only want to replace the spatial data that have the exact same UID_1 (Unique Identifier). Is there a way to do this and if so how?

    OracleATE190 pointsBadges:
  • Advantages of Oracle ERP cloud over SAP HANA

    What are the advantages of using Oracle ERP cloud SaaS platform instead of using an SAP application (particularly SAP HANA)?

    shantashib25 pointsBadges:
  • Training material for JD Edwards

    I'm looking for training materials for Enterprise One. Can someone help me?

    SSCTRAINER15 pointsBadges:
  • Running Oracle Application 6i on Windows 8.1

    I have copy Oracle Developer 6i Folder from Windows XP to Windows 8.1 on laptop computer, and also, I have export Oracle from Window XP and imported on Windows 8.1 , so my application is working fine ,but the report is not working ,the Reports Background Engine continue show the message working...

    MAY05659292714145 pointsBadges:
  • Download PDF file saved in database in Oracle Forms 10g

    From Oracle Forms 10g, how do I download a PDF file saved in my database?

    Fida045 pointsBadges:
  • Oracle 11g on Google Chrome

    We had developed application on using Oracle Forms and Reports 11G with backend Oracle Database Standard Edition Release 11.1.0.6.0. Both are installed at windows 2008 server. It was purchased from Premier System Limited. When the developed application was deployed and run on Internet Explorer, it...

    ghauria15 pointsBadges:
  • Hide columns and Adjust Canvas in oracle forms

    Hi, I need to adjust the canvas and show only the columns selected based on the number of columns selected from the previous screen. screen 1 x - column 1 (checked or selected) - column 2 (unchecked) x - column 3 (checked or selected) screen 2 column 1 - column 3 Any idea what forms built in should...

    Egodalle5 pointsBadges:
  • Why am I getting null values for Extended ASCII Codes in following code?

    SET head off SET pagesize 0 SET linesize 120 SET trimspool on SET feedback off SET verify off   SET serveroutput on size 5000 BEGIN    FOR i IN 32..255 loop       Dbms_output.put_line(i || chr(39) || chr(i) || chr(39));    END loop; END; /

    GeorgeMuller15 pointsBadges:
  • How to become an Oracle DBA

    I am a fresher and graduated in electrical and electronics engineering but I want to settle in the IT industry. What skills I need to develop to become an Oracle DBA? Thanks!

    tomcatafroz5 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