Tutorial by Examples

/* PL/SQL is a core Oracle Database technology, allowing you to build clean, secure, optimized APIs to SQL and business logic. */ set serveroutput on BEGIN DBMS_OUTPUT.PUT_LINE ('Hello World!'); END;

MySQL allows to specify from which table the matching rows must be deleted -- remove only the employees DELETE e FROM Employees e JOIN Department d ON e.department_id = d.department_id WHERE d.name = 'Sales' -- remove employees and department DELETE e, d FROM Emp...

Detailed instructions on getting pyspark set up or installed.

var record = nlapiCreateRecord('task'); record.setFieldValue('title', taskTitle); var id = nlapiSubmitRecord(record, true);

"MySQL Cluster" disambiguation... NDB Cluster -- A specialized, mostly in-memory, engine. Not widely used. Galera Cluster aka Percona XtraDB Cluster aka PXC aka MariaDB with Galera. -- A very good High Availability solution for MySQL; it goes beyond Replication. See individual page...

Limit root (and any other SUPER-privileged user) to GRANT ... TO root@localhost ... That prevents access from other servers. You should hand out SUPER to very few people, and they should be aware of their responsibility. The application should not have SUPER. Limit application logins to the one...

The "host" can be either a host name or an IP address. Also, it can involve wild cards. GRANT SELECT ON db.* TO sam@'my.domain.com' IDENTIFIED BY 'foo'; Examples: Note: these usually need to be quoted localhost -- the same machine as mysqld 'my.domain.com' -- a specific domain; th...

The Error Log is populated with start and stop information, and critical events encountered by the server. The following is an example of its contents: The variable log_error holds the path to the log file for error logging. In the absence of a configuration file entry for log_error, the system...

There are two ways to use MaterializeCSS, either you can download the files on your system or use the files from CDN (Content Delivery Network). Download files Download the Materialize Package. Download the Materialize SASS Package. Install via NPM: npm install materialize-css Install via Bow...

Draw stars with flexible styling (size, colors, number-of-points). // Usage: drawStar(75,75,5,50,25,'mediumseagreen','gray',9); drawStar(150,200,8,50,25,'skyblue','gray',3); drawStar(225,75,16,50,20,'coral','transparent',0); drawStar(300,200,16,50,40,'gold','gray',3); // centerX, centerY: ...

// Usage: drawLineWithArrows(50,50,150,50,5,8,true,true); // x0,y0: the line's starting point // x1,y1: the line's ending point // width: the distance the arrowhead perpendicularly extends away from the line // height: the distance the arrowhead extends backward from the endpoint // arrow...

// Usage: var p0={x:50,y:100}; var p1={x:100,y:0}; var p2={x:200,y:200}; var p3={x:300,y:100}; cubicCurveArrowHeads(p0, p1, p2, p3, 15, true, true); quadraticCurveArrowHeads(p0, p1, p2, 15, true, true); // or use defaults true for both ends with arrow heads cubicCurveArrowHeads(p0, p...

The code draws only the wedge ... circle drawn here for perspective only. // Usage var wedge={ cx:150, cy:150, radius:100, startAngle:0, endAngle:Math.PI*.65 } drawWedge(wedge,'skyblue','gray',4); function drawWedge(w,fill,stroke,strokewidth){ ctx.beginPath(); ...

// Usage: var arc={ cx:150, cy:150, innerRadius:75, outerRadius:100, startAngle:-Math.PI/4, endAngle:Math.PI } drawArc(arc,'skyblue','gray',4); function drawArc(a,fill,stroke,strokewidth){ ctx.beginPath(); ctx.arc(a.cx,a.cy,a.innerRadius,a.startAngle,a.endAngle); ...

Note: Browsers are in the process of adding a built-in context.ellipse drawing command, but this command is not universally adopted (notably not in IE). The methods below work in all browsers. Draw an ellipse given it's desired top-left coordinate: // draws an ellipse based on x,y being top-left...

When Canvas draws a line it automatically adds anti-aliasing to visually heal "jaggedness". The result is a line that is less jagged but more blurry. This function draws a line between 2 points without anti-aliasing using Bresenham's_line algorithm. The result is a crisp line without the ...

A regular polygon has all sides equal length. // Usage: drawRegularPolygon(3,25,75,50,6,'gray','red',0); drawRegularPolygon(5,25,150,50,6,'gray','gold',0); drawRegularPolygon(6,25,225,50,6,'gray','lightblue',0); drawRegularPolygon(10,25,300,50,6,'gray','lightgreen',0); function drawRegular...

The code below is all about 3 steps. Opening a chrome browser Opening google page Shutdown the browser import org.openqa.selenium; import org.openqa.selenium.chrome; public class WebDriverTest { public static void main(String args[]) { System.setProperty("webdriver.chr...

<?xml version="1.0" encoding="utf-8"?> <s:Application xmlns:fx="http://ns.adobe.com/mxml/2009" xmlns:s="library://ns.adobe.com/flex/spark" xmlns:mx="library://ns.adobe.com/flex/mx"> <s:Label text="Hello World!&...

adb devices Is your phone displaying? If not, enable developer mode on your phone, and connect it by USB. adb reverse tcp:8081 tcp:8081 : In order to link correctly your phone and that React-Native recognize him during build. (NOTE:Android Version 5 or above.) react-native run-andr...