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

Hi,
I have this query below where i want to check if a "CLOSE_TIME < OPEN_TIME"
(CODE)

The problem i have is that the close and open time are VARCHAR2(4 CHAR) data type.

ex:
ID = 12345

48 views
On Demand Webinar - Networking for the Cloud Era
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

These are the raw data:

Current  Title        Start Date      End Date      Job
No                      1/1/2000        12/1/2001      Intern
No                      2/2/2002       7/1/2003      Cashier
No                     9/2/2003               …

1220 views

here is the script and output that I am trying to run
I have this setup with various sql statements on other unix systems and they run with no issues
runs from the command line with no issues
AIX …

4630 views

I have a table with a BLOB field type.  This field has multiple lines, but I only one to retrieve the line with a specific keyword.

So my data can be like this:

TEST MATERIAL
COMMENT:  Approved…

218 views

I have a C#/asp.net web application which connects to Oracle. Based upon the connection string I need to find out the name of the Oracle database which is being accessed. The connection string works …

1341 views

Hi experts

i have this error ORA-01843: not a valid month, this is the query
select i.visita_id,
       it.num_documento,
       it.tipo_ingreso,
       it.nombre_completo,
i.create_date,
   …

1418 views

Hello experts i have an query,  I want to track an employee login and logout information from a table .

suppose an employee did login/logout throughout a day  and all info tracked into a table

855 views

What is partition purning .

 How can we optimize partition table perfomance  when performing DML operation .

120 views

What is mutateing error & when it occer. How to handel mutateing .

326 views

I have a web service called form an asp.net page. It originally inserted records into a SQL Server table, but that now needs to be Oracle. It works for SQL Server, but in trying to get it to work with…

839 views
Industry Leaders: We Want Your Opinion!
Industry Leaders: 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!

How to add to the right side of table A ,  the colums and data of 2 other tables B and C .
Example:
table A: col1 (pk) , col2  -- 10 rows
table B: col3 (pk) , col4  -- 10 rows
table C: col5 (pk) ,…

931 views

I would like to find data from a table where created_DT is between the last day of the previous month and then 45 days prior to the last day of the previous month

How can I do this ?

220 views

Dear Gurus,

My DATABASE got SHUTDOWN and then START automatically only the DATABASE not the server its self.

Can someone help me to identify what will be the reason DB SHUTDOWN AND START …

1134 views

Please forgive if this has already been asked/answered. I've searched and searched and couldn't find anything...

I came across a column value in a table which isn't UTF-8. In Toad it comes across …

1138 views

Hello,
I have the below where clause   in sql:
(CODE)
Please help me translate this to oracle

933 views

I have a table of individuals with the typical attributes (Individual ID (PK), name, address, city, state, zip)
These people can each belong to a number of groups.  Each group having a number.
So …

256 views

My procedure is passed a comma-separated list of IDs, for example 7369,7499,7839,7902. I tried to use it in my code like this:

declare
   p_empno_list constant varchar2(20) := …

646 views

Hi I have a table which returns data as per the following - eg

Select * from Mytable

Name    ID      Ref1     Ref2     Ref3    
ABCD     1         10        12          14        
ABCD     2…

624 views

I have two tables and want to pull records from table A when a matching row is not in table B

But i need to look at three fields - so OrderNumber, OrderDate, CustomerID would need to be in Table A …

537 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!

Hi ,

I am having trouble scheduling a job to run on the 1st of every quarter even if 1st of the month is Saturday.
Here is what I am working with:

BEGIN
DBMS_JOB.CHANGE
(20,
null,
null,

1637 views

I start a query :

select  DEPARTMENT ,
sum(WORKLOAD) Number
from  group by DEPARTMENT

The result is a table like this :
DEPARTMENT    NUMBER
1      23
2      12
3      3
5      90

I …

541 views

Hello All,
I have the below query which pulls  data from current date to 12 months back..
(CODE)
I want to change the above code date range to run from the last day of the previous month and back …

641 views

I'm using XMLSEQUENCE on a cursor to create xml parts. In general this works fine.
However for any column in the cursor having a null value, no xml tag is returned, while I need an empty tag to be …

1045 views

Hello,

I have this attached java program that basically reads data from an oracle table which has a CLOB column. In this case, it is "Document" column. What I need is to parse the CLOB into …

340 views

Our shop consists of an Oracle 12c RAC database configured with (3) nodes. Each (3) instances run on its own independent servers (separate box).  We are currently running Oracle's OEM Performance …

346 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