Tutorial by Examples: ed

SELECT e.emp_id , e.first_name , e.last_name FROM employees e INNER JOIN managers m ON m.mgr_id = e.mgr_id WHERE m.mgr_id = 'M01' ; Results in: EMP_IDFIRST_NAMELAST_NAMEE02ErinMacklemoreE04RonSonswan Ultimately, for every manager we query for, we will see 1 or more employees returned.

If you need to execute a repeating sequence of the same action with different parameters, use the ‘Parameterized Controller’ 3rd party plugin from JMeter-Plugins project. You need to install this plugin first by following installation procedure. Let’s assume that we want to parameterize the login ...

Introduction Put simply, these are variables that are available in all scope in your scripts. This means that there is no need to pass them as parameters in your functions, or store them outside a block of code to have them available in different scopes. What's a superglobal?? If you're thinki...

Imagine many users all running a web application that is trying to increment a counter in the database. Each user must read the current count, add one and write out the updated value. To make sure no one reads the counter while someone else is is adding one we use a transaction: ref.transaction(fun...

In the previous example, we didn't end up needing the parentheses, because they did not affect the meaning of the statement. However, they are often necessary in more complex expression, like the one below. In C: plus(a, take(b, c)); In Haskell this becomes: (plus a (take b c)) -- or equivale...

DB backup Database backup is a must before starting any Dynamics CRM upgrade process. This is mandatory as to always have the option to rollback in case of any major roadblock. Wrong Estimation DO NOT underestimate the work involved in a CRM Upgrade process. Audit your current Microsoft Dynamics...

# Roll a 6 sided die, rand(6) returns a number from 0 to 5 inclusive dice_roll_result = 1 + rand(6)

public class NetworkConnection : IDisposable { string _networkName; public NetworkConnection(string networkName, NetworkCredential credentials) { _networkName = networkName; var netResource = new NetResource() {...

What if two (or several) otherwise dead objects reference one another? This is shown in the example below, supposing that OtherObject is a public property of FinalizableObject: var obj1 = new FinalizableObject1(); var obj2 = new FinalizableObject2(); obj1.OtherObject = obj2; obj2.OtherObject = ...

public class DependentScopedClass { //This class has no scoping annotations, so a new instance gets created at every injection point. @Inject public DependentScopedClass(SomeDependency someDependency) { doSomethingWith(someDependency); } } The default scope for...

@RequestScoped public class RequestScopedClass { //This class gets constructed once per Servlet request, and is shared among all CDI-managed classes within that request. @Inject public RequestScopedClass(SomeDependency someDependency) { doSomethingWith(someDependency); ...

@ApplicationScoped public class ApplicationScopedClass { //This class gets constructed once for the entire life of the application, and is shared among all CDI-managed classes throughout the life of the application. @Inject public ApplicationScopedClass(SomeDependency someDependenc...

@SessionScoped public class SessionScopedClass implements Serializable { //This class gets constructed once per session, and is shared among all CDI-managed classes within that session. Notice that it implements Serializable, since the instance will get put on the session. @Inject ...

:wqall Exiting multiple files with saving contents :qall! Exiting multiple files without saving contents

Bridge Mode $ docker run –d –-name my_app -p 10000:80 image_name Note that we did not have to specify --net=bridge because this is the default working mode for docker. This allows to run multiple containers to run on same host without any assignment of dynamic port. So BRIDGE mode avoids the por...

Dialog dlg; DialogGroup dGrp; DialogField dfName; dlg = new Dialog("Trivial Dialog"); dGrp = dlg.addGroup("A Group"); dfName = dlg.addField(extendedTypeStr(Name)); if (dlg.run()) { info(dfName.value()); } Extended data types have to be wrapped in a call to ext...

Dialog dlg; DialogGroup dGrp; DialogField dialogField; dlg = new Dialog("Evil Dialog"); dGrp = dlg.addGroup("A Group"); dialogField = dlg.addFieldValue(extendedTypeStr(NoYesId), NoYes::Yes, "I hereby sell my soul"); if (dlg.run()) { info(dialogField.valu...

The first example are keywords that have a special purpose in C++: the following is legal in C, but not C++. int class = 5 These errors are easy to fix: just rename the variable.

In C, pointers can be cast to a void*, which needs an explicit cast in C++. The following is illegal in C++, but legal in C: void* ptr; int* intptr = ptr; Adding an explicit cast makes this work, but can cause further issues.

Foreign Keys constraints ensure data integrity, by enforcing that values in one table must match values in another table. An example of where a foreign key is required is: In a university, a course must belong to a department. Code for the this scenario is: CREATE TABLE Department ( Dept_Code...