Tutorial by Examples: f

select owner, table_name from all_tables ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user. COLS is a synonym for USER_TAB_COLUMNS. select * from all_tab_columns where table_name = :tname

All roles granted to user. select * from dba_role_privs where grantee= :username Privileges granted to user: system privileges select * from dba_sys_privs where grantee = :username object grants select * from dba_tab_privs where grantee = :username Permissions grante...

The following query will return informationa about qeries, their plans and average statistics regarding their duration, CPU time, physical and logical io reads. SELECT Txt.query_text_id, Txt.query_sql_text, Pl.plan_id, avg_duration, avg_cpu_time, avg_physical_io_reads, avg_logica...

If you want to remove some query or query plan from query store, you can use the following commands: EXEC sp_query_store_remove_query 4; EXEC sp_query_store_remove_plan 3; Parameters for these stored procedures are query/plan id retrieved from system views. You can also just remove execution ...

SQL Query optimizer will choose the baes possible plan that he can find for some query. If you can find some plan that works optimally for some query, you can force QO to always use that plan using the following stored procedure: EXEC sp_query_store_unforce_plan @query_id, @plan_id From this poi...

While declaring a function in the $rootscope has it's advantages, we can also declare a $scope function any part of the code that is injected by the $scope service. Controller, for instance. Controller myApp.controller('myController', ['$scope', function($scope){ $scope.myFunction = function ...

files = list.files(pattern="*.csv") data_list = lapply(files, read.table, header = TRUE) This read every file and adds it to a list. Afterwards, if all data.frame have the same structure they can be combined into one big data.frame: df <- do.call(rbind, data_list)

The $http requests require time which varies depending on the server, some may take a few milliseconds, and some may take up to a few seconds. Often the time required to retrieve the data from a request is critical. Assuming the response value is an array of names, consider the following example: ...

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...

public class AmazonRootobject { public Itemsearchresponse ItemSearchResponse { get; set; } } public class Itemsearchresponse { public string xmlns { get; set; } public Operationrequest OperationRequest { get; set; } public Items Items { g...

Once you've connected to your mailbox, you'll want to take a look inside. The first useful command is imap_list. The first parameter is the resource you acquired from imap_open, the second is your mailbox string and the third is a fuzzy search string (* is used to match any pattern). $folders = ima...

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...

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...

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...

Default modifier If no modifier is specified for a parameter, that parameter is implicitly passed by reference. Public Sub DoSomething1(foo As Long) End Sub Public Sub DoSomething2(ByRef foo As Long) End Sub The foo parameter is passed ByRef in both DoSomething1 and DoSomething2. Wa...

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]) ...

Getting a table with vertical headers. Twitter bootstrap now support vertical header on a well formatted normal table. To achieve this just use .table-reflow class Use twitter bootstrap .table-reflow class on a well formed table to achieve a table with vertical headers. Additionally you can combin...

This document details the steps to obtain the facebook access tokens and the using the tokens to fetch FB feeds. Example: A live example is available in https://newtonjoshua.com Introduction to Graph API: The Graph API is the primary way to get data in and out of Facebook's platform. It's a...

With the 2.x versions of typescript, typings are now available from the npm @types repository. These are automatically resolved by the typescript compiler and are much simpler to use. To install a type definition you simply install it as a dev dependency in your projects package.json e.g. npm i -...

[Service] # empty exec prevents error "docker.service has more than one ExecStart= setting, which is only allowed for Type=oneshot services. Refusing." ExecStart= ExecStart=/usr/bin/dockerd -H fd:// --log-driver=syslog This enables syslog logging for the docker daemon. The file sho...