We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,924 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

How to populate table with junk values

I have about 16 tables in a database schema that are empty and wish to populate them with junk row values of the same type which I have defined,is there a way to do it?

4
Contributors
5
Replies
4 Days
Discussion Span
9 Months Ago
Last Updated
6
Views
sarathsshanker
Newbie Poster
23 posts since Aug 2011
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

Personally, I shop at the flea market, and then decide what values are on the table LMFAO! Couldn't resist! But yea, "Love short people!"

lil_bit
Newbie Poster
22 posts since Jul 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

I know there are generators, but am not too familiar with Oracle. Perhaps post a question in the Oracle forums. People there should know.

pritaeas
Posting Prodigy
Moderator
9,282 posts since Jul 2006
Reputation Points: 1,173
Solved Threads: 1,457
Skill Endorsements: 86

Thanks for the down-rates anon-person! How you conduct your personal life is one thing, but come-on, you prolly hide behind a screen too! (You disappoint me.) (No wonder nerds get shot down -no sense of humor. Am I the only nerd with one -egad!)

"Love short people!"

lil_bit
Newbie Poster
22 posts since Jul 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

One was mine, thought the reason was obvious. Please keep the replies on topic/relevant.

pritaeas
Posting Prodigy
Moderator
9,282 posts since Jul 2006
Reputation Points: 1,173
Solved Threads: 1,457
Skill Endorsements: 86

If you have some sample data in an excell sheet or in .CSV format, you can upload those into tha table using SQL*LOADER.

debasisdas
Posting Genius
6,968 posts since Feb 2007
Reputation Points: 722
Solved Threads: 457
Skill Endorsements: 20

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.3278 seconds using 2.7MB