Answer / prakash bhoyar

If you have 321 field,
followed this steps
1)open sql.
2)change dir. if ncecessary.
3)then give command
SQL>desc table_name.
4)check the fields.
5)select or copy that field name.
6)and then use that field in like select empno,empname from
emp.
7) use same script in procedure
8) and show your feilds in your screen.

Thanks

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

0 Answers  

---

How many types of internal joins are there in SQL Server?

0 Answers  

---

What are the required/mandatory parameters that have to be passed with RAISEERROR statement?

1 Answers  

---

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

0 Answers   HCL,

---

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

0 Answers  

---

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

0 Answers   Investment Bank,

---

I am experiencing an error failed to retrieve data from data base. it is an oracle table. Is there a limit on the number of fields that can be a report. My table has 321 fields and I do not have all of them in the report yet.

1 Answers  

---

when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.

1 Answers  

---

What is live lock, deadlock and what is Lock escalation?

0 Answers  

---

On which table the SSIS SQL Server logs are stored?

1 Answers  

---

What is the use of NOLOCK locking hint?

0 Answers  

---

How will you Handle Error in SQL SERVER 2008?

0 Answers  

---