Tutorial by Examples

Sometimes, it's better to have only three options style="@android:style/TextAppearance.Small" style="@android:style/TextAppearance.Medium" style="@android:style/TextAppearance.Large" Use small and large to differentiate from normal screen size. <TextView ...

To handle a command, you must have a class that implements the CommandExecutor interface. The JavaPlugin class (your plugin's main class) already implements this. When implementing the CommandExecutor interface, the following method must be implemented: public boolean onCommand(CommandSender sende...

url: /api/data/v8.0/quotedetails json: { "[email protected]": "/products(11c0dbad-91df-e311-b8e5-6c3be5a8b200)", "[email protected]" : "/quotes(69b5e1ae-037f-e611-80ed-fc15b428dcdc)", "[email protected]" : "/uoms(73a5daea-6dd...

When you join two tables, SQL Server query optimizer (QO) can choose different types of joins that will be used in query: HASH join LOOP join MERGE join QO will explore plans and choose the optimal operator for joining tables. However, if you are sure that you know what would be the optimal ...

When you use GROUP BY clause, SQL Server query optimizer (QO) can choose different types of grouping operators: HASH Aggregate that creates hash-map for grouping entries Stream Aggregate that works well with pre-ordered inputs You can explicitly require that QO picks one or another aggregate ...

Specifies that the query is optimized for fast retrieval of the first number_rows. This is a nonnegative integer. After the first number_rows are returned, the query continues execution and produces its full result set. select OrderID, AVG(Quantity) from Sales.OrderLines group by OrderID OPTION ...

When you use UNION operator on two query results, Query optimizer (QO) can use following operators to create a union of two result sets: Merge (Union) Concat (Union) Hash Match (Union) You can explicitly specify what operator should be used using OPTION() hint: select OrderID, OrderDate, Ex...

Specifies the max degree of parallelism for the query specifying this option. SELECT OrderID, AVG(Quantity) FROM Sales.OrderLines GROUP BY OrderID OPTION (MAXDOP 2); This option overrides the MAXDOP configuration option of sp_configure and Resource Governor. If MAXDOP is set to zero then...

By using the method GET_SUBMATCH of class CL_ABAP_MATCHER, we can get the data in the groups/subgroups. Goal: get the token to the right of the keyword 'Type'. DATA: lv_pattern TYPE string VALUE 'type\s+(\w+)', lv_test TYPE string VALUE 'data lwa type mara'. CREATE OBJECT ref_regex EX...

JSON_MODIFY function uses JSON text as input parameter, and modifies a value on the specified path using third argument: declare @json nvarchar(4000) = N'{"Id":1,"Name":"Toy Car","Price":34.99}' set @json = JSON_MODIFY(@json, '$.Price', 39.99) print @json -...

JSON_MODIFY has 'append' mode that appends value into array. declare @json nvarchar(4000) = N'{"Id":1,"Name":"Toy Car","Tags":["toy","game"]}' set @json = JSON_MODIFY(@json, 'append $.Tags', 'sales') print @json -- Output: {"Id&quot...

JSON_MODIFY function enables you to insert JSON objects into JSON text: declare @json nvarchar(4000) = N'{"Id":1,"Name":"Toy Car"}' set @json = JSON_MODIFY(@json, '$.Price', JSON_QUERY('{"Min":34.99,"Recommended":45.49}'))...

You can generate JSON object using standard SELECT query with FOR JSON clause and insert it into JSON text as third parameter: declare @json nvarchar(4000) = N'{"Id":17,"Name":"WWI"}' set @json = JSON_MODIFY(@json, '$.tables', (select name fr...

You can generate JSON object using standard SELECT query with FOR JSON clause and WITHOUT_ARRAY_WRAPPER option, and insert it into JSON text as a third parameter: declare @json nvarchar(4000) = N'{"Id":17,"Name":"WWI"}' set @json = JSON_MODIFY(@json, '$.table', ...

Register at apex.world today! apex.world is the center of everything APEX - jobs, tutorials, Twitter feeds, newsletters, plug-ins, and more!

Oracle Learning Library gives you idea about how to use oracle apex in Real world.

SELECT is an Open-SQL-statement for reading data from one or several database tables into data objects. Selecting All Records * This returns all records into internal table lt_mara. SELECT * FROM mara INTO lt_mara. Selecting Single Record * This returns single record if tabl...

[[UITabBar appearance] setTintColor:[UIColor whiteColor]]; [[UITabBar appearance] setBarTintColor:[UIColor tabBarBackgroundColor]]; [[UITabBar appearance] setBackgroundColor:[UIColor tabBarInactiveColor]]; [[UINavigationBar appearance] setBarTintColor:[UIColor appBlueColor]]; [[UINavigationBar a...

1. Bagged Decision Trees Bagging performs best with algorithms that have high variance. A popular example are decision trees, often constructed without pruning. In the example below see an example of using the BaggingClassifier with the Classification and Regression Trees algorithm (DecisionTreeCl...

samtools idxstats thing.bam