Oracle Database

77K

Solutions

101

Articles & Videos

22K

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

Hi,

   I have a table A with field1 that I want to left join into other tables B and C (B & C are queries resultsets). After , matching up this field1 with table B, I want to concat column B2 value…

427 views
Anonabox PRO Tor & VPN Router

PRO is the most advanced way to fortify your privacy and online anonymity by layering the Tor network with VPN services. Use both together or separately, and without needing to download software onto your devices.

Hi All,

I have created a simple insert query to move the contents of table A into table B (there is some additions made in this process).

(CODE)

However, this scrambles the order of the rows.…

812 views

In my query, I use the following code:

 (SELECT  lpad(trunc(sum(prt.hours)*100),6,'0')  
       FROM prod.prtime prt
       WHERE( prt.tr_date >= add_months(trunc(sysdate, 'mm'),-12)
         …

928 views

When executing the following query, is there a way that I can insert a blank row in between both queries where the union all is?  Thanks!

(CODE)

416 views

Is there a way I can output the results of both queries stacked on top of one another?
The desired results would look the same as running the queries seperately except with the results of both querie…

223 views

I'm trying to write a query with the following code:

left outer join APVENMAST on PROCUREGRP.VENDOR_GROUP=APVENMAST.VENDOR_GROUP and POVARGMTHD.VENDOR=APVENMAST.VENDOR

But get the following erro…

324 views

I have an existing Oracle database on a server that I need to copy to a new server. The old server is running version 11g Release 11.2.0.1.0. The new server is running version 12c Release 12.1.0.2.0. …

1528 views

Hi experts,
I have created a new database db2 in 11g. The reason is to import all data (using datapump) from existing database db1 which is Oracle 10g.
The import process went well. I manage to see …

829 views

Hello Experts,

I have a sample chart data something very similar to the below:



Now I want to get the output something below:



looking for the SQL which will bring the output similar t…

424 views

DECLARE
    v_connection             UTL_SMTP.connection;
    -- mime blocks (the sections of the email body that can become attachments)
    -- must be delimited by a string, this particular strin…

129 views
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Its a broad question. The queries and plsql jobs are running slower on a 12c  database upgraded from 11g. All things being same, hardware, parameters etc, is 12c slower than 11g out of the box? Are th…

1062 views

I have a main query that has many other fields being listed.
One of last remaining fields I need is the summation of the hours in a 12 month period.
The code I have below works, but I'm having a har…

938 views

Hi team,

I need to write a query using Oracle SQL , where in I need to generate an DRILL DOWN report . I need to generate this using queries no reporting tools.  
Any sample example to do so will …

1236 views

I'm using the following code to format the ssn#s :
to_char(replace(emp.fica_nbr,'-'),999999999) SSNBR

The only issue is if a ssn# starts with 0, it is being omitted.
How can I adjust the code to …

219 views

I have a field that is set up as a number 13,4.
I need to format it so that it looks like the following: 9999999V99.

I was trying to use the following formula, but its not working:
to_char(emp.pr…

1025 views

Hi

i just installed oracle 12C on windows 2012R2

now i want to apply patches but i got this error

please check the attached file

what can do to fix this kindly advice

219 views

Hello Experts,

Is there a way to search an Oracle 12c database to find a specific value in a specific column for all tables that have that column? For example, if the column name is CASE_ID and the…

830 views

Hi Experts,

I have a selector screen eg frmSelector1, what it means is when the form is shown it is loaded with bunch of records. Now i need to give a search button in the screen and i need to make…

231 views

We put engines on the planes, Each engine has time_since_new - eg 22538 (in hours)

We also have a customer profile that we say that for this customer the life limit hours is 50000 ( hours)
Now I w…

618 views
Course: Foundations of Front-End Development

Jump-start a lucrative career in front-end web development, with zero previous coding experience required. This course covers the basic programming concepts and languages required for creating engaging websites from scratch.

(CODE)



M - Months
Y   Years
W  Weeks.
 
Right now I do not have data with weeks.

I need to take that value and convert to days.  Can I get a query to get these values?

925 views

(CODE)



I have included a screen print that shows the shelf life. It may be years, days, weeks etc. So I want one function that can take input of shelf life and convert to days and get the perce…

1727 views

Experts,

I'm looking for input on ideas to keep in mind when planning and creating a MEDICAID data warehouse. This data will be used to help identify WASTE, FRAUD AND ABUSE.

Has anyone worked on…

326 views

I have the following code that will give me the sum of the last hours worked in a 12 month period.
(SELECT sum(prt.hours)
       FROM prod.prtime prt
       WHERE prt.tr_date BETWEEN TRUNC (ADD_…

121 views

Hello Experts,

I need to show the count of arrests by day, week, and month. The daily count should be a distinct count because an ssn should only be counted once in a single day. The weekly count o…

655 views

We recently used a free version of the Solar Winds db performance analyzer to track some problems we were having with our SQL and Oracle db's.  We thought the tool worked great and it was quite helpfu…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (47,098)
  2. Databases
    (53,335)
  3. MS SQL Server
    (156,068)
  4. Unix OS
    (32,624)
  5. Enterprise Software
    (5,492)
  6. Linux
    (64,144)
  7. Java
    (98,436)
  8. .NET Programming
    (131,271)
  9. MS SQL Server 2005
    (71,393)
  10. MySQL Server
    (46,186)