Answer / subhash

open session command is used to connect to the database to
the language defined. if i want to connect to the oracle
database with the language French then i will use the open
session command like this

<commandBlock>
<commands>
<sqlCommand>
<sql>ALTER SESSION SET NLS_LANGUAGE = FRENCH
</sql>
</sqlCommand>
</commands>
</commandBlock>


again if i want to reset my connection to the english
language then i have to use close connection command.


<commandBlock>
<commands>
<sqlCommand>
<sql>ALTER SESSION SET NLS_LANGUAGE = ENGLISH
</sql>
</sqlCommand>
</commands>
</commandBlock>

It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

0 Answers  

---

Cleared COG-112 with 100% score today. What next certification should i go for?

0 Answers   IBM,

---

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers   HCL,

---

Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......

1 Answers  

---

What is stitched Query?

5 Answers  

---

Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com

4 Answers  

---

What is called a slice?

0 Answers  

---

Can you define set to be cardinality?

0 Answers  

---

Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!

2 Answers  

---

diff b/w grouping and aggregation

1 Answers   HCL,

---

How to create model and how to test model?

0 Answers  

---

What is Correlated sub-query? Please explain

1 Answers   Target,

---