•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 456,589 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,586 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 1238 | Replies: 5
 |
| |
•
•
Join Date: Nov 2007
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
help me for this query Hi,
I want to store the text data with apostrophe in the table.
I tried through this query like this
insert into temp values(101,'vijaya\'s');
but it is giving error - missing comma
Could anybody help this sql query for the following requirement?
NAME
vijaya's
rajani's
I want to store the text data with apostrophe in the table.
I tried through this query like this
insert into temp values(101,'vijaya\'s');
but it is giving error - missing comma
Could anybody help this sql query for the following requirement?
NAME
vijaya's
rajani's
Last edited by svijayakumaris : Nov 1st, 2007 at 7:14 am.
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,445
Reputation:
Rep Power: 4
Solved Threads: 87
try this sample query
hope that solves your problem.
oracle Syntax (Toggle Plain Text)
Share your Knowledge.
•
•
Join Date: Nov 2007
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thank you. It's working.
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,445
Reputation:
Rep Power: 4
Solved Threads: 87
You are most welcome.
I am glad to know i could help you.
I am glad to know i could help you.
Share your Knowledge.
•
•
Join Date: Nov 2007
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by debasisdas 
You are most welcome.
I am glad to know i could help you.
Thankyou! its working.
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode
Similar Threads
- Sql Query (VB.NET)
- Removing Query Strings (ASP.NET)
- Double MySQL Query (PHP)
- Dynamic Query (JSP)
- MySQL nested query / joined query conversion help (MySQL)
- problem with lengthy query (Java)
- Retreiving variables from a sql query into a form (PHP)
- Query Building (Database Design)
Other Threads in the Oracle Forum
- Previous Thread: oracle connection from VB.NET 2003
- Next Thread: error help
