Oracle Database

77K

Solutions

103

Articles & Videos

23K

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

How to find out how many cursor are in open stage inside a procedure and how to close all cursor at a time.

211 views
Announcing the Most Valuable Experts of 2016
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

i have this sp

PROCEDURE MostrarVisitaDetalle
          (k_fecha_reg in varchar2,
           k_visnrodoc in varchar2,
.
.
.
             FROM xx.ACME vs
            where vs.visfecreg >= …

212 views

Hi,
Right now, i am doing migration from SQL server to oracle. In sql server, some stored procedures contains keyword like
sp_xml_preparedocument, openXML, sp_xml_removedocument,

I think, they …

423 views

Hi,

If exists ( Select      'X'
                  From t1
WHERE ...

Anyone help me , above syntax does't  work  with oracle


How to change the code to oracle?

Which function do this work in "IF else …

511 views

Hello expert,

Looking for PROTOCOL_ID associated with Employers linked to a certain Payer.

In the CCM_PROTOCOL table, where the OWNER_TYPE_CODE = 15001 (employers),
the OWNER_ID is the …

316 views
Data center

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.

031 views

Hi Team,

Iam using oracle 12c database. I have two PDB database pdborcl1 and pdborcl. I want to grant execute privilege for an user sysadmin in pdborcl1 database to execute a procedure …

2019 views

I want to create a table by which we should be able to implement complex business rules.

simple eg:

(test1 = pass or (test2 = fail and test3 = pass))
or (test4 = fail or test5 = pass)

730 views

What is Oracle nested table as object type what are the uses. If there is no data nested in that table why it called as nested table ?

230 views

How can we recover truncate data .

424 views
Free Tool: Postgres Monitoring System
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

is there a drag, drop and join of tables (MS Access like) Visual Interface in Toad 12.10 Enterprise.  if there is, can someone please provide instructions on how do/get to it?
Thanks

420 views

I am receiving errors PLS-00341 Declaration of cursor C_CURTEST is incomplete or malformed.
PLS-00597 Expression R_CURTEST in the INTO list is of wrong type. However; when I run this in an anonymous …

517 views

Hi,

I am struggling with migrating the temp tables (SQL server) to oracle. Mostly, oracle don't consider to use temporary table inside the store procedure but in sql server, they are using temp …

323 views

why would I be getting the comma  ||','|| delimiter as part of the output header in my query?

819 views

Oracle standalone instance, say 11gR2 on Linux, DBA mistakenly issues a SHUTDOWN in a production session rather than development as intended. It's been suggested to (1) be extra careful next time and …

1430 views

Hi
I have converted one sample procedure (SQLserver) to oracle.
Kingly suggest me if this conversion is fine or whether need to change ?

I greatly appreciate your help. I am grateful to you for …

521 views

How can i do below have a flat file like below:

 

T|B|P04|WN4|0018025196|2014-04-14T13:01:17Z|ET3|USD|2.00|4/4/5/7|2.00|

240 views

Hi

I want to set the cntpm local var in my PL/SQL block. This value is originally returned from a SQL that uses the present cursor variable. But I get an error in my code.

DBMS_OUTPUT.ENABLE;

318 views

When I run a medium complex query with one inner join (and 2 unions), data returns in under 5s, 483 rows. One of the key pieces of info is "Days Between" (the end of one trip and the beginning of …

725 views
PRTG Network Monitor: Intuitive Network Monitoring
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Hi EE,

I have the following script:

(CODE)

When I run it get the error:


GAC    Version        Location
---    -------        --------
True   v2.0.50727     …

216 views

Forms [32 Bit] Version 11.1.1.4.0 (Production)
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
     With the Partitioning, OLAP, Data Mining and Real Application Testing…

2239 views

Hi:

I need to get the minimum value across 4 columns for each row in a table. Pseudocode is like:  
minimum (nvl(t.rating_A,0), nvl(t.rating_B,0), nvl(t.rating_C,0), nvl(t.rating_D,0)) as …

227 views

I am trying to create a view using the code below and I am getting error, ora-00904: "ACTUAL_END_DATE": invalid identifier.

I have modified the table_Names so that they do not represent the actual…

821 views

Hello expert,

Ran a report for a colleague request copied herewith below
Report runs fine.

The colleague asks that the MARKET_ID be included in the report.

MARKET_ID is on the table …

331 views

Hi,

  For some reason a lot of  TRC & TRM oracle files are being generated in a Oracle Client computer
when the user is performing some custom utility to extract Extract documents and metadata …

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

Oracle Database

77K

Solutions

103

Articles & Videos

23K

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