Nasar's Blog

Heading here

Type Text here

Explore Our Milestones

  • CATEGORIES and TAGS

    All categories and ta Read more ⇢

  • Qualify

    Snowflake QUALIFY function In a SELECT statement, the QUALIFY clause filters the results of window functions. QUALIFY does with window functions what HAVING does with aggregate functions and GROUP BY… Read more ⇢

  • XSL

    XSL, or Extensible Stylesheet Language, is a language used for expressing style sheets. It is primarily used for transforming and rendering XML documents. You can think of XSL as a… Read more ⇢

  • Extract data from XML

    https://www.freeformatter.com/xpath-tester.html From BIP data model, goto CODE tab and select the xml string and paste it above website (option 1) In XPath expression type the following: /output/nodeList/dataStructure/group/element/@name Make sure to… Read more ⇢

  • Snowflake

    Read more ⇢

  • How to get data from API into Python

    Read more ⇢

  • Hide null rows and Sort rows/columns in oac dv workbook

    In OAC dv visualization, there is no option to hide NULL rows,  like we have in oac classic analysis. Here is the workaround, to suppress NULL rows in a   oac… Read more ⇢

  • SQL tips

    Bind variable in DDL is not allowed You cannot user a bind variable in DDL statements and ALTER is considered a DDL statement. You would need to use dynamic sql… Read more ⇢

  • Databricks Links

    https://databricks.com/learn/training/home (official training) ]https://databricks.com/try-databricks (Databricks Community Edition, free) https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks (Databricks on Azure) https://databricks.com/product/aws (Databricks on AWS) https://databricks.com/product/google-cloud (Databricks on Google Cloud) Read more ⇢

  • sql MODEL BY clause

    The MODEL clause enables you to create a multidimensional array by mapping the columns of a query into three groups: partitioning, dimension, and measure columns. These elements perform the following… Read more ⇢

  • Importing Analytic View through BI Admin tool

    Read more ⇢

  • Manage Level based hierarchies in OAC rpd

    OAC documenation: https://docs.oracle.com/en/middleware/bi/analytics-server/datamodel-oas/create-and-manage-level-based-hierarchies.html Oracle OAC blog: https://blogs.oracle.com/analytics/post/oracle-analytics-best-practices-for-dimensional-hierarchies-level-keys-and-content-levels OAC best practices: https://blogs.oracle.com/analytics/post/oracle-analytics-best-practices-series-optimal-performance-and-usage Read more ⇢

  • Using In-Memory with Analytic Views

    https://docs.oracle.com/en/database/oracle/oracle-database/19/inmem/populating-objects-in-memory.html In-Memory activation at CDB level alter system set heat_map=ON scope=spfile;alter system set db_keep_cache_size=400M scope=spfile;alter system set inmemory_size=400M scope=spfile;alter system set inmemory_max_populate_servers=4 scope=spfile;alter system set inmemory_virtual_columns=enable scope=spfile;alter system set “_inmemory_64k_percent”=5… Read more ⇢

  • Find Large tables in database

    Select t.owner,t.table_name,to_char(nvl(sum(s.bytes),0) / 1024 / 1024 , ‘9999999.99’) mbfrom dba_tables t,dba_segments swhere –t.table_name not like ‘DECOM_%’ escape ‘\’ — does not start with decom_— t.owner = :schemas.owner(+) = t.ownerand s.segment_name(+)… Read more ⇢

  • Oracle APEX

    YouTube videos by Oracle https://www.youtube.com/@OracleAPEX Blogs https://blogs.oracle.com/apex/ https://videohub.oracle.com/esearch/search?keyword=apex   (some non-English content also) APEX documentation https://docs.oracle.com/en/database/oracle/apex/index.html  APEX discussion forum  https://forums.oracle.com/ords/apexds/domain/dev-community/category/apex APEX community https://apex.oracle.com/pls/apex/f?p=411:18 Read more ⇢

  • Snowflake Forums

    How to use SNOWSPARK with Python,Java, Scala, Javascript  and External Functions https://community.snowflake.com/s/topic/0TO3r000000oXQvGAM/snowpark Snowflake SQL forum https://community.snowflake.com/s/topic/0TO31000000k9zhGAA/sql Migrations https://community.snowflake.com/s/topic/0TO3r000000bskFGAQ/migrations Snow Sight  UI https://community.snowflake.com/s/topic/0TO3r000000buDqGAI/snowsightui Ask Me Anything https://community.snowflake.com/s/topic/0TODo0000004PuAOAU/ask-me-anything Read more ⇢

Read more: CATEGORIES and TAGS