DELIMITER $$
DROP PROCEDURE IF EXISTS sp_nested_loop$$
CREATE PROCEDURE sp_nested_loop(IN i INT, IN j INT, OUT x INT, OUT y INT, INOUT z INT)
BEGIN
DECLARE a INTEGER DEFAULT 0;
DECLARE b INTEGER DEFAULT 0;
DECLARE c INTEGER DEFAULT 0;
WHILE a < i DO
WHILE b <...
ANTLR contains a testing tool in its runtime library, this tool can be used to display information detailing how the parsing is performed to match input against defined rules in your grammar file.
To use this tool contained within the ANTLR jar file you should setup your systems classpath to allow ...
if we want to change the Controllers directory we need:
Move and/or rename the default Controllers directory where we want it. For example from app/Http/Controllers to app/Controllers
Update all the namespaces of the files inside the Controllers folder, making they adhere to the new path, re...
Methods may declared as friends as well as functions:
class Accesser {
public:
void private_accesser();
};
class PrivateHolder {
public:
PrivateHolder(int val) : private_value(val) {}
friend void Accesser::private_accesser();
private:
int private_value;
};
void Access...
This is a protected and non-static method of the Object class. This method is used to perform some final operations or clean up operations on an object before it gets removed from the memory.
According to the doc, this method gets called by the garbage collector on an object when garbage collecti...
Objective-C supports a special type called `instancetype that can only be used as type returned by a method. It evaluates to the class of the receiving object.
Consider the following class hierarchy:
@interface Foo : NSObject
- (instancetype)initWithString:(NSString *)string;
@end
@interf...
We know that 'best practise' dictates that a range object should have its parent worksheet explicitly referenced. A worksheet can be referred to by its .Name property, numerical .Index property or its .CodeName property but a user can reorder the worksheet queue by simply dragging a name tab or rena...
When working with multiple open Workbooks, each of which may have multiple Sheets, it’s safest to define and set reference to all Workbooks and Sheets.
Don't rely on ActiveWorkbook or ActiveSheet as they might be changed by the user.
The following code example demonstrates how to copy a range from...
Gnuplot is a portable command-line driven graphing utility.
This example will show how to setup gnuplot in the various platforms.
Windows
Download the latest version of the installer from gnuplot site.
Run the downloaded file and allow it to run as administrator if requested
On the ...
To delete all rows from the table
//get writable database
SQLiteDatabase db = openHelper.getWritableDatabase();
db.delete(TABLE_NAME, null, null);
db.close();
To delete all rows from the table and get the count of the deleted row in return value
//get writable database
SQLiteDatabase db =...
{
"description": "My awesome library",
"dependencies": {
"NETStandard.Library": "1.6.0"
},
"frameworks": {
"netstandard1.3": { }
}
}
A library that targets netstandard1.3 can be used on any fr...
R has a number of build in constants. The following constants are available:
LETTERS: the 26 upper-case letters of the Roman alphabet
letters: the 26 lower-case letters of the Roman alphabet
month.abb: the three-letter abbreviations for the English month
names
month.name: the English names fo...
To get help on a batch file command you can use the built-in help.
Open a command prompt (whose executable is cmd.exe) and enter help to see all available commands.
To get help for any of these commands, type help followed by the name of the command.
For example:
help help
Will display:
Prov...
This quickstart is written for Mac OSX Mavericks, and is a bit more verbose than other installation instructions. It should hopefully cover a few edge cases, such as setting your path, and configuring NPM, which can cause an installation to go awry.
# install meteor
curl https://install.meteor...
Expires — specifies date when the resource becomes stale. It relies on servers and clients having accurate clocks and supporting time zones correctly. Cache-control: max-age takes precedence over Expires, and is generally more reliable.
post-check and pre-check directives are non-standard I...
Managing AWS resources that scale up and down runs into the limits of the static inventory host file, that's why we need something dynamic. And that's what the dynamic inventories are for. Let's start:
Download these ec2.ini and ec2.py files to the your project folder:
cd my_ansible_project
wget...
Create a file named SCALA_PROJECT/build.gradle with these contents:
group 'scala_gradle'
version '1.0-SNAPSHOT'
apply plugin: 'scala'
repositories {
jcenter()
mavenCentral()
maven {
url "https://repo.typesafe.com/typesafe/maven-releases"
}
}
dep...
