DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 21

Thread: Transfering data from one database table to another database table

Threaded View

  1. 07-15-2003, 12:48 PM #7
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Read the SQL reference guide or just give a copy command on sql prompt.

    Code:
    [email protected]D> copy
usage: COPY FROM  TO    { () } USING 
     : database string, e.g., scott/tiger@d:chicago-mktg
    : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE
  
    : name of the destination table
   : a comma-separated list of destination column aliases
    : any valid SQL SELECT statement
A missing FROM or TO clause uses the current SQL*Plus connection.
[email protected]D>
Im not able to show the exact syntax as the thread is chooping off few parts...
				
			

			


		
			
			
			
    
				
					Last edited by adewri; 07-15-2003 at 12:55 PM.
				
				
			
    
			
			
				
			
			
				
    Amar
    
"There is a difference between knowing the path and walking the path."

    
Amar's Blog  Get Firefox!
    
			
			
		
	
	
    
		
    
			
				
				
				
				
					Reply With Quote  Reply With Quote 
				
				
				
			
			


  

  

  



				
					
				
				

				 
				

					

					
					 

					
					
					
					
					
			
		
    
	
    
	
    


		
		
    
		
    
			
		
    

	












	
	
    
		
			«
			Previous Thread
			|
			Next Thread
			»
		
	
    
	


    
	
	
	
	
	
	
	
    
		
		
    
			
    
				
				Posting Permissions
			
    
			
    
				

    

	
      
		
    • You may not post new threads
      • 
		
    • You may not post replies
      • 
		
    • You may not post attachments
      • 
		
    • You may not edit your posts
      • 
		
    •  
      • 
	
    
	
    
		
	
    
	
    Forum Rules
    


    

			
    
		
    
	
    

    









    
  
   

    




    
	




	
         
	




	
    
	
Click Here to Expand Forum to Full Width