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
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...
Explain is there any default username & pwd for bo designer & supervisor?
How many universes can be created in a project?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What is difference between custom hierarchy and report based hierarchy?
Explain is there any other repository domains rather than universe, security, document?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Which versions are used in the bo dashboard work?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How to create Index to the table in the universe designer and how it improves the Query performence
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!!!
how get the grand total in master-detail report?
Can we create universe with no cache??
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?