Blogs
Submitted by John Watson on Tue, 2019-11-26 11:11
Oracle corporation will (as of 24 September 2019) support customers running on VMware.
Submitted by cristine_katia on Wed, 2019-11-13 15:21
Good afternoon people!
I have a procedure in Oracle with various functions of calculations, type simulator. So, I want to assemble a type with output parameters reading this data and bring the results of these functions in real time, because I want to display them as output lines on a front (web screen). I already created the types objects and table. However, I am having difficulty assembling, because I do not know well Type. Can someone help me? Thanks
Submitted by John Watson on Mon, 2019-11-04 10:20
A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database.
Submitted by jp_vijaykumar on Sun, 2019-09-22 16:16
Decision Tree Algorithm in pl/sql
Author JP Vijaykumar
Date Sept 14th 2019
Submitted by younus on Wed, 2019-07-17 04:57
SELECT tablespace_name ,round(TOTAL_SIZE,2) ,round(TOTAL_SIZE-FREE_SIZE,2) ,
round(FREE_SIZE,2)
FROM (SELECT tablespace_name,(SELECT SUM(BYTES)/1024/1024/1024 FROM DBA_DATA_FILES b WHERE b.TABLESPACE_NAME=a.TABLESPACE_NAME)TOTAL_SIZE,
SUM(bytes)/1024/1024/1024
FREE_SIZE
FROM DBA_FREE_SPACE a GROUP BY tablespace_name) order by 1;
Submitted by jp_vijaykumar on Fri, 2019-03-08 20:13
Tablespace Capacity Planning Report
Author JP Vijaykumar
Written Sep 14 2017
Modified Mar 08 2019
***************************************************************************************************************
This script is provided for enducational purpose only.
The readers are advised to make necessary changes to the script as may be required for their use in their repective environments.
Pls test this script thoroughly in a lower environment, before using in any production db.
Submitted by jp_vijaykumar on Fri, 2019-03-08 20:11
********************************************************************************
APRIORI ALGORITHM
********************************************************************************
Modified March 08 2019
Submitted by jp_vijaykumar on Fri, 2019-03-08 20:09
********************************************************************************
--LINEAR REGRESSION ALGORITHM IN PL/SQL
--------------------------------------------------------------------------------
Modified Mar 8th 2019
Using Linear Regression algorithm, find the weight of a studen, whose is 71 inches tall.
Given the height and weight of 8 students.
Submitted by jp_vijaykumar on Sat, 2019-01-05 18:03
--NAIVE BAYES ALGORITHM WITH SQL & PL/SQL
---------------------------------------------------------------------------------
--Written JP Vijaykumar
--Date Jan 4th 2019
--This script is provided for educational purpose only.
--The readers are advised to make necessary changes as may be required for their use.
--I love data mining algorithms for their complexity and number crunching toughest logic.
--Academically, I want to generate Naive Bayes algorythm in pl/sql to predict the outcome.
Submitted by Devart on Tue, 2018-12-18 23:25
We are happy to bring our sincere congratulations with upcoming Christmas and New Year holidays! It’s time for miracles and gifts, so try yourself at Devart’s Christmas Quest to get winter holiday discounts.
Help Santa to count a salary for his Elves so that they deliver other presents. With this purpose, Santa uses SQL query, but he is not so good in SQL. Please, help him to build the proper query! Santa Claus is about to pay generously to everyone who helps him!
Pages
|