Oracle Database

77K

Solutions

102

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.

Refine results

Hello,

Is it possible to create a file system directory from a procedure in Oracle 10g?

Thanks

49 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.

Hello,

I got a Database link from Oracle 10gR2 to Postgre 9.5 and i'm having an issue when trying to run a few commands.

I executed a few queries from pl/sql and it works sometimes but sometimes…

625 views

Hi,
I have levels as below ps_level

level1 level2 level3 level4 level5 level5 level6
101     101    101    101     101   101   101
101     102    102    102     102   102   102

101     102  …

218 views

Hello Experts,

I am migrating MSSQL db to Oracle 12c , using the migration tool in sql developer. I am not getting any data after the data move final step.

Migration steps  …

327 views

hi i have the following cursor in my 12c database
(CODE)

am geting the above error but in 11g is ok am running this in plugable database

526 views

hi am having this error when starting my db
(CODE)

221 views

Hello Expert,

I have below command , it is giving only some part of BLOB. Can you please suggest some modification through which I get all the text from the blob (output).

select …

223 views

I am looking for some detailed documentation on Creating Indexes on a Materialized view. I googled, but did not find any thing recent.

520 views

I'm working with a MS Access database that was developed by someone else.

I've converted this database to work in the Windows 10 environment with MS Access 2016.  Since converting the database to …

1950 views

I need a skeleton Oracle function that does the following:

1. Enter record into table1
2. Get ID of entered record
3. Enter 5 records into table2 using the ID from the first table and 5 passed …

1538 views
Is Your AD Toolbox Looking More Like a Toybox?
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

The following statements return numbers from a-z but I need a new column to calculate the change as a number.
For example, if the letter for Q1 is B and Q2 is D, then the output would be +2.  If Q1 …

321 views

Hi Team,

Iam trying to run the below code , Iam getting the below error.

declare
type t_empid is varray(2) of EMPLOYEES.EMPLOYEE_ID%type;
v_empid t_empid;
cursor c1 is
Select brand_dsc …

1518 views

Im trying to help a coworker figure out why this query isnt working in SQL Developer. Its a procedure in a package and the Insert doesnt work. The Select that is feeding the Insert brings back plenty …

1025 views

How to find the creation date for each pdb

We are unable to find out each PDB creation time in our 12c database. Tried scn_to_timestamp(create_scn) from v$containers but it errors:

ORA-08181: …

518 views

(CODE)

In the below code

If the query has no rows returned I want to do the following

INSERT INTO AUDIT_DEVDB_HIST (DATABASENAME,TIME,MACHINE,USERNAME,SESSIONS,LOG)
             VALUES ( …

117 views

I have a scenario where I have to run a query on multiple databases from a database "A" using database links from "A" database.
I have a table in "A" database which should insert the pulled data from…

3061 views

Hi EE,

I have been following the troubleshooting article for an ORA-12154: TNS error issue.

329 views

Hello. I have a question pertaining to preventing a commit of one record, while still going through and comitting all other records that have changes.

Basically, it's a form that displays multiple …

322 views

Need to know where the actual time values come from in my Oracle database.  For example for columns DATETIME, SYSTIME, or SYSTIMESTAMP - the values for these datatyped-columns is the time on the …

426 views
VMware Disaster Recovery and Data Protection
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

I had this question after viewing pl/sql - query very slow (https://www.experts-exchange.com/questions/28999908/pl-sql-query-very-slow.html).

The query takes 20 seconds

1140 views

Hello Experts,

I am to connect to  SQL server 2016 from sql developer using Third Party JDBC Drivers. Used windows authentication

basically following Migration  …

227 views

We have certain field whose name has a special character, in this case its an spanish "Ñ" the field name is "año" (Year) and when we execute the next sentence it returns the next error:

select …

1147 views

We just moved to Windows 10 as a company and I have VBA code that uses and ODBC to connect and pull data from an oracle database.
When I try to launch the code in Excel 2016 in windows 10 I was …

1665 views

hi experts, this query is very slow

SELECT LTRIM(TO_CHAR(cccnumcot, '099999')) "Numero",
       TO_CHAR(cccfeccot, 'DD/MM/YYYY') "Fecha",
       SUBSTR(cccnomatn, 1, 30) "Atencion",
       …

2659 views

The query below returns results that only equal the minimum PAY_CLASS which is 01.  How can I return only one result per EMPLOYEE_NO where their minimum PAY_CLASS could be higher than 01?  Thanks!

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (47,604)
  2. Databases
    (53,696)
  3. MS SQL Server
    (157,551)
  4. Unix OS
    (32,732)
  5. Enterprise Software
    (5,505)
  6. Linux
    (64,642)
  7. Java
    (98,869)
  8. .NET Programming
    (131,922)
  9. MS SQL Server 2005
    (71,561)
  10. MySQL Server
    (46,532)