Horje
create table using the clause with as Code Example
create table using the clause with as 
CREATE TABLE t
AS 
WITH some_data AS ( 
   SELECT 1 as some_value 
   FROM dual

   UNION ALL 

   SELECT 2 
   FROM dual
) 
SELECT * 
FROM some_data
Source: stackoverflow.com



Sql

Related
psql store procedure-return multiple table values Code Example psql store procedure-return multiple table values Code Example
psql create usr Code Example psql create usr Code Example
test connection to sql server Code Example test connection to sql server Code Example
how to create a new db from dumb file mysql Code Example how to create a new db from dumb file mysql Code Example
ora 00001 error catch plsql Code Example ora 00001 error catch plsql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje