Tutorial by Examples: s

You can execute anonymous block. This example shows also how to return value from dynamic SQL: declare query_text varchar2(1000) := 'begin :P_OUT := cos(:P_IN); end;'; in_value number := 0; out_value number; begin execute immediate query_text using out out_value, in in_value; dbms_o...

It's very easy to install nedb. npm install nedb --save # Put latest version in your package.json For bower loving people, bower install nedb

Basically, in order to insert records to nedb, the data is stored in the form of json with the key being the column names and the value for those names will be the values for that record. var rec = { name: 'bigbounty',age:16}; db.insert(rec, function (err, newrec) { // Callback is optional ...

In order to search for records in nedb, again we need to just pass the json containing the search criteria as a parameter to the find function of db object. db.find({ name: 'bigbounty' }, function (err, docs) { // docs is an array containing documents that have name as bigbounty // If no docu...

How comp, comp-1 ... comp-5 are implemented is implementation dependent. Format Normal Implementation Comp Big endian binary integer Comp-1 4 byte floating point Comp-2 8 byte floating point Comp-3 Packed decimal 123 is stored as x'123c' Comp-5 Binary In...

The default style files generated and compiled by @angular/cli are css. If you want to use scss instead, generate your project with: ng new project_name --style=scss If you want to use sass, generate your project with: ng new project_name --style=sass

Yarn is an alternative for npm, the default package manager on @angular/cli. If you want to use yarn as package manager for @angular/cli follow this steps: Requirements yarn (npm install --global yarn or see the installation page) @angular/cli (npm install -g @angular/cli or yarn global add @an...

Let's write a small program which will open a window, and write "Hello World" on the screen. #include <SFML\Graphics.hpp> #include <cassert> int main() { sf::RenderWindow sfmlWin(sf::VideoMode(600, 360), "Hello World SFML Window"); sf::Font font; /...

.container has one fixed width for each screen size in bootstrap (xs,sm,md,lg); .container-fluid expands to fill the available width. @media (min-width: 568px) { .container { width: 550px; } } @media (min-width: 992px) { .container { width: 970px; } } @media (min-width: 1...

In order to view tables in a database, use the .tables command. Example: sqlite> .tables table1 table2 table3 table4 table5

This is a simple example on how you can automate tests for a console application that interact with standard input and standard output. The tested application read and sum every new line and will provide the result after a single white line is provided. The power shell script write "pass"...

=> Original Post <= ASP.NET Core uses the ASPNETCORE_ENVIRONMENT environment variable to determine the current environment. By default, if you run your application without setting this value, it will automatically default to the Production environment. > dotnet run Project TestApp (.NETC...

$a = 5; $b = 10; $a <=> $a; // 0, because $a == $a $a <=> $b; // -1, because $a < $b $b <=> $a; // 1, because $b > $a

Creation Steps Start Visual Studio 2013 as administrator Install Visual Studio extension Microsoft Visual Studio Installer Projects Create a class library project (WinFormActivex) Create your example window form (MainWindow) Create a new component interface(ILauncher) Create a new security i...

Please me mindful of importing all necessary libraries required. This example uses InMemoryDbService from angular-in-memory-web-api to provide the JSON data from mock API. Live demo service.ts: import { Injectable } from '@angular/core'; import { Headers, Http } from '@angular/http'; import...

The machine learns to predict an output when given an input. Each training case consists of an input and a target output. Regression The target ouput takes continuous values. Predicting the price of a stock Predicting a house price Classification The target output is a class label. Wha...

Unsupervised learning allows us to approach problems with little or no idea what our results should look like. We can derive structure from data where we don't necessarily know the effect of the variables. The most common type of unsupervised learning is cluster analysis or clustering. It is the ta...

Many modern Image Processing algorithms use patches are their basic element to work on. For instance one could denoise patches (See BM3D Algorithm). Yet when building the image form the processed patches we have many results for the same pixel. One way to deal with it is taking the average (Empir...

There are two ways to push an element to an array: array_push and $array[] = The array_push is used like this: $array = [1,2,3]; $newArraySize = array_push($array, 5, 6); // The method returns the new size of the array print_r($array); // Array is passed by reference, therefore the original ar...

This is a simple code creating 6 3d-subplots and in the end syncing the color displayed in each of them. c_fin = [0,0]; [X,Y] = meshgrid(1:0.1:10,1:0.1:10); figure; hold on; for i = 1 : 6 Z(:,:,i) = i * (sin(X) + cos(Y)); ax(i) = subplot(3,2,i); hold on; grid on; surf(X, Y, Z(...