Creating the tables Data from T1 Data from T2 Left outer join In the below example left table is T1 and right table is T2. Left outer join will cause tuples of the left table (T1) to be preserved, the … Continue reading
This is the enhanced code for sending customized mail when automation step fails in Tufin. When the Tufin triggers, it sends the ticket_info to the input stream. the code has to read from the input stream and parse the xml.
This is a try out for using cx_Oracle module maintained by Oracle. The version I am trying is version 12.2 Here’s the same code: The above is a test out code, to test on how to connect to the oracle … Continue reading
I got myself a free basic account to do some hands on try outs. It is not necessary to use the AWS SDK to invoke the API. This try out is to write a simple static script to create a … Continue reading
All the examples will use this simple table for explanation. Attribute is column, and tuple is row. In this table the attributes are from A to F. Functional dependency A is determinant, B is dependant. B is functional dependent on … Continue reading
The above code snippet is an email script that is triggered when Tufin fails an automated step. The challenge now is to include a ticket number to the email.
This is to count the number of rows in a table. Cyrus is the owner and customer is the table.