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.
Articles & Videos
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.
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…
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).
However, this scrambles the order of the rows.…
In my query, I use the following code:
FROM prod.prtime prt
WHERE( prt.tr_date >= add_months(trunc(sysdate, 'mm'),-12)
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!
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…
I'm trying to write a query with the following code:
left outer join APVENMAST on PROCUREGRP.VENDOR_GROUP=AP
But get the following erro…
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 126.96.36.199.0. The new server is running version 12c Release 188.8.131.52.0. …
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 …
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…
-- mime blocks (the sections of the email body that can become attachments)
-- must be delimited by a string, this particular strin…
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…
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…
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 …
I'm using the following code to format the ssn#s :
The only issue is if a ssn# starts with 0, it is being omitted.
How can I adjust the code to …
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:
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
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…
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…
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…
M - Months
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?
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…
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…
I have the following code that will give me the sum of the last hours worked in a 12 month period.
FROM prod.prtime prt
WHERE prt.tr_date BETWEEN TRUNC (ADD_…
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…
How Oracle Stores Passwords Sean D. Stuber 2009-06-09 Up to date through Oracle version 11g Overview: Many times a DBA may want to replicate a user from one syste…
How to Send Email Attachments with Oracle PL/SQL
By Sean D. Stuber
Part I: How to Authenticate to an SMTP server with Oracle PL/SQL (http://www.experts-exchan