Oracle Database

78K

Solutions

104

Articles & Videos

25K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Related Topics

  1. Query Syntax
  2. Databases
  3. Microsoft SQL Server
  4. Unix OS
  5. Enterprise Software
  6. Linux
  7. Java
  8. .NET Programming
  9. Microsoft SQL Server 2005
  10. MySQL Server
Refine results

I had coded a plsql procedure inside (cursor & collection) for process 20 million record . Before deployment the code into production i have tested

the code through various of perfomance tool …

424 views
Free Tool: Port Scanner
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I need to export all user objects ddl while having minimal rights on the schema.  I cannot use dbms_metadata.get_ddl.

This needs to be automated.  I prefer to use code.  I know sqldeveloper and …

1941 views

Hello I  have the below code that works great. However, i want the 2016 to not be a hard coded and would prefer it to be the previous year i can do this in access with  DATESERIAL(YEAR(DATE())-1,1,1) …

928 views

I am attempting to install the Oracle client 11.2.0.3 32 bit on a Windows Server 2012 R2 with Remote Desktop Service installed. After I downloaded the client, I double clicked setup.exe and a black …

326 views

Hello,

I have a JAVA program that currently fetches ID from a oracle table and pass as a parameter to cassandra query, fetches the details and inserts into another oracle table.

The problem I …

349 views

I have 3 table
called
 1.Sales,
 2.sales_copy,
 3.sales_log_err
 respectively  i have more than 3 million sales record i want to copy allsales record into sales_copy table and at the same time …

128 views

Hi,

We currently have a production Oracle database which we use to run various reports throughout the day.

However we know have a requirement where we need to setup another oracle database …

731 views

I've inherited someone's undocumented setup, and I'm a first-timer who is learning OTJ.  Weblogic version is 10.3.2; the services are Forms and Reports. My startup sequence, at a high level, is to …

425 views

hi,

any good site for me to learn Oracle programming from starter to expertise?

1437 views

Oracle 11gR2

I have created a job schedule as follows:

BEGIN
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'HR.alert_test'
     ,attribute => 'AUTO_DROP'
     ,value     => FALSE);

942 views
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I have doubts in performance tuning .. the following questions
1.Which tool are u using in plsql developer for performance tuning?
2. What are all the exceptions you created in real time?
3.
In …

231 views

I have a ms sql server management studio r2 at work, and was if I can do the following below?
1) Can I connect to an Oracle database warehouse, and create queries from this tool? Example, from an …

432 views

I'm grouping on customerID in a query and want to pickup the last 2 visitdate, what's the best approach.

Thx

515 views

hi am having this error when starting my form builder
my set is
C:\Users\rdp>set
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\rdp\AppData\Roaming
CLIENTNAME=DESMAND-PC

227 views

hi i have the following cursor in my trigger when-new-instance the query work well without nocycle but when i put nocycle am geting error
this is the cursor
(CODE)
      
            orms [32 Bit] Version …

1128 views

I need to write a password authentication algorithm in PL/SQL.

Basically when users enter/change their password, it will force some rules like
minimum 10 characters, 1 or more character uppercase,…

1235 views

I'm using an Oracle database and need some help - triggers are something I struggle to understand.

I need a trigger for when I insert or update a row in Table A so that it updates a column on Table…

1354 views

Is it possible to have both a function based and non-function based index on the same column?

LOWER(COL_A) AND COL_A indexes?

3621 views

hi am in form 11g i have lov which got list of tables in database i what to select table name and populate table details tables got diffirent number of column and diffirent description


         …

238 views
SharePoint Admin?
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Please provide query that filters the highest sequence for a given ID for the following CLIENT table:
ID      SEQUENCEID  //more than 10 other columns
12      0
12      1
12      3
23      0
34      0
//and so on the these …

464 views

I am using Oracle SQL Developer and have a field with different lenght values, but only things constant is there are 2 commas

ie: 0,,I  or 0,5847,D or 0,12549944,E

I want to pull the value of …

231 views

hi got the following query

select empacc from employeee
              where empid = '18'
              and  substr(empaccid,1,3) = '0960825'
              and  substr(empaccid,4,4)  = '0960825'
                  
                  the …

1052 views

SELECT mp.master_organization_id                          org_id,
           mta.organization_id,
           mp.organization_code,
           mmt.transaction_id,
           mmt.transaction_date,

1760 views

Hi
We have an Oracle database server (maintained and supported by 3rd party co).  It developed an issue some time ago (its a standby server) whereby the connection cannot be made from the 3rd party …

1152 views

Since migrating to Oracle 12c we have been consistently getting these Oracle errors in our alert logs:  ORA-0060 ltbagi

One of our DBA's found a fix on the web: execute this package …

245 views
Show more content
201506-LO-Top-001

Oracle Database

78K

Solutions

104

Articles & Videos

25K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Related Topics

  1. Query Syntax
  2. Databases
  3. Microsoft SQL Server
  4. Unix OS
  5. Enterprise Software
  6. Linux