|
|
|
|
Re: how to use the & symbol in text [message #327410 is a reply to message #327408] |
Mon, 16 June 2008 05:47   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
The answer is still to do an "set define off" before doing whatever you are doing.
Try that, and if it doesn't work post exactly what you are trying to do as a formatted SQL*Plus session, like Littlefoot did.
|
|
|
Re: how to use the & symbol in text [message #327411 is a reply to message #327402] |
Mon, 16 June 2008 05:50   |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
Something like this? SQL> set define on
SQL> select object_id from user_objects
2 where object_name = 'F&F Closed - Payable';
Enter value for f:
old 2: where object_name = 'F&F Closed - Payable'
new 2: where object_name = 'F Closed - Payable'
no rows selected
SQL> set define off
SQL> create or replace view v1 as
2 select object_id from user_objects
3 where object_name = 'F&F Closed - Payable';
View created.
SQL> set define on
SQL> select * from v1;
no rows selected
SQL>
|
|
|
Re: how to use the & symbol in text [message #327412 is a reply to message #327402] |
Mon, 16 June 2008 05:53   |
spmano1983
Messages: 269 Registered: September 2007
|
Senior Member |
|
|
i want to create view by using this query
select max(PAC.creation_date)
from per_analysis_criteria PAC
,per_person_analyses PPA
,fnd_id_flex_structures FIFS
where
PPA.person_id=700589
and FIFS.id_flex_structure_code='XX_EXIT_INDIA_CASE_STATUS'
and FIFS.id_flex_num=PPA.id_flex_num
and PPA.id_flex_num=PAC.id_flex_num
and PPA.analysis_criteria_id=PAC.analysis_criteria_id
and PAC.segment1 like 'F&F Closed - Payable'
How to achieve this?
not getting solution by \& also
|
|
|
|
Re: how to use the & symbol in text [message #327416 is a reply to message #327402] |
Mon, 16 June 2008 06:03   |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
> i want to create view by using this query
Maybe it would be nice to mention the tool you are using (SQL*Plus, TOAD, SQL Developer, ... ).
> not getting solution by \& also
And the result is?
Does it ask for substitution variable?
Is the view invalid?
Do queries on this view return wrong result?
|
|
|
Re: how to use the & symbol in text [message #327436 is a reply to message #327416] |
Mon, 16 June 2008 07:07   |
Dipali Vithalani
Messages: 278 Registered: March 2007 Location: India
|
Senior Member |
|
|
17:34:09 SQL> [B]set define off[/B]
17:34:13 SQL> create or replace view v2 as select * from dept
17:34:17 2 where dname = 'F&F Closed - Payable';
View created.
Elapsed: 00:00:00.00
17:34:18 SQL> select * from v2;
no rows selected
Elapsed: 00:00:00.00
17:34:24 SQL> [B]set define on[/B]
17:34:35 SQL> select * from v2;
no rows selected
Elapsed: 00:00:00.00
17:34:38 SQL> select * from dept
17:34:59 2 where dname = 'F&F Closed - Payable';
Enter value for f:
old 2: where dname = 'F&F Closed - Payable'
new 2: where dname = 'F Closed - Payable'
no rows selected
Elapsed: 00:00:00.00
17:35:03 SQL> select * from v2;
no rows selected
Elapsed: 00:00:00.00
17:35:14 SQL>
Hope this would help you clear your concepts..
|
|
|
Query [message #328192 is a reply to message #327402] |
Thu, 19 June 2008 05:49   |
spmano1983
Messages: 269 Registered: September 2007
|
Senior Member |
|
|
Friends
OHRID Status New_Amount Old _Amount
303027055 F&F Closed - Payable 100
303027055 5000
How can we get
OHRID Status New_Amount Old _Amount
303027055 F&F Closed - Payable 100 5000
Thanks
|
|
|
Re: Query [message #328193 is a reply to message #328192] |
Thu, 19 June 2008 05:50   |
spmano1983
Messages: 269 Registered: September 2007
|
Senior Member |
|
|
Friends
OHRID Status New_Amount Old _Amount
303027055 F&F Closed - Payable 100
303027055 5000
How can we get
OHRID Status New_Amount Old _Amount
303027055 F&F Closed - Payable 100 5000
Thanks
|
|
|
|
|
Re: how to use the & symbol in text [message #328200 is a reply to message #327412] |
Thu, 19 June 2008 06:12   |
msmallya
Messages: 66 Registered: March 2008 Location: AHMEDABAD, GUJARAT
|
Member |
|
|
If you are still searching for a solution, then you can replace
and PAC.segment1 like 'F&F Closed - Payable'
with
and PAC.segment1 like 'F'||'&'||'F Closed - Payable'
Regards,
MSMallya
|
|
|
|