Tutorial by Examples: ce

It is possible to DELETE data from a table if it matches (or mismatches) certain data in other tables. Let's assume we want to DELETEdata from Source once its loaded into Target. DELETE FROM Source WHERE EXISTS ( SELECT 1 -- specific value in SELECT doesn't matter FROM Target ...

Pre-requisites AEM Installed on your server. Copy the path of the install (e.g: /mnt/crx) Start AEM (e.g java -jar cq-quickstart-author-p4502.jar) once. This will generate all the necessary folders, especially /mnt/crx/crx-quickstart/bin that is required by the scripts. Create a user who will h...

%TYPE: Used to declare a field with the same type as that of a specified table's column. DECLARE vEmployeeName Employee.Name%TYPE; BEGIN SELECT Name INTO vEmployeeName FROM Employee WHERE RowNum = 1; DBMS_OUTPUT.PUT_LINE(vEmp...

In this example we are going to create a view. A view is mostly used as a simple way of fetching data from multiple tables. Example 1: View with a select on one table. CREATE OR REPLACE VIEW LessonView AS SELECT L.* FROM Lesson L; Example 2: View with a select o...

Parameter TypesReturn TypeInterface()voidRunnable()TSupplier()booleanBooleanSupplier()intIntSupplier()longLongSupplier()doubleDoubleSupplier(T)voidConsumer<T>(T)TUnaryOperator<T>(T)RFunction<T,R>(T)booleanPredicate<T>(T)intToIntFunction<T>(T)longToLongFunction<T>(...

creating custom exception 'P2222': create or replace function s164() returns void as $$ begin raise exception using message = 'S 164', detail = 'D 164', hint = 'H 164', errcode = 'P2222'; end; $$ language plpgsql ; creating custom exception not assigning errm: create or replace function s...

This covers how you can create a basic 2D game using SurfaceView. First, we need an activity: public class GameLauncher extends AppCompatActivity { private Game game; @Override public void onCreate(Bundle sis){ super.onCreate(sis); game = new Game(GameLauncher....

`To calculate 1D convolution by hand, you slide your kernel over the input, calculate the element-wise multiplications and sum them up. The easiest way is for padding=0, stride=1 So if your input = [1, 0, 2, 3, 0, 1, 1] and kernel = [2, 1, 3] the result of the convolution is [8, 11, 7, 9, 4], whic...

Parallel Testing with Appium using GRID: I will describe the way which worked for me. Create Selenium Grid with Appium Setup the selenium grid Download selenium standalone server jar on local file system Open your terminal and navigate to the directory to where you placed the jar file and exe...

The following permissions are required to use the Bluetooth APIs: android.permission.BLUETOOTH android.permission.BLUETOOTH_ADMIN If you're targeting devices with Android 6.0 (API Level 23) or higher and want to perform scanning/advertising operations you will require a Location permission: a...

You can use Bluetooth LE Advertising to broadcast data packages to all nearby devices without having to establish a connection first. Bear in mind that there's a strict limit of 31 bytes of advertisement data. Advertising your device is also the first step towards letting other users connect to you....

import nltk from nltk.tokenize import sent_tokenize, word_tokenize text = 'We saw the yellow dog' word = word_tokenize(text) tag1 = nltk.pos_tag(word) print(tag1)

This section will contain some of the most advanced examples realized using Multithreading. Advanced printer (logger) A thread that prints everything is received and modifies the output according to the terminal width. The nice part is that also the "already written" output is modified w...

Methods used: .DriveExists(strDrive) returns (True/False) .FileExists(strFile) returns (True/False) .FolderExists(strFolder) returns (True/False) The following code checks for the existence of a file using the "FileExists" method of a file system object. For checking the existence of...

Methods used: .GetFolder(strPath) - Returns an object referring to the path We can set an object reference to a folder using the getFolder method and perform different operations on them. Code: Dim strFolderPath, objFso, objFolder strFolderPath = "C:\Users\GS\Desktop\LogsFolder" Se...

Methods Used: .GetFile(strPath) - Returns an object referring to a file. We can set an object reference to a file using the getFile method and perform different operations on them. Code: Dim strFilePath, objFso, objFile strFilePath = "C:\Users\GS\Desktop\LogsFolder\file.txt" Set ob...

EQ checks if two values have the same address of memory: in other words, it checks if the two values are are actually the same, identical object. So, it is can be considered the identity test, and should be applied only to structures: conses, arrays, structures, objects, typically to see if you ...

An instantiated system can be accessed through the scene: document.querySelector('a-scene').systems[systemName]; Registered system prototypes can be accessed through AFRAME.systems.

A component’s members and methods can be accessed through the entity from the .components object. Look up the component from the entity’s map of components, and we’ll have access to the component’s internals. Consider this example component: AFRAME.registerComponent('foo', { init: function () { ...

Components can be attached to the scene as well as entities. A-Frame ships with a few components to configure the scene: ComponentDetailsembeddedRemove fullscreen styles from the canvas.fogAdd fog.keyboard-shortcutsToggle keyboard shortcuts.inspectorInject the A-Frame Inspector.statsToggle performa...