Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6614 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between Bookmark lookup & RID lookup?
What is the use of NOLOCK locking hint?
hp asking for replication floppy to do reinstall 25254 server assistant
Is the company liable to deduct professional tax of directors?
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.
Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?
How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error.
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.
What is SCD (Slowly Changing Dimensions)? What are its types?
What are row constructors?
How many types of internal joins are there in SQL Server?
How will you Handle Error in SQL SERVER 2008?
Oracle Errors 
