Tutorial by Examples: ect

SELECT E.EMPLOYEE_ID,E.LAST_NAME,E.MANAGER_ID FROM HR.EMPLOYEES E CONNECT BY PRIOR E.EMPLOYEE_ID = E.MANAGER_ID; The CONNECT BY clause to define the relationship between employees and managers.

SELECT E.LAST_NAME|| ' reports to ' || PRIOR E.LAST_NAME "Walk Top Down" FROM HR.EMPLOYEES E START WITH E.MANAGER_ID IS NULL CONNECT BY PRIOR E.EMPLOYEE_ID = E.MANAGER_ID;

Returns a new deque object initialized left-to-right (using append()) with data from iterable. If iterable is not specified, the new deque is empty. Deques are a generalization of stacks and queues (the name is pronounced “deck” and is short for “double-ended queue”). Deques support thread-safe, me...

import spock.lang.* class HelloWorldSpec extends Specification { @Shared message = 'Hello world!' def "The world can say hello using when and then"() { when: def newMessage = message then: newMessage == 'Hello world!' } ...

This example will show you how to use Dependency Inject to use other services registered in the Drupal environment. Imagine you have an SVG image file that changes colors depending on some random CSS/Javascript thing in your project. To be able to target the SVG with CSS you have to actually have t...

Lets following are the class definition class A def a; end end module B def b; end end class C < A include B def c; end end What are the instance methods of C? C.instance_methods # [:c, :b, :a, :to_json, :instance_of?...] What are the instance methods that declare...

From the Welcome to Android Studio dialogue box, select New Project... to open the Create New Project dialog. In the New Android Application dialog, under Application name, specify an appropriate application name. The remainder of this tutorial uses BasicMapSolution as the application name....

A Vector3 structure can be created in several ways. Vector3 is a struct, and as such, will typically need to be instantiated before use. Constructors There are three built in constructors for instantiating a Vector3. ConstructorResultnew Vector3()Creates a Vector3 structure with co-ordinates of...

There are two components to the Unicorn data provider: the database-specific implementation, and the Unicorn implementation. The Unicorn implementation is an individual configuration of Unicorn dependencies that get automatic serialization. For example, if you were serializing two presets you'd nee...

To mock a protected member you must first include the following at the top of your test fixture: using Moq.Protected; You then call Protected() on your mock, after which you can use the generic Setup<> with the return type of your method. var mock = new Mock<MyClass>(); mock.Protec...

You are an Outlook user and understand terms such as “email”, “received time”, “subject” and “Folder Pane”. You know how to access Outlook’s Visual Basic Editor and create a module. See Introduction Part 1 if necessary. You have at least a basic knowledge of VBA. I declare Subroutines and variab...

Many ls() queries are intended to find a single object, but ls always returns a list (or, in older Mayas, a single None). This creates complicated error checking for a simple question. The easiest way to get a single value from an ls under any circumstances is result = (cmds.ls('your query here'...

In Swift, protocol extensions cannot have true properties. However, in practice you can use the "associated object" technique. The result is almost exactly like a "real" property. Here is the exact technique for adding an "associated object" to a protocol extension: ...

The preferred and most common way of making an NSFont object is the following: Objective-C // Name is PostScript name of font; size is in points. NSFont *essayFont = [NSFont fontWithName:@"Times New Roman" size:12.0];

Here we are managing multiple collection there delegate methods with didselect events. extension ProductsVC: UICollectionViewDelegate, UICollectionViewDataSource{ // MARK: - UICollectionViewDataSource func collectionView(_ collectionView: UICollectionView, numberOfItemsI...

The following updates a User object via a PUT request and prints the status code of the request: package main import ( "bytes" "encoding/json" "fmt" "net/http" ) type User struct { Name string Email string } func main...

Here's a basic example of how to do a very simple class system Class = {} local __instance = {__index=Class} -- Metatable for instances function Class.new() local instance = {} setmetatable(instance, __instance) return instance -- equivalent to: return setmetatable({}, __instance)...

Having local Class = {} Class.__meta = {__index=Class} function Class.new() return setmetatable({}, Class.__meta) Assuming we want to change the behavior of a single instance object = Class.new() using a metatable, there are a few mistakes to avoid: setmetatable(object, {__call = table.conca...

Incorrect code Sub DoSomething() Dim foo As Collection With foo .Add "ABC" .Add "XYZ" End With End Sub Why doesn't this work? Object variables hold a reference, and references need to be set using the Set keyword. This error occurs whenever ...

To deploy Java code to AWS Lambda, you have to create a distribution zip file that contains all dependencies that are needed during the runtime. Example project in Gradle: apply plugin: 'java' repositories { mavenCentral() } dependencies { compile 'com.amazonaws:aws-lambda-java-cor...