Home » SQL & PL/SQL » SQL & PL/SQL » Need sql to create test data , already searched the old posts (Oracle 10g)
Need sql to create test data , already searched the old posts [message #315268] Sun, 20 April 2008 12:45 Go to next message
ven_vick
Messages: 3
Registered: April 2008
Junior Member
I want to insert 100 records with a value 1 into a table with single column. Appreciate if any one can give me the query. There are some PL/SQL scripts, but how to do it just with SQL alone?

Thanks,
Ven.
Re: Need sql to create test data , already searched the old posts [message #315269 is a reply to message #315268] Sun, 20 April 2008 13:01 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for "row generator".

Regards
Michel
Previous Topic: PLS-00103
Next Topic: Statement with sum(Col1+Col2) in where clause
Goto Forum:
  


Current Time: Fri Dec 09 15:52:03 CST 2016

Total time taken to generate the page: 0.12412 seconds