Tutorial by Examples: nd

select :start_value + level -1 n from dual connect by level <= :end_value - :start_value + 1

Yu can define format of the file that will be imported using FORMATFILE option: INSERT INTO mytable SELECT a.* FROM OPENROWSET(BULK 'c:\test\values.txt', FORMATFILE = 'c:\test\values.fmt') AS a; The format file, format_file.fmt, describes the columns in values.txt: 9.0 2 1 SQ...

As with everything in Windows Azure, You have to have a Windows Azure account and an Azure Subscription. After you have both, go to https://portal.azure.com. From here, you can add new resources to your Azure subscription. Click New on the left menu.A new blade will be added to the right of you...

There are three ways to quote something using a Julia function: julia> QuoteNode(:x) :(:x) julia> Meta.quot(:x) :(:x) julia> Expr(:quote, :x) :(:x) What does "quoting" mean, and what is it good for? Quoting allows us to protect expressions from being interpreted as sp...

Data sets often contain comments that explain the data format or contain the license and usage terms. You usually want to ignore these lines when you read in the DataFrame. The readtable function assumes that comment lines begin with the '#' character. However, your file may use comment marks like ...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task; task body My_Task is begin for I in 1 .. 4 loop Put_Line ("Hello from My_Task"); end loop; end; begin Put_Line ("Hello from Main"); end; Result The order of Put...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task; task body My_Task is begin for I in 1 .. 4 loop Put_Line ("Hello from My_Task"); end loop; end; begin for I in 1 .. 4 loop Put_Line ("Hello from Main"); e...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task_1; task My_Task_2; task body My_Task_1 is begin for I in 1 .. 4 loop Put_Line ("Hello from My_Task_1"); end loop; end; task body My_Task_2 is begin for ...

Query store can be enabled on database by using the following command: ALTER DATABASE tpch SET QUERY_STORE = ON SQL Server/Azure SQL Database will collect information about executed queries and provide information in sys.query_store views: sys.query_store_query sys.query_store_query_text sy...

LINQ extension methods on IEnumerable<T> take actual methods1, whether anonymous methods: //C# Func<int,bool> fn = x => x > 3; var list = new List<int>() {1,2,3,4,5,6}; var query = list.Where(fn); 'VB.NET Dim fn = Function(x As Integer) x > 3 Dim list = New List F...

Add the readonly attribute to prevent user input. A readonly field can't be edited <input class="form-control" type="text" placeholder="Readonly input here…" readonly> Add the disabled attribute to disable an input field. A disbled field can't be edited either...

List all the node versions installed nvm ls v4.5.0 v6.7.0 Run command using any node installed version nvm run 4.5.0 --version or nvm exec 4.5.0 node --version Running node v4.5.0 (npm v2.15.9) v4.5.0 nvm run 6.7.0 --version or nvm exec 6.7.0 node --version Running node v6.7.0...

You can return a list of all the messages in a mailbox using imap_headers. <?php $headers = imap_headers($mailbox); The result is an array of strings with the following pattern: [FLAG] [MESSAGE-ID])[DD-MM-YYY] [FROM ADDRESS] [SUBJECT TRUNCATED TO 25 CHAR] ([SIZE] chars) Here's a sample o...

Before getting started, make sure you have the latest Azure PowerShell installed. Once installed, start an Azure PowerShell session from your machine. First, you'll need to log in and authenticate to Windows Azure. Add-AzureRmAccount You'll receive a dialog box asking for your Azure credentials...

roslaunch is an important tool that manages the start and stop of ROS nodes. It takes one or more "*.launch" files as arguments. For this example, I will refer to the following (as asked in this question), so how can we execute those commands consecutively & automatically : roscd ste...

Each control has a property DataBindings which is a list of System.Windows.Forms.Binding objects. The Add()-method has some overloads which enables you easily binding to the property of an object: textBox.DataBindings.Add( "Text", dataObj, "MyProperty" ); Note, that binding b...

Passing ByRef or ByVal indicates whether the actual value of an argument is passed to the CalledProcedure by the CallingProcedure, or whether a reference (called a pointer in some other languages) is passed to the CalledProcedure. If an argument is passed ByRef, the memory address of the argument i...

let bodies = (contact.bodyA.categoryBitMask <= contact.bodyB.categoryBitMask) ? (A:contact.bodyA,B:contact.bodyB) : (A:contact.bodyB,B:contact.bodyA) switch (bodies.A.categoryBitMask,bodies.B.categoryBitMask) { case let (a, _) where (a && superPower): //All we care about is i...

View : <form id="form"> <label>First Name: <input data-bind="value: firstName" /></label> <label>Last Name: <input data-bind="value: lastName" /></label> <label>Gender: <select data-bind="s...

Objective-C First add the Social Framework to the XCode project. Import the #import "Social/Social.h" class to the required ViewController Twitter with text, image and link //- - To Share text on twitter - - if([SLComposeViewController isAvailableForServiceType:SLServiceTypeTwitter]) ...