creating table and copying fields

Question

creating table and copying fields

novice82

Grasshopper

Points: 17
More actions
July 16, 2009 at 4:26 am

#212091

Hello Members,
Its my first day using SQL queries on oracle 10g database.I used the following query to copy selected feilds of a table :
CREATE TABLE SAMPLE_TEMP as (SELECT CUSTOMER, BALANCE FROM CUSTOMER_ALL)
The CUSTOMER_ALL table has over 2 million records. I was successful in creating a table and copying data, but the new table could populate only 52978 records.
---- Sample data in my table
CUSTOMER BALANCE
6.28899273 0
6.28899274 0
6.28899275 0
6.28899289 625.12
6.28899292 2666.24
How do I go about fixing this ? Do i need to declare a structure and assign the number of records i will store to it ? Any guidance will help me get started.
Regards
newbie

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Well, I can't really help because I don't know anything about ORACLE. I can suggest that you find an ORACLE forum to post on, although there are some ORACLE people on SQLServerCentral. You may have better luck on http://www.stackoverflow.com

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

novice82 Grasshopper Points: 17 More actions · Answer 2

Thanks Jack.

I found a solution from the oracle forum.

WayneS SSC Guru Points: 95461 More actions · Answer 3

Out of curiousity, what was your solution?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Jeff Moden SSC Guru Points: 1004648 More actions · Answer 4

novice82 (7/16/2009)
Thanks Jack.
I found a solution from the oracle forum.

Cool! Tell us what the solution is, please.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)