Tutorial by Examples: nd

CREATE BITMAP INDEX emp_bitmap_idx ON index_demo (gender); Bitmap index is used when data cardinality is low. Here, Gender has value with low cardinality. Values are may be Male, Female & others. So, if we create a binary tree for this 3 values while searching it will have unnecessary ...

CREATE INDEX first_name_idx ON user_data (UPPER(first_name)); SELECT * FROM user_data WHERE UPPER(first_name) = 'JOHN2'; Function based index means, creating index based on a function. If in search (where clause), frequently any function is used, it's better to create index based on ...

Suppose you need to work on three different projects project A, project B and project C. project A and project B need python 3 and some required libraries. But for project C you need python 2.7 and dependent libraries. So best practice for this is to separate those project environments. For creati...

To list the available databases, use the following command: $ show databases name: databases name ---- _internal devices ... list of your databases You can connect to one specific database: $ use <database_name> By using a single database, the scope for each subsequent query wi...

The NSInteger is just a typedef for either an int or a long depending on the architecture. The same goes for a NSUInteger which is a typedef for the unsigned variants. If you check the NSInteger you will see the following: #if __LP64__ || (TARGET_OS_EMBEDDED && !TARGET_OS_IPHONE) || TARGET_...

from multiprocessing import Pool def cube(x): return x ** 3 if __name__ == "__main__": pool = Pool(5) result = pool.map(cube, [0, 1, 2, 3]) Pool is a class which manages multiple Workers (processes) behind the scenes and lets you, the programmer, use. Pool(5) creat...

%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...

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>(...

You can define a function to be recursive with the rec keyword, so it can call itself. # let rec fact n = match n with | 0 -> 1 | n -> n * fact (n - 1);; val fact : int -> int = <fun> # fact 0;; - : int = 1 # fact 4;; - : int = 24 You can also define mutually re...

General Imports, using jinja2 to populate templates into htmls. import jinja2 import webapp2 Important import to use Users API: from google.appengine.api import users Setting of Jinja environment: [into the example the tehcnology selected to populate the information into the frontend] JINJ...

Simple extract of index.html: <div class="sign-in"> {% if user %} [Passing the url we have the opportunity to logout the user] <a href="{{ url|safe }}">LOG OUT</a> [You can include here operations for user authenticated] ...

Once you're up with a new project with the basic template provided in the Introduction, you should be able to add a LUISRecognizer like so - var model = '' // Your LUIS Endpoint link comes here var recognizer = new builder.LuisRecognizer(model); Now, recognizer is a LUISRecognizer and can pa...

Md2Collapse : Collapse is a directive, it's allow the user to toggle visiblity of the section. Examples A collapse would have the following markup. <div [collapse]="isCollapsed"> Lorum Ipsum Content </div> Md2Accordion : Accordion it's allow the user to toggle vis...

This example shows you different ways to execute 'commands' for Minecraft from code: EntityPlayerSP player = Minecraft.getMinecraft().player; player.sendChatMessage("/Command here"); to send a command in SinglePlayer

https://api.telegram.org/bot*BOTTOKEN*/sendmessage?chat_id=exampleID&text=exampleText&parse_mode=HTML What does this do? With your parameters adjusted correctly this call will send a message to the exampleID user with the exampleText as message with an HTML encoding. Standard encoding is ma...

Function using promises: function myAsyncFunction() { return aFunctionThatReturnsAPromise() // doSomething is a sync function .then(result => doSomething(result)) .catch(handleError); } So here is when Async/Await enter in action in order to get clean...

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...

Now we will apply a strided convolution to our previously described padded example and calculate the convolution where p = 1, s = 2 Previously when we used strides = 1, our slided window moved by 1 position, with strides = s it moves by s positions (you need to calculate s^2 elements less. But in...

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...