Table A, Table B is there, that colums are different like
tabl A contian (A varchar(9), B varchar(2), date), table B
contian(D varchar(10), E varchar(2), F date) , i want 2
compare mismath datatype length in both table, how? do you
know any in built function?

Answer Posted / kavi

using describe function v can find out that mis math datatype.

desc tabl a, table b;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between slice and dice and cross tab report?

607


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1725


How were the reports scheduled and how to resolve unexecuted documents?

2223


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3927






What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1624


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

556


What is package in BO

2687


How would you format some text using css to be verdana and bold?

674


How to open a universe with out using the Designer ??

6622


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1629


Can Bo generates the Report from the cubical data Explain?

1628


Explain what are the measure objects?

553


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1761


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

593