Solved

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

Posted on 2001-06-15
8
770 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 50 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle differnce between two timestamps 5 49
return value based on substr 10 71
how to solve "recursive" database tables 2 45
Oracle Date add 9 29
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ā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to take different types of Oracle backups using RMAN.

739 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