Oracle Fusion | SQL Query from OTBI front end

[@chetankuber]

Very useful video and many thanks. Can we use a like clause in condition? I tried to use it instead of '=' but its not showing up any results. e.g. 'And journal_name like '%Asset%'

[@lavanyamathi3760]

Great Job .....Thanks for your Video.It is very clear cut .

[@SuhasVaze]

Thank you Lavanya

[@ExploreEuroCulture]

Well explained, easy to understand

[@SuhasVaze]

Thank you Bijaya !

[@snehapujar6666]

Can we create a SQL table using rule text (extension rule) and how to get existing table value by extension rule..?
Please help ..!

[@Lokesh-hx3rq]

The video title is misleading, you ran a custom query in Oracle BI, not in OTBI.

[@veerabhadra4708]

Simple Nd easy to understand 👍👍👍

[@SuhasVaze]

Thank you Veera

[@harshgoyal8867]

Great video.. Thanks for your efforts

[@SuhasVaze]

Thank you Harsh

[@mtoracle]

Thanks

[@SuhasVaze]

You are welcome !

[@franciscobarrios2890]

very useful, thanks!

[@SuhasVaze]

Thank you Francisco

[@viswanadhapps2583]

Hi Sir Could you please say is there any limit for Data Rows?

[@SuhasVaze]

Dear Viswanadh, There is no limit for the total number of rows. You can set a limit for the rows per page

[@snehapujar6666]

Can we insert value and modify?

[@SuhasVaze]

Dear Sneha, No OTBI SQL does not support updates and additions of rows

[@snehapujar6666]

@@SuhasVaze that means we can't create any tables also in fusion?

[@SuhasVaze]

@@snehapujar6666 although we cannot create tables through OTBI SQL functionality, Fusion has given other methods to create tables if necessary. Generally such tables are created through import of excel templates wherever supported by Oracle (For example: AHC)

[@snehapujar6666]

@@SuhasVaze thank you.😊

[@lavanyamathi3760]

Can you make video on how to identify tables that we require for our project

[@SuhasVaze]

Sure, if time permits