Top "Select-into" questions

oracle - multiple insert into type table collection

I have created the following object in oracle 11g. CREATE OR REPLACE TYPE myObject as object( fieldOne number, fieldTwo number ); …

oracle collections types select-into bulk-collect

How do I add a NULL column when SELECT'ing INTO a new table?

I have a statement like this: SELECT field1, field2, MyField = NULL INTO NewTable FROM OldTable This does what I want …

sql select null field select-into

Copying table constraints from select * into

Does select * into B from A also copy constraints of A on B ? If not, then how can I copy …

sql sql-server select constraints select-into

How to use SELECT INTO with static values included?

I'd like to add a value to the values provided by a SELECT INTO statement. Given the table named foo: +…

mysql sql sql-server select-into

Oracle, how to open cursor and select one column of many into a variable

I have a Oracle stored procedure returning a reference cursor. I want to open the cursor before i return it …

oracle stored-procedures cursor fetch select-into

SELECT INTO with subquery

Regarding SELECT INTO in SQL Server The following throw an error Incorrect syntax near ')'. SELECT * INTO Sales.MyTable …

sql-server subquery common-table-expression select-into