import matplotlib.pyplot as plt
import numpy as np
# generate 1000 data points with normal distribution
data = np.random.randn(1000)
plt.hist(data)
plt.show()
You can read content of file using OPENROWSET(BULK) function and store content in some table:
INSERT INTO myTable(content)
SELECT BulkColumn
FROM OPENROWSET(BULK N'C:\Text1.txt', SINGLE_BLOB) AS Document;
SINGLE_BLOB option will read entire content from a file as single cell.
...
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...
You can use OPENROWSET to read content of file and pass it to some other function that will parse results.
The following example shows hot to read entire content of JSON file using OPENROWSET(BULK) and then provide BulkColumn to OPENJSON function that will parse JSON and return columns:
SELECT boo...
A basic implementation for singly-linked-list in java - that can add integer values to the end of the list, remove the first value encountered value from list, return an array of values at a given instant and determine whether a given value is present in the list.
Node.java
package com.example.so....
You may want to read a DataFrame from a CSV (Comma separated values) file or maybe even from a TSV or WSV (tabs and whitespace separated files). If your file has the right extension, you can use the readtable function to read in the dataframe:
readtable("dataset.CSV")
But what if your ...
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 ...
This example show how one may create a simple "Hello World" in Gtk3, setting up a window and button widgets. The sample code will also demonstrate how to set different attributes and actions on the widgets.
module Main (Main.main) where
import Graphics.UI.Gtk
main :: IO ()
main = d...
For Navigate to any url :
driver.navigate().to("http://www.example.com");
For move backwards :
driver.navigate().back();
For move forwards :
driver.navigate().forward();
For refresh the page :
driver.navigate().refresh();
Method overriding is the way of using polymorphism between classes. if one class is inherited from another, the former (sub class) can override the latter's (super class's) methods, and change the implementation.
this is used where the super class defines the more general implementation of the meth...
To separate API logic from the component, we are creating the API client as a separate class. This example class makes a request to Wikipedia API to get random wiki articles.
import { Http, Response } from '@angular/http';
import { Injectable } from '@angular/core';
import { Observabl...
Since defining all of the authorization logic in the AuthServiceProvider could become cumbersome in large applications, Laravel allows you to split your authorization logic into "Policy" classes. Policies are plain PHP classes that group authorization logic based on the resource they autho...
a = [1, 2, 3, 4, 5]
# steps through the list backwards (step=-1)
b = a[::-1]
# built-in list method to reverse 'a'
a.reverse()
if a = b:
print(True)
print(b)
# Output:
# True
# [5, 4, 3, 2, 1]
def shift_list(array, s):
"""Shifts the elements of a list to the left or right.
Args:
array - the list to shift
s - the amount to shift the list ('+': right-shift, '-': left-shift)
Returns:
shifted_array - the shifted list
"&quo...
One drawback of creating private method in Javascript is memory-inefficient because a copy of the private method will be created every time a new instance is created. See this simple example.
function contact(first, last) {
this.firstName = first;
this.lastName = last;
this.mobile;
...
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...
