rajeshgooner
IS-IT--Management
New to oracle. A very simple question I reckon. I'm migrating some data from mySQL to oracle 9i database. Trying to do this without using any of the migration tools at the moment.
MySQL
Table Name: Content
Field: summary
Value: Here is the guide to make paper throwing stars. They are nice, don\'t fall apart easily (if made well) and can be thrown far (if thrown well). Read on.
The insert statement for mySQL would be:
insert into "content" ("summary") values
('Here is the guide to make paper throwing stars. They are nice, don\'t fall apart easily (if made well) and can be thrown far (if thrown well). Read on.')
If I want to insert this into Oracle:
1. What should the corresponding field datatype be? I'm thinking varchar2(2000).
2. How would I write the insert statement as the text has a single quote in it..
Thanks in advance
MySQL
Table Name: Content
Field: summary
Value: Here is the guide to make paper throwing stars. They are nice, don\'t fall apart easily (if made well) and can be thrown far (if thrown well). Read on.
The insert statement for mySQL would be:
insert into "content" ("summary") values
('Here is the guide to make paper throwing stars. They are nice, don\'t fall apart easily (if made well) and can be thrown far (if thrown well). Read on.')
If I want to insert this into Oracle:
1. What should the corresponding field datatype be? I'm thinking varchar2(2000).
2. How would I write the insert statement as the text has a single quote in it..
Thanks in advance