•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 391,563 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 2,728 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:
Views: 1095 | 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 6:14 am.
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,213
Reputation:
Rep Power: 4
Solved Threads: 78
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,213
Reputation:
Rep Power: 4
Solved Threads: 78
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
Similar Threads
- 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)
- Sql Query (VB.NET)
- Query Building (Database Design)
Other Threads in the Oracle Forum
- Previous Thread: oracle connection from VB.NET 2003
- Next Thread: error help
