Home » SQL & PL/SQL » SQL & PL/SQL » single select
single select [message #446184] Sat, 06 March 2010 01:03 Go to next message
Messages: 41
Registered: February 2006
Location: India & UAE
I want to insert numbers 1 to 10 in a table using a single
SELECT command..How to accomplish this ?
Re: single select [message #446185 is a reply to message #446184] Sat, 06 March 2010 01:06 Go to previous messageGo to next message
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
i think this will help

insert into tab1
select level from dual connect by level<=10;


Re: single select [message #446186 is a reply to message #446184] Sat, 06 March 2010 01:12 Go to previous message
Michel Cadot
Messages: 65135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The say you do it depends on your version number, this why we ask to ALWAYS post your version number, and with 4 decimals.
Please read OraFAQ Forum Guide

See row generator

Previous Topic: How to safely commit inside a cursor loop (merged by CM and JR)
Next Topic: Not able to apply session tranforms
Goto Forum:

Current Time: Wed Aug 16 16:55:53 CDT 2017

Total time taken to generate the page: 0.21326 seconds