    select sequence_owner, sequence_name from dba_sequences;


    DBA_SEQUENCES -- all sequences that exist 
    ALL_SEQUENCES  -- all sequences that you have permission to see 
    USER_SEQUENCES  -- all sequences that you own

Note that since you are, by definition, the owner of all the sequences returned from `USER_SEQUENCES`, there is no `SEQUENCE_OWNER` column in `USER_SEQUENCES`.





You may not have permission to dba_sequences.  So you can always just do:

    select * from user_sequences;

I&#39;m trying to use Bower for a web app, but find myself hitting some sort of proxy issues:

    D:\&gt;bower search jquery
    bower retry         Request to https://bower.herokuapp.com/packages/search/jquery failed with ECONNRESET, retrying in 1.2s
    bower retry         Request to https://bower.herokuapp.com/packages/search/jquery failed with ECONNRESET, retrying in 2.5s
    bower retry         Request to https://bower.herokuapp.com/packages/search/jquery failed with ECONNRESET, retrying in 6.8s
    bower retry         Request to https://bower.herokuapp.com/packages/search/jquery failed with ECONNRESET, retrying in 15.1s
    bower retry         Request to https://bower.herokuapp.com/packages/search/jquery failed with ECONNRESET, retrying in 20.3s
    bower ECONNRESET    Request to https://bower.herokuapp.com/packages/search/jquery failed: tunneling socket could not be established, cause=Parse Error

Relevant points:
 
 - I can browse to https://bower.herokuapp.com/packages/search/jquery and it returns a full json response.
 - I can use git to clone, both using the git:// protocol and http(s).
 - I can use NPM directly without these issues
 - I&#39;ve tried using Fiddler to determine what&#39;s being blocked, but it doesn&#39;t detect any calls from the Bower command.  I can see calls from NPM commands in Fiddler.
 - I&#39;ve searched the Bower issues list, seen similar issues, but they either have no solution or it doesn&#39;t seem quite the same as mine.

Any ideas?

Bower calls blocked by corporate proxy

I need to use an *associative array* as data source for my `select` options using AngularJS.

Is it possible to use an array like this?

	{
		&quot;key1&quot;: &quot;val1&quot;,
		&quot;key2&quot;: &quot;val2&quot;,
		&quot;key3&quot;: &quot;val3&quot;,
		...
	}

and get something like this:

	&lt;select&gt;
		&lt;option value=&quot;key1&quot;&gt;val1&lt;/option&gt;
		&lt;option value=&quot;key2&quot;&gt;val2&lt;/option&gt;
		&lt;option value=&quot;key3&quot;&gt;val3&lt;/option&gt;
		...
	&lt;/select&gt;

I read [docs][1], but I can&#39;t understand how to achieve this.


  [1]: http://docs.angularjs.org/api/ng.directive:select

key-value pairs in ng-options

Is there any command that I can run so that I can get all the sequences? 
I am using Oracle 11g. I am using Toad for Oracle to connect to it. I can visually see the sequences in Toad, but I like to know the command line for it.

How can I get all sequences in an Oracle database?

<p>Is there any command that I can run so that I can get all the sequences?
I am using Oracle 11g. I am using Toad for Oracle to connect to it. I can visually see the sequences in Toad, but I like to know the command line for it.</p>


How can I **list all the tables** of a PostgreSQL database and **order them by size**?

postgresql list and order tables by size

What is the difference between an `INNER JOIN` and `LEFT SEMI JOIN`? 

In the scenario below, why am I getting two different results? 

The `INNER JOIN` result set is a lot larger. Can someone explain? I am trying to get the names within `table_1` that only appear in `table_2`.

    SELECT name
    FROM table_1 a
        INNER JOIN table_2 b ON a.name=b.name

    SELECT name
    FROM table_1 a
        LEFT SEMI JOIN table_2 b ON (a.name=b.name)

Difference between INNER JOIN and LEFT SEMI JOIN

I have some data that I would like to split based on a delimiter that may or may not exist.  

Example data:

    John/Smith
    Jane/Doe
    Steve
    Bob/Johnson

I am using the following code to split this data into First and Last names:

    SELECT SUBSTRING(myColumn, 1, CHARINDEX(&#39;/&#39;, myColumn)-1) AS FirstName,
           SUBSTRING(myColumn, CHARINDEX(&#39;/&#39;, myColumn) + 1, 1000) AS LastName
    FROM   MyTable

The results I would like:

    FirstName---LastName
    John--------Smith
    Jane--------Doe
    Steve-------NULL
    Bob---------Johnson

This code works just fine as long as all the rows have the anticipated delimiter, but errors out when a row does not:

    &quot;Invalid length parameter passed to the LEFT or SUBSTRING function.&quot;

How can I re-write this to work properly?

T-SQL split string based on delimiter

 

I am new to using DataFrame and I would like to know how to perform a SQL equivalent of left outer join on multiple columns on a series of tables

Example:

    df1: 
    Year    Week    Colour    Val1 
    2014       A       Red      50
    2014       B       Red      60
    2014       B     Black      70
    2014       C       Red      10
    2014       D     Green      20

    df2:
    Year    Week    Colour    Val2
    2014       A     Black      30
    2014       B     Black     100
    2014       C     Green      50
    2014       C       Red      20
    2014       D       Red      40

    df3:
    Year    Week    Colour    Val3
    2013       B       Red      60
    2013       C     Black      80
    2013       B     Black      10
    2013       D     Green      20
    2013       D       Red      50

Essentially I want to do something like this SQL code (Notice that df3 is not joined on Year):

    SELECT df1.*, df2.Val2, df3.Val3
    FROM df1
      LEFT OUTER JOIN df2
        ON df1.Year = df2.Year
        AND df1.Week = df2.Week
        AND df1.Colour = df2.Colour
      LEFT OUTER JOIN df3
        ON df1.Week = df3.Week
        AND df1.Colour = df3.Colour

The result should look like:

    Year    Week    Colour    Val1    Val2    Val3
    2014       A       Red      50    Null    Null
    2014       B       Red      60    Null      60
    2014       B     Black      70     100    Null
    2014       C       Red      10      20    Null
    2014       D     Green      20    Null    Null


I have tried using merge and join but can&#39;t figure out how to do it on multiple tables and when there are multiple joints involved. Could someone help me on this please?

Thanks

Pandas left outer join multiple dataframes on multiple columns

I have imported 100 of tables in Postgres from MSSql server 2008 through tool which created all the tables along with their columns in **capital letter**. Now if I want to make a data view from table e.g - STD_TYPE_CODES as-

    select * from STD_TYPE_CODES
I am getting following error-

    ERROR:  relation &quot;std_type_codes&quot; does not exist
    LINE 1: select * from STD_TYPE_CODES
                      ^
    ********** Error **********
    ERROR: relation &quot;std_type_codes&quot; does not exist
    SQL state: 42P01
    Character: 15
I know I can put the quotes around the table name as-

    select * from &quot;STD_TYPE_CODES&quot;
But as I have worked with MSSql Server, there is no such kind of issue.
So is there any way to get rid of this? Please help.


Postgres Case Sensitivity

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have a primary key and identity defined. 

But since I have to delete some records from the table, the identity seed for those tables will be disturbed and the index column (which is auto-generated with an increment of 1) will get disturbed.

**How can I reset the identity column after I deleted the records so that the column has sequence in ascending numerical order?**

The identity column is not used as a foreign key anywhere in database.

Reset identity seed after deleting records in SQL Server

Why does  add a foreign key to the `tblDomare` table result in this error?


&gt; The ALTER TABLE statement conflicted with the FOREIGN KEY constraint &quot;FK__tblDomare__PersN__5F7E2DAC&quot;. The conflict occurred in database &quot;almu0004&quot;, table &quot;dbo.tblBana&quot;, column &#39;BanNR&#39;.

**Code**


    CREATE TABLE tblDomare
    (PersNR VARCHAR (15) NOT NULL,
    fNamn VARCHAR (15) NOT NULL,
    eNamn VARCHAR (20) NOT NULL,
    Erfarenhet VARCHAR (5),
    PRIMARY KEY (PersNR));

    INSERT INTO tblDomare (PersNR,fNamn,eNamn,Erfarenhet)
    Values (6811034679,&#39;Bengt&#39;,&#39;Carlberg&#39;,10);

    INSERT INTO tblDomare (PersNR,fNamn,eNamn,Erfarenhet)
    Values (7606091347,&#39;Josefin&#39;,&#39;Backman&#39;,4);

    INSERT INTO tblDomare (PersNR,fNamn,eNamn,Erfarenhet)
    Values (8508284163,&#39;Johanna&#39;,&#39;Backman&#39;,1);

    CREATE TABLE tblBana
    (BanNR VARCHAR (15) NOT NULL,
    PRIMARY KEY (BanNR));

    INSERT INTO tblBana (BanNR)
    Values (1);

    INSERT INTO tblBana (BanNR)
    Values (2);

    INSERT INTO tblBana (BanNR)
    Values (3);

    ALTER TABLE tblDomare
    ADD FOREIGN KEY (PersNR)
    REFERENCES tblBana(BanNR);



The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

Actually what do they mean? All articles I find about them don&#39;t give me an idea, or my knowledge is too insufficient to understand it.

Will some one give me some resources with which I can learn this from scratch.

What are OLTP and OLAP. What is the difference between them?

I have inserted some values in the table `DataTab`. &lt;br&gt;

    SomeId: Integer     =&gt; Autogenerated primary key.
    DataId: Guid
    DataNumber: Integer
    DataType: varchar

The above are the column&#39;s in my tables, I want to find, if the table contains Repeated `DataId` values.
It has been long time I had worked with databases. Now I can figure out simple queries. But I found this some what difficult.

I tried the following query, is this correct?

    SELECT * from (Select * from DataTab) AS X 
    where DataId= X.DataId AND SomeId!=X.SomeId

Find duplicate column value in sqlite

There is a post about a Redis command to get all available keys, but I would like to do it with Python.

Any way to do this?

Get all keys in Redis database with python

I was googling about how to create a user and grant all privileges to him.

I found these two methods :

The first method :

    create user userName identified by password;
    grant connect to userName;
    grant all privileges to userName;

The second method :

    grant connect , resource to userName identified by password;

So what&#39;s the difference between those two methods ?

Create a user with all privileges in Oracle

I have an Oracle database on my network which I am able to connect to with Oracle SQL Developer, using hostname, port, username, password and the SID.

I need to connect another application (Quantum Gis), however it uses the Service Name instead of the SID.

Is there any way for me to determine the SERVICE_NAME of the database when I am connected in SQL Developer via the SID?

I do not have access to the server and have no local tnsnames.ora or similar.

How to find Oracle Service Name

I am trying to insert data into an existing table and keep receiving an error.

    INSERT INTO Patient  
    (
      PatientNo,
      PatientFirstName,
      PatientLastName,
      PatientStreetAddress,
      PatientTown,
      PatientCounty,
      PatientPostcode,
      DOB,
      Gender,
      PatientHomeTelephoneNumber,
      PatientMobileTelephoneNumber
    )
    VALUES 
    (
      121, 
      &#39;Miles&#39;, 
      &#39;Malone&#39;, 
      &#39;64 Zoo Lane&#39;, 
      &#39;Clapham&#39;, 
      &#39;United Kingdom&#39;,
      &#39;SW4 9LP&#39;,
      &#39;1989-12-09&#39;,
      &#39;M&#39;,
      02086950291,
      07498635200
    );


Error:
   
    Error starting at line : 1 in command -
    INSERT INTO Patient (PatientNo,PatientFirstName,PatientLastName,PatientStreetAddress,PatientTown,PatientCounty,PatientPostcode,DOB,Gender,PatientHomeTelephoneNumber,PatientMobileTelephoneNumber)
    VALUES (121, &#39;Miles&#39;, &#39;Malone&#39;, &#39;64 Zoo Lane&#39;, &#39;Clapham&#39;, &#39;United Kingdom&#39;,&#39;SW4 9LP&#39;,&#39;1989-12-09&#39;,&#39;M&#39;,02086950291,07498635200)
    Error report -
    SQL Error: ORA-01861: literal does not match format string
    01861. 00000 -  &quot;literal does not match format string&quot;
    *Cause:    Literals in the input must be the same length as literals in
               the format string (with the exception of leading whitespace).  If the
               &quot;FX&quot; modifier has been toggled on, the literal must match exactly,
               with no extra whitespace.
    *Action:   Correct the format string to match the literal.


Just not sure why this keeps happening I am learning SQL at the moment, any help will be greatly appreciated!

SQL Error: ORA-01861: literal does not match format string 01861

What does `||` do in SQL?

    SELECT &#39;a&#39; || &#39;,&#39; || &#39;b&#39; AS letter

What does SQL Select symbol || mean?

I am trying to connect my grails project to Oracle databse(**Oracle 12c**) in windows(8) system. However, whenever I run my application I get following exception :

    Caused by: org.apache.commons.dbcp.SQLNestedException: 
    Cannot create PoolableConnectionFactory (ORA-28040: 
    No matching authentication protocol)

    Caused by: 
    java.sql.SQLException: ORA-28040: 
    No matching authentication protocol


According to internet suggestion I also tried editing my  **`*.ora`** file but it is not working.

I added following snippet in **`sqlnet.ora`** file :

    SQLNET.ALLOWED_LOGON_VERSION=10
    SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10
    SQLNET.ALLOWED_LOGON_VERSION_SERVER=10

Here i tried assigning (10,11,12) but neither of them is working.

Can anyone please help me with this ?

ORA-28040: No matching authentication protocol exception

As documented in both [Array][1] and [Dictionary][2] `forEach(_:)` Instance methods:

&gt; Calls the given closure on each element in the **sequence** in the same
&gt; order as a for-in loop.

Nevertheless, adapted from [Sequence Overview][3]:

&gt; A sequence is a list of values that you can step through one at a
&gt; time. *The most common way* to iterate over the elements of a sequence
&gt; is to use a **for-in loop**.

Implying that iterating sequence by `forEach(_:)` or `for in`:

    let closedRange = 1...3
    
    for element in closedRange { print(element) } // 1 2 3
    
    closedRange.forEach { print($0) } // 1 2 3

Or (Array):

    let array = [1, 2, 3]
    
    for element in array { print(element) } // 1 2 3
    
    array.forEach { print($0) } // 1 2 3

Would gives the same output.

Why `forEach(_:)` even exist? i.e what is the benefit of using it instead of the `for in` loop? would they be the same from performance point view?

As an assumption, it could be a syntactic sugar especially when working with *functional programming*.

  [1]: https://developer.apple.com/documentation/swift/array/1689783-foreach
  [2]: https://developer.apple.com/documentation/swift/dictionary/1689593-foreach
  [3]: https://developer.apple.com/documentation/swift/sequence

When to use forEach(_:) instead of for in?

So I just came across what seems to me like a strange Python feature and wanted some clarification about it.  

The following array manipulation somewhat makes sense:

    p = [1,2,3]
    p[3:] = [4] 
    p = [1,2,3,4]

I imagine it is actually just appending this value to the end, correct?  
Why can I do this, however?  

    p[20:22] = [5,6]
    p = [1,2,3,4,5,6]
   
And even more so this:  

    p[20:100] = [7,8]
    p = [1,2,3,4,5,6,7,8]

This just seems like wrong logic. It seems like this should throw an error! 
 
 Any explanation?  
-Is it just a weird thing Python does?  
-Is there a purpose to it?  
-Or am I thinking about this the wrong way?


Why does Python allow out-of-range slice indexes for sequences?

Whenever I read a `csv` file in R (`read.csv(&quot;file_name.csv&quot;)`) that was exported using toad, the first column name is preceded by the following characters &quot;&lt;b&gt;&#239;..&lt;/b&gt;&quot;. Also, opening the csv file in excel or notepad++ shows up correctly (without the preceding characters). This is a hassle as my workaround has been to rename the column after each read. 
Thanks for any fix to this issue! 

Edit:&lt;br&gt;
The export was created in Toad by right-clicking on the result set of a query and selecting &lt;br&gt; &#39;Quick Export -&gt; File -&gt; CSV File&#39;

More details per comment:&lt;br&gt;
```
head(readLines(&#39;test_file.csv&#39;),n=3)`&lt;br&gt;
[1] &quot;&#239;&#187;&#191;ID,LOCATION&quot; &quot;12021,1204&quot; &quot;12281,1204&quot;
```



Content Type	Original Author	Original Content on Stackoverflow
Question	sheidaei	View Question on Stackoverflow
Solution 1 - Sql	Mark J. Bobak	View Answer on Stackoverflow
Solution 2 - Sql	Pete B.	View Answer on Stackoverflow

How can I get all sequences in an Oracle database?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

key-value pairs in ng-options

Bower calls blocked by corporate proxy

Attributions