sql Archives - Page 43 of 45

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it? 2 24 SELECT owner, table_name FROM dba_tables ...

April 14, 2022
0 Comments

How do I escape a single quote in SQL Server?

I am trying to insert some text data into a table in SQL Server 9. The text includes a single quote '. How ...

April 14, 2022
0 Comments

How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: ...

April 14, 2022
0 Comments

Difference between JOIN and INNER JOIN

Both these joins will give me the same results: SELECT * FROM table JOIN otherTable ON table.ID = otherTable.FK vs SELECT * FROM ...

April 13, 2022
0 Comments

SQL Server – Best way to get identity of inserted row?

What is the best way to get IDENTITY of inserted row? I know about @@IDENTITY and IDENT_CURRENT and SCOPE_IDENTITY but don’t understand the ...

April 13, 2022
0 Comments

How can I list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file – once I ...

April 13, 2022
0 Comments

How can I do an UPDATE statement with JOIN in SQL Server?

I need to update this table in SQL Server with data from its ‘parent’ table, see below: Table: sale id (int) udid (int) ...

April 12, 2022
0 Comments

What are the options for storing hierarchical data in a relational database?

Good Overviews Generally speaking, you’re making a decision between fast read times (for example, nested set) or fast write times (adjacency list). Usually, ...

April 12, 2022
0 Comments

Find all tables containing column with specified name – MS SQL Server

Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. without ...

April 12, 2022
0 Comments