Facebook Twitter Google Plus Linkedin Instagram YouTube Pinterest Tumblr VK

Tag: sql

Mastering Hierarchical Queries in Oracle SQL: Using START WITH, CONNECT BY, and ORDER SIBLINGS BY for Parent-Child Relationships

Kumar SauravLeave a comment

Learn how to write hierarchical queries in Oracle SQL using START WITH, CONNECT BY, and ORDER SIBLINGS BY. This comprehensive guide includes examples from Siebel Order Management to help you represent parent-child relationships such as Orders and their Line Items. Perfect for developers and database administrators looking to optimize SQL for hierarchical data!

Search Siebel Repository Scripts Using a PL/SQL Query

Kumar SauravLeave a comment

Tired of spending too much time searching for keywords in Siebel scripts through Siebel Tools? This blog post introduces a faster and more efficient solution using a PL/SQL query. With this query, you can search across Business Component, Applet, Business Service, and Browser Scripts directly from your SQL environment, eliminating the need for Siebel Tools. Learn how to streamline your keyword search process and boost productivity in Siebel development.