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

I would like to validate that the a specific "user" is executing my bash shell script.  In my development environment some developers mistakenly execute my script as themselves or the "root" user.  Ne…

427 views
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.

I am calling an Oracle function, and am getting this runtime error :
ORA-01008: not all variables bound.

Can someone spot the problem here? In the function declaration I have three variable define…

622 views

I'm struggling creating a simple stored procedure within Oracle.  What am I missing from this query?

(CODE)

Basically in my report, I want user to be able to input a transaction date.

1632 views

We have a total of 60 distinct Prefixes in our client database due to having a text field to allow users to do the input.
We want to have a dropdown to limit the available prefixes and modify the cur…

528 views

I am using Oracle Sql developer to develop and run my sql code.

I have two stored procedures where the first procedure calls the second stored procedure. I don't have the actual code with me right …

225 views

I'm a little puzzled by this. Take the following script:
(CODE)
It would appear that if I run all 3 in order it does exactly as expected. It creates the table, creates the index, and adds the primar…

517 views

I'm writing a query to select some records. I have this data (Table name Sessions):
(CODE)
What I need is some way to match records from another table where I have this data (Table name WAL):

616 views

hi i have this sqql select empno,hire_date from employee where hire_date is null am geting 0 rows bust when i do select * from employee i can see empty value in hire_date column
hire_date date dataty…

1570 views

Hi Experts,
   
I have  sample entries  for a field FileName in  a table FileTable  ( Database is Oracle 11g)

    FileName
========
   file1.pdf
   file2.xls
   file3.xlsx
   file4.doc
   …

1831 views

scheduler for Procedure in DB with 3 arguments in 10g.

Can you please share the steps how to schedule a Job in Database .

710 views
A Knowledge Base That Stays Up-to-Date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

I want to concat multi row values of a given field in oracle. For a simple illustration, say, multiple grades of a studentID field

Table
StuID  Subject Grade
1      MATH      60
1      SCI      50
2      MATH      80
2      SC…

641 views

I am having problems connecting to an Oracle database from my C# WCF service. In the WCF service I am already connecting to multiple DB2 and SQL databases successfully via the following ole connection…

2252 views

I have inherited a VERY old Mapics System running on Oracle8i Release 8.1.7.0.0 - Production

I need to know where I could look to find Current numbers, next available numbers and Max Number using P…

220 views

I am reading off a CSV file with some hours, but this is a string.  The "Labor" column have values such as followed:

:15
2:30
4:00
:00
etc...

When I do my test in SQL Developer, I can conver…

726 views

Does Oracle or AWS allow to configure separate propagation delays for insert/update/delete operations?

738 views

Hello,

I would like to know which RAID is better for a simple Oracle Standard database.
One schema with its own DATAFILE and INDEX.
OS : MS Windows 2012 R2 or MS Windows 2016 or on a Linux Debian…

427 views

In the attached table the column remark has the data as shown. I need to extract the part of the string after the alphabet "k" where "k" is included and in the third row it should return null as "k" i…

922 views

Hi All,

I need to extract from a list below only the first word. Data is a little tricky, in few lines, there is no space after the first comma. Using Oracle 11g.

BOLT, ELEVATOR: 5/16", 2"LG, …

223 views

Hi,

  I have this database that is currently running using ASM, and i need to migrate it to local file system, how can i do that ?

  It is a Windows server.

  Any tips or documentation can …

117 views
Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Hi - My data is like below

Col1   COL2                 col3
A      12-Apr-13      12-APR-16 09.27.20.000000000 AM
B      12-Apr-13      12-APR-16 09.27.34.000000000 AM
A      12-Apr-13      13-APR-16 09.27.34.000000000 AM
A…

445 views

My work group has a requirement to have all Oracle Managed accounts locked and expired while not being used.  In addition all accounts shall change passwords periodically.  We have experimented with u…

221 views

Hello Experts:

I am being asked to do the following in Oracle 11gR2:

"We jsut need enough space to write the date. Right now it is set to 1, which is not sufficient. Given that Orcale captures t…

1146 views

Need a step-by-step database clone/duplicate procedure.  My platform is Solaris 11 OS, and Oracle 12c single-instance database.  Oracle documentation I have found has more options than we need.  Our s…

528 views

Environment is a single-instance Oracle 12c database.  We want all our DBAs to have their own accounts with sysdba privilege with admin option.  Want to prevent DBAs from connecting:  sqlplus / as sys…

541 views

I am stuck and looking at examples, but cannot find any good examples of how to read a csv file and loading the data into an oracle table.  Most examples I found indicate using sqlloader or toad, but …

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (47,304)
  2. Databases
    (53,501)
  3. MS SQL Server
    (156,713)
  4. Unix OS
    (32,684)
  5. Enterprise Software
    (5,501)
  6. Linux
    (64,383)
  7. Java
    (98,640)
  8. .NET Programming
    (131,569)
  9. MS SQL Server 2005
    (71,488)
  10. MySQL Server
    (46,367)