Home » SQL & PL/SQL » SQL & PL/SQL » single select
single select [message #446184] Sat, 06 March 2010 01:03 Go to next message
vdsk
Messages: 41
Registered: February 2006
Location: India & UAE
Member
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
athar.fitfd@hotmail.com
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;


Regards

Athar
Re: single select [message #446186 is a reply to message #446184] Sat, 06 March 2010 01:12 Go to previous message
Michel Cadot
Messages: 68704
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

Regards
Michel
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: Tue Nov 05 14:25:40 CST 2024