?
Solved

is this the correct format for FORMS_DDL statement??????

Posted on 2001-06-15
8
Medium Priority
?
777 Views
Last Modified: 2012-06-22
What is wrong with the way i am using the quotes????




forms_ddl ('insert into jkest values (1,"mr smith")');
0
Comment
Question by:joekeri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 3

Expert Comment

by:mathavra
ID: 6196504
Try the same with TWO SINGLE QUOTES instead of one double quote around as below.

forms_ddl ('insert into jkest values (1,''mr smith'')');
0
 

Author Comment

by:joekeri
ID: 6196550
i tried it with 2 single quotes around the string MR SMITH at both ends, and it still isnt working.

forms_ddl ('insert into jkest values (1,''mr smith'')');
0
 
LVL 3

Accepted Solution

by:
mathavra earned 200 total points
ID: 6196565
The only other ways I can think of as below. Try this.

1)

forms_ddl ('insert into jkest values (1,'||chr(39)||mr smith||chr(39)||')');

2)
Or, you may want to assign your insert statements with TWO SINGLE QUOTES into a variable and use it with forms_ddl.

NOTE: WITH TWO SINGLE QUOTES IT WORKED FOR ME.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:joekeri
ID: 6196615
thank you for your help..

I retried both methods and both of them do work the way I wanted them to,.
0
 
LVL 3

Expert Comment

by:mathavra
ID: 6196679
You are welcome.
0
 
LVL 2

Expert Comment

by:renuraj
ID: 6197819
As the character ' is having special meaning to oracle , means of specifying character strings to oracle.

It is required to suppress the default meaning of the character.

As like for every programming language we have editing characters and non-editing characters concept.

To add the character strings  if we use '''' characters, which means to oracle to add (or concatenate when used so) ' character.

The first and last ' character does the default functionality for oracle as in case of 'SMITH'.
Second one specifies the ' to be considered as a character like any other normal character.
Third ' specifies to oracle to suppress the default functionality of second ' character.


As mathavra's solution also works , but it include one more function CHR() to be used.

Regards,
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7036067
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7046009
Force accepted

** Mindphaser - Community Support Moderator **
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question