Tutorial by Examples: me

DECLARE CURSOR c_emp_to_be_raised(p_sal emp.sal%TYPE) IS SELECT * FROM emp WHERE sal < p_sal; BEGIN FOR cRowEmp IN c_emp_to_be_raised(1000) LOOP dbms_Output.Put_Line(cRowEmp .eName ||' ' ||cRowEmp.sal||'... should be raised ;)'); END LOOP; END; /

A downcast can be used to make use of a subclass's code and data inside of a function taking a parameter of its superclass. class Rat { var color = "white" } class PetRat: Rat { var name = "Spot" } func nameOfRat(🐭: Rat) -> String { guard let petRat = ...

Converts the specified string representation of a date and time to its DateTime equivalent using the specified format and culture-specific format information. The format of the string representation must match the specified format exactly. Convert a specific format string to equivalent DateTime Le...

Our server object is given an 'application' parameter which can be any callable application object (see other examples). It writes first the headers, then the body of data returned by our application to the system standard output. import os, sys def run(application): environ['wsgi.inpu...

Python's built-in crypto functionality is currently limited to hashing. Encryption requires a third-party module like pycrypto. For example, it provides the AES algorithm which is considered state of the art for symmetric encryption. The following code will encrypt a given message using a passphrase...

VB_Name specifies the class or module name. Attribute VB_Name = "Class1" A new instance of this class would be created with Dim myClass As Class1 myClass = new Class1

In VBA, this attribute is ignored. It was not ported over from VB6. In VB6, it creates a Default Global Instance of the class (a "shortcut") so that class members can be accessed without using the class name. For example, DateTime (as in DateTime.Now) is actually part of the VBA.Conversio...

VB_VarUserMemId (for module-scope variables) and VB_UserMemId (for procedures) attributes are used in VBA mostly for two things. Specifying the default member of a class A List class that would encapsulate a Collection would want to have an Item property, so the client code can do this: For i = 1...

let's generate a DataFrame first: df = pd.DataFrame(np.arange(10).reshape(5,2), columns=list('ab')) print(df) # Output: # a b # 0 0 1 # 1 2 3 # 2 4 5 # 3 6 7 # 4 8 9 drop rows with indexes: 0 and 4 using drop([...], inplace=True) method: df.drop([0,4], inplace=True) ...

INSERT INTO Invoices [ /* column names may go here */ ] VALUES (123, '1234abc', '2016-08-05 20:18:25.770', 321, 5, '2016-08-04'); Column names are required if the table you are inserting into contains a column with the IDENTITY attribute. INSERT INTO Invoices ([ID], [Num], [DateTime], [Tota...

Note: This example requires a valid Admob account and valid Admob ad code. Build.gradle on app level Change to the latest version if existing: compile 'com.google.firebase:firebase-ads:10.2.1' Manifest Internet permission is required to access the ad data. Note that this permission does not h...

There are two basic ways in which you can Insert a document Create a document, Then insert it var bucket = cluster.OpenBucket("default"); var document = new Document<dynamic> { Id = "doc_net", Content = new { name = &quo...

All of these main method styles can also be used with varargs: package my.program fun main(vararg args: String) { println("Hello, world!") }

Apart from the Javadoc documentation code can be documented inline. Single Line comments are started by // and may be positioned after a statement on the same line, but not before. public void method() { //single line comment someMethodCall(); //single line comment after statement }...

Same as above in the FOR SYSTEM_TIME FROM <start_date_time>TO <end_date_time> description, except the table of rows returned includes rows that became active on the upper boundary defined by the <end_date_time> endpoint. SELECT * FROM Employee FOR SYSTEM_TIME BETWEEN '201...

Returns a table with the values for all row versions that were active within the specified time range, regardless of whether they started being active before the <start_date_time> parameter value for the FROM argument or ceased being active after the <end_date_time> parameter value for t...

Returns a table with the values for all row versions that were opened and closed within the specified time range defined by the two datetime values for the CONTAINED IN argument. Rows that became active exactly on the lower boundary or ceased being active exactly on the upper boundary are included. ...

Returns the union of rows that belong to the current and the history table. SELECT * FROM Employee FOR SYSTEM_TIME ALL

Creating a temporal table with a default history table is a convenient option when you want to control naming and still rely on system to create history table with default configuration. In the example below, a new system-versioned memory-optimized temporal table linked to a new disk-based history t...

From emacs 24.4 package.el is avalable, and one way to install helm is to do it via MELPA. First, add the MELPA repository as package archive by putting following code somewhere in your ~/.emacs (or, ~/.emacs.d/init.el). (require 'package) ;; add the repository before the package-initialize. (...