Suppose we are 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?
Submitted by: AdministratorIf 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online SQL Server Errors Job Interview Questions And Answers
Top SQL Server Errors Questions
☺ | What is sqlcode -922 & -923? |
☺ | What will be the program output if it tries to access 11th item in an array of 10 and it is coded with NOSSRANGE? |
☺ | In one table there is 10 records without id num, without primary key and it is not sorted then how to extract last 6 record from table? |
☺ | How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error? |
☺ | What is meant by write off and write on in sap? |
Top Exception Handling Categories
☺ | ERRORS Interview Questions. |
☺ | Scripts Errors Interview Questions. |
☺ | Oracle Errors Interview Questions. |
☺ | C C++ Errors Interview Questions. |
☺ | DotNet Errors Interview Questions. |