Explore Oracle on Experts Exchange

Expert Solutions for Your Tech Problems

OracleOracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its prim...

Read more
  • 80K Content
  • 9.9K Contributors

Expert Spotlight
Software Developer

A person who never made a mistake never tried anything new.
- Albert Einstein

FORTIS FORTUNA ADIUVAT
SI VIS PACEM PARA BELLUM

Troubleshooting Question

Oracle Statement Level Trigger - How to reference the "inserted" table?

5
I am mainly a SQL Server guy but I am working on a project with Oracle backend. In a statement level …
Troubleshooting Question

Configure multiple Oracle listeners

bydbadm
5
Hi,
My Oracle version is: Oracle Database 19c EE on Oracle Linux Server 7.9

I've installed 3 Oracle …
Troubleshooting Question

How to reset SYS or SYSTEM password Oracle Xpress

5
My Oracle user Password has expired, usually I log in as SYS or System, using SQL Developer and …
Troubleshooting Question

Oracle Cloud Free Tier: ORA-24247 when executing but no error when debugging??!!

4
I've set up a little routine to parse some pages from a website (package procedure). The database …
Troubleshooting Question

Oracle 12c How do we write a function in Package and execute it

2
how do we write and run a function which returns a value and prints some values in the process for …
Troubleshooting Question

Oracle 12c Procedures & Cursors - Syntax to print debug logs such as a record & records count

4
In Oracle 12c, Procedures, functions & Cursors:

a) what command to write to execute  Procedures, …
Troubleshooting Question

Oracle: Result set in insertion order

3
In the Oracle database, the select statement, select * from tablename, does not give output in the …
Troubleshooting Question

weblogic.security.SecurityInitializationException: Authentication for user weblogic denied.

hi am geting this error when starting weblogic
403> <Authentication for user weblogic denied.>
<Jun 7, …
Troubleshooting Question

issue starting oracle Enterprice manager(EM)

6
hi am having the following error when connecting to EM IN 12c
Forms [64 Bit] Version 12.2.1.4.0 …
Troubleshooting Question

tables not exported when doing import

5
hi am importing data in 19c  am not able to import my tables but i have tables in my schema
expdp …
Troubleshooting Question

issue importing diffirent schema

8
hi am in 19c trying to import in diffirent schema
 impdp system/pswd@dbname schemas=schemaname …
Troubleshooting Question

issue connecting to database 19c

3
hi am not able to connect to datbase in sql developer but datbase is up and running and open
 select …
Troubleshooting Question

issue doing import

11
impdp username/password@dbname schemas=username directory=images dumpfile=username.dmp …
Research Question

Looking for tools to inspect Oracle Forms files.

4
I've inherited a lot of old Oracle Forms files and want to do an analysis/post-mortem on them to …
Troubleshooting Question

procedure to run in cron job oracle

8
hi i need this two query to run as cron job i what a single procedure
update  noc_item_encoded_reply …
Troubleshooting Question

SSRS Report Builder with Oracle stored procedure

bytancat
6
We are using Oracle 18c and SSRS Report Builder 3.0 (I believe).  Instructions for using an Oracle …
Troubleshooting Question

Using Oracle SQL Developer how to make a sequence(or any visual ) diagram of Oracle Packages/ Stored Procedures/ functions/ cursors

10
Using SQL Developer. How can we get a list of
 Stored Procedures & Functions  with their Package …
Troubleshooting Question

Inner Join with dynamic table

2
Hi I am using 2 different table, One is ActivityLog
It has below column
ActivityLogID ActivityID    …
Troubleshooting Question

create procedure with this query

5
hi i what to create procedure with this query

update noc_item_usrgrp
set usr_usrgrp_code = '05'
where …
Troubleshooting Question

update records for the following conditions

4
hi i what to update records for following conditions

Extract all records where DM is 17 and all parts …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more