<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Dhaval Singh on Medium]]></title>
        <description><![CDATA[Stories by Dhaval Singh on Medium]]></description>
        <link>https://medium.com/@dhavalsingh_37254?source=rss-185dce164aa0------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*yGhA_T0GvQ2zEUSBvAMdHg.png</url>
            <title>Stories by Dhaval Singh on Medium</title>
            <link>https://medium.com/@dhavalsingh_37254?source=rss-185dce164aa0------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 04:52:02 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@dhavalsingh_37254/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Transitioning from SQL to NoSQL Databases: What You Need to Know]]></title>
            <link>https://medium.com/@dhavalsingh_37254/transitioning-from-sql-to-nosql-databases-what-you-need-to-know-05689f0407c6?source=rss-185dce164aa0------2</link>
            <guid isPermaLink="false">https://medium.com/p/05689f0407c6</guid>
            <dc:creator><![CDATA[Dhaval Singh]]></dc:creator>
            <pubDate>Sun, 06 Oct 2024 18:35:23 GMT</pubDate>
            <atom:updated>2024-10-06T18:35:23.059Z</atom:updated>
            <content:encoded><![CDATA[<p>In today’s data-driven world, the traditional SQL (relational) databases are no longer the only option for developers and data engineers. With the explosion of unstructured data, scalability challenges, and the need for flexibility, NoSQL databases have gained popularity.</p><p>If you’re coming from a SQL background and want to transition to NoSQL, this guide will walk you through the key concepts, differences, and how to make the shift easier. We’ll also explore a few real-world examples to help you get a practical understanding of how SQL and NoSQL differ.</p><h3>1. SQL vs NoSQL: The Fundamental Differences</h3><h3>Relational vs Non-relational</h3><ul><li><strong>SQL databases</strong> are based on a relational model, which means data is organized into tables (rows and columns) with defined relationships. This structure is excellent for structured data, where relationships are essential, and data consistency is paramount.</li><li><strong>NoSQL databases</strong> (Not Only SQL) are non-relational, meaning they can store and retrieve data that doesn’t necessarily adhere to the tabular structure. This is particularly useful for unstructured or semi-structured data such as documents, graphs, and key-value pairs.</li></ul><h3>Schema Flexibility</h3><ul><li><strong>SQL</strong> databases use a fixed schema, meaning the structure of the database (tables, columns, etc.) is predefined. This can become restrictive if your data evolves over time.</li><li><strong>NoSQL</strong> databases offer dynamic schema capabilities, allowing data models to be more flexible and adapt to changes without the need for altering the structure every time you add new data fields.</li></ul><h3>ACID vs BASE</h3><ul><li><strong>SQL databases</strong> adhere to ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring high data integrity and consistency.</li><li><strong>NoSQL databases</strong> tend to follow the BASE (Basically Available, Soft state, Eventual consistency) model, where data consistency is relaxed for the sake of scalability and availability.</li></ul><h4>Example:</h4><p><strong>SQL</strong>:</p><pre>CREATE TABLE Users (</pre><pre>id INT PRIMARY KEY,<br>    name VARCHAR(100),<br>    email VARCHAR(100),<br>    created_at TIMESTAMP<br>);</pre><pre>INSERT INTO Users (id, name, email, created_at)<br>VALUES (1, &#39;John Doe&#39;, &#39;john@example.com&#39;, NOW());</pre><p><strong>NoSQL (MongoDB)</strong>:</p><pre>db.users.insertOne({</pre><pre>_id: 1,<br>    name: &quot;John Doe&quot;,<br>    email: &quot;john@example.com&quot;,<br>    created_at: new Date()<br>});</pre><p>Notice the difference in structure: SQL enforces a predefined schema, whereas NoSQL (MongoDB) allows the flexibility of adding fields as needed.</p><h3>2. Types of NoSQL Databases</h3><p>To transition effectively, it’s essential to understand the different types of NoSQL databases:</p><ul><li><strong>Document-based (e.g., MongoDB)</strong>: Stores data as documents (usually JSON or BSON). It’s best for scenarios where you need flexibility in the schema and store hierarchical data.</li><li><strong>Key-Value Stores (e.g., Redis, DynamoDB)</strong>: Data is stored as key-value pairs, making it useful for fast retrievals based on a specific key.</li><li><strong>Column-based (e.g., Apache Cassandra, HBase)</strong>: Designed for reading and writing large amounts of data across distributed systems, often used for big data applications.</li><li><strong>Graph-based (e.g., Neo4j)</strong>: Data is represented as nodes and edges, which is useful when working with highly interconnected data such as social networks.</li></ul><h3>When to Choose Each:</h3><ul><li><strong>Document-based (MongoDB)</strong>: Use when you need flexible schemas and frequently evolving data (e.g., content management systems, IoT data).</li><li><strong>Key-Value (Redis)</strong>: Great for caching, session management, and scenarios requiring low latency.</li><li><strong>Column-based (Cassandra)</strong>: Best for handling massive datasets in a distributed system, such as real-time analytics.</li><li><strong>Graph-based (Neo4j)</strong>: Ideal for applications dealing with complex relationships, such as fraud detection or recommendation engines.</li></ul><h3>3. Migrating from SQL to NoSQL: Key Considerations</h3><h3>1. Understand the Data Models</h3><p>In SQL, data is normalized and split into different tables to eliminate redundancy (normalization). When transitioning to NoSQL, you’ll need to <strong>denormalize</strong> your data to fit into collections (in MongoDB) or key-value pairs (in Redis). NoSQL databases often prioritize performance over the strict relationships SQL databases maintain.</p><h4>Example:</h4><p>In SQL, you might split a blog post into separate tables for posts, authors, and comments. In MongoDB, this could all be stored as a single document:</p><pre>{  &quot;title&quot;: &quot;My First Post&quot;,<br>    &quot;author&quot;: {<br>        &quot;name&quot;: &quot;Jane Doe&quot;,<br>        &quot;email&quot;: &quot;jane@example.com&quot;<br>    },<br>    &quot;comments&quot;: [<br>        {&quot;text&quot;: &quot;Great post!&quot;, &quot;author&quot;: &quot;User1&quot;},<br>        {&quot;text&quot;: &quot;Thanks for sharing&quot;, &quot;author&quot;: &quot;User2&quot;}<br>    ]<br>}</pre><p>This allows for faster reads since all related data is stored together, but at the expense of storage efficiency.</p><h3>2. Consider Querying Differences</h3><p>The way you query data in SQL (using joins and complex queries) is quite different from NoSQL. While SQL uses JOIN statements to retrieve related data across tables, NoSQL databases (like MongoDB) avoid joins for performance reasons.</p><h4>SQL Example:</h4><pre>SELECT orders.id, customers.name<br>FROM orders<br>JOIN customers ON orders.customer_id = customers.id;</pre><h4>NoSQL (MongoDB) Example:</h4><p>Instead of performing a join, data would already be embedded, allowing for a simple query:</p><pre>db.orders.find({customer: { name: &quot;John Doe&quot; }<br>});</pre><h3>3. Indexing and Performance Optimization</h3><p>Indexing works differently in NoSQL databases. In MongoDB, for example, you can create indexes on fields much like you would in a SQL database, but how the database uses the index internally may vary. Ensure you understand how to optimize queries based on the NoSQL database you’re using.</p><h4>MongoDB Index Example:</h4><pre>db.users.createIndex({ email: 1 });</pre><h3>4. Real-World Use Cases of SQL to NoSQL Migration</h3><h3>1. eBay (MySQL to MongoDB):</h3><p>eBay needed a scalable solution to handle its vast and growing amount of product listings and user data. While MySQL could handle transactions, MongoDB allowed eBay to store large, unstructured product data efficiently, thanks to its flexible document-based model.</p><h3>2. Netflix (Cassandra for Real-Time Data):</h3><p>Netflix transitioned from Oracle (a relational database) to Apache Cassandra for their global user base. The need for a distributed, fault-tolerant system capable of handling large data volumes led them to choose Cassandra. Its column-based, distributed architecture allowed Netflix to maintain high availability and scalability.</p><h3>3. Twitter (MySQL and NoSQL Combination):</h3><p>Twitter uses a combination of MySQL and various NoSQL solutions (e.g., Redis, Cassandra). MySQL handles user data and relationships, while Redis and Cassandra power real-time feeds and message distribution to millions of users.</p><h3>5. Tips for a Successful Transition</h3><ul><li><strong>Start with a hybrid approach</strong>: In many cases, you don’t need to fully abandon SQL. Companies like Twitter and Facebook still use a combination of SQL and NoSQL to meet their needs.</li><li><strong>Understand your data access patterns</strong>: Analyze how your application reads and writes data. If you have frequent reads with relatively few updates, a NoSQL solution might be a good fit.</li><li><strong>Consider your scaling needs</strong>: NoSQL databases shine when you need horizontal scalability. If your SQL database is struggling with massive workloads, transitioning to NoSQL may be the answer.</li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=05689f0407c6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Advanced SQL Techniques: Optimizing Queries for Performance]]></title>
            <link>https://medium.com/@dhavalsingh_37254/advanced-sql-techniques-optimizing-queries-for-performance-f89a6f49508f?source=rss-185dce164aa0------2</link>
            <guid isPermaLink="false">https://medium.com/p/f89a6f49508f</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[dba]]></category>
            <category><![CDATA[database]]></category>
            <dc:creator><![CDATA[Dhaval Singh]]></dc:creator>
            <pubDate>Fri, 02 Aug 2024 16:41:22 GMT</pubDate>
            <atom:updated>2024-08-02T16:41:22.666Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DIGDuqhn91V7NSUhF5hICg.png" /></figure><h3>Introduction</h3><p>Slow queries can be a database administrator’s worst nightmare. They can drastically impact application performance, frustrate users, and even bring systems to a halt. This is where query optimization comes in. By understanding how queries are executed and employing advanced techniques, you can significantly improve the speed and efficiency of your database.</p><h3>Understanding Query Execution</h3><p>Before diving into optimization, it’s essential to grasp the fundamental steps involved in query execution:</p><ol><li><strong>Parsing:</strong> The database breaks down the SQL statement into components it understands.</li><li><strong>Optimization:</strong> The query optimizer creates an execution plan, determining the most efficient way to retrieve the data.</li><li><strong>Execution:</strong> The database follows the execution plan to retrieve and process data.</li></ol><p>While the optimizer is a powerful tool, it’s not infallible. It relies on statistics and assumptions, which can sometimes lead to suboptimal plans.</p><h3>Advanced SQL Optimization Techniques</h3><h4>Indexing</h4><p>Indexes are data structures that accelerate data retrieval. They create a searchable copy of specific columns, allowing the database to quickly locate rows without scanning the entire table.</p><ul><li><strong>Types of Indexes:</strong> B-tree, function-based, bitmap</li><li><strong>Creating Effective Indexes:</strong> Identify frequently queried columns, consider index selectivity, and balance index creation with maintenance overhead.</li></ul><h4>Query Rewriting</h4><p>Often, inefficient query structures can be improved through rewriting.</p><ul><li><strong>Replace subqueries with joins:</strong> This can often lead to better performance, especially for correlated subqueries.</li><li><strong>Eliminate unnecessary calculations:</strong> Remove calculations that don’t impact the result set.</li><li><strong>Reduce data volume:</strong> Use techniques like filtering and limiting data early in the query.</li></ul><h4>Execution Plans</h4><p>Understanding execution plans is crucial for identifying performance bottlenecks.</p><ul><li><strong>Reading Execution Plans:</strong> Learn to interpret the plan’s structure, operations, and costs.</li><li><strong>Identifying Bottlenecks:</strong> Look for full table scans, sorts, and large amounts of data transferred.</li><li><strong>Optimization Based on Plans:</strong> Create or modify indexes, rewrite queries, or gather statistics.</li></ul><h4>Window Functions</h4><p>Window functions provide powerful capabilities for calculations across rows without subqueries. They can often improve query performance and readability.</p><ul><li><strong>Common Window Functions:</strong> RANK, DENSE_RANK, ROW_NUMBER, LEAD, LAG, and aggregate functions with OVER clause.</li><li><strong>Performance Benefits:</strong> Utilize window functions to replace correlated subqueries or complex joins.</li></ul><h4>Common Table Expressions (CTEs)</h4><p>CTEs enhance readability and can sometimes improve performance by simplifying complex queries.</p><ul><li><strong>CTE Structure:</strong> Define named result sets that can be referenced multiple times in the main query.</li><li><strong>Performance Considerations:</strong> Use CTEs judiciously, as they can introduce overhead in some cases.</li></ul><h3>Case Studies and Real-World Examples</h3><ul><li><strong>Case Study 1:</strong> A slow-running report was optimized by creating a composite index on frequently filtered columns.</li><li><strong>Case Study 2:</strong> A complex query with multiple subqueries was rewritten using joins and CTEs, resulting in a significant performance boost.</li></ul><h3>Best Practices and Tips</h3><ul><li><strong>Regularly monitor query performance.</strong></li><li><strong>Gather and analyze statistics.</strong></li><li><strong>Test changes in a controlled environment.</strong></li><li><strong>Consider indexing strategies carefully.</strong></li><li><strong>Continuously learn and improve your skills.</strong></li></ul><h3>Conclusion</h3><p>Optimizing SQL queries is an ongoing process that requires a combination of knowledge, tools, and experience. By mastering advanced techniques and following best practices, you can dramatically enhance the performance of your database applications.</p><p><strong>Remember:</strong> Every database environment is unique. Experimentation and fine-tuning are essential for achieving optimal results.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f89a6f49508f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Oracle Autonomous Database and SQL Developer]]></title>
            <link>https://medium.com/@dhavalsingh_37254/oracle-autonomous-database-and-sql-developer-94372e83c4cb?source=rss-185dce164aa0------2</link>
            <guid isPermaLink="false">https://medium.com/p/94372e83c4cb</guid>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[developer]]></category>
            <category><![CDATA[autonomous]]></category>
            <category><![CDATA[database]]></category>
            <dc:creator><![CDATA[Dhaval Singh]]></dc:creator>
            <pubDate>Tue, 21 Sep 2021 09:08:04 GMT</pubDate>
            <atom:updated>2021-09-21T09:08:04.916Z</atom:updated>
            <content:encoded><![CDATA[<p>There are two pre-requisite to connect your oracle Autonomous database with the SQL Developer tool:</p><p>1. Later Version of SQL Developer (by the time of writing this blog it was 20.4.1)</p><p>2. Client Credential Wallet.</p><p>You can download the SQL developer tool from the oracle website.</p><p>Now to get the Client credential wallet, login to your oracle cloud account and navigate to the Autonomous Database section, select the database you want to connect in the SQL developer tool.</p><figure><img alt="" src="https://cdn-images-1.medium.com/proxy/1*b31hiO4ynbDLRrXWEFF4aQ.png" /></figure><p>Navigate to the <strong>DB Connection</strong> tab</p><figure><img alt="" src="https://cdn-images-1.medium.com/proxy/1*b31hiO4ynbDLRrXWEFF4aQ.png" /></figure><p>You will be prompted to download the client credential wallet (Its a zip file)</p><figure><img alt="" src="https://cdn-images-1.medium.com/proxy/1*b31hiO4ynbDLRrXWEFF4aQ.png" /></figure><p>enter the password to start downloading and save the downloaded zip file at some locations on your PC.</p><p>This password is for opening the zip file so make note of it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/proxy/1*b31hiO4ynbDLRrXWEFF4aQ.png" /></figure><p>Now open SQL Developer -&gt; New Connection.</p><figure><img alt="" src="https://cdn-images-1.medium.com/proxy/0*nEiKFFgT0o6m_Kcq.png" /></figure><p>Name your connection.</p><p>provide the username and password of your database user.</p><p>you can use the admin user and password as well.</p><p>Set connection type to Cloud wallet.</p><p>Navigate to the folder where you have saved your zip file.</p><p>Test the connection and voila.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=94372e83c4cb" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL MERGE Statement for Better Performance]]></title>
            <link>https://medium.com/@dhavalsingh_37254/sql-merge-statement-for-better-performance-163be4e7e3d6?source=rss-185dce164aa0------2</link>
            <guid isPermaLink="false">https://medium.com/p/163be4e7e3d6</guid>
            <category><![CDATA[postgres]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[merge]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Dhaval Singh]]></dc:creator>
            <pubDate>Tue, 21 Sep 2021 09:05:03 GMT</pubDate>
            <atom:updated>2021-09-21T09:05:03.997Z</atom:updated>
            <content:encoded><![CDATA[<p>I have come across a scenario where I have to insert or update the data in a table based on some source table depending on whether the data exists. And the first thing that comes to mind most of the time is doing something like this.</p><blockquote><strong>— update the table</strong></blockquote><blockquote><strong>update some_table set</strong></blockquote><blockquote><strong>col_1 = value1,</strong></blockquote><blockquote><strong>col_2 = value2,</strong></blockquote><blockquote><strong>col_3 = value3</strong></blockquote><blockquote><strong>where pk_col = some_value;</strong></blockquote><p>— checking using the sql%rowcount, whether the row is updated and if not then simply insert the data.</p><blockquote><strong>IF SQL%ROWCOUNT = 0 THEN</strong></blockquote><blockquote><strong>INSERT INTO some_table (col_1, col_2, col_3)</strong></blockquote><blockquote><strong>VALUES (value_1, value_2, value_3);</strong></blockquote><blockquote><strong>END IF;</strong></blockquote><p>I believe most of you at least once in your carrier had code something like this. Now, this looks alright if you have a small number of rows that need to be processed, but what if the number of rows is in thousands or millions.</p><p>When processing this amount of rows, the first thing that comes into our big brain is to use the collection, so the above logic becomes something like this:</p><blockquote><strong>declare</strong></blockquote><blockquote><strong>TYPE t_tab IS TABLE OF some_table%ROWTYPE;</strong></blockquote><blockquote><strong>l_tab t_tab;</strong></blockquote><blockquote><strong>Begin</strong></blockquote><blockquote><strong>SELECT *</strong></blockquote><blockquote><strong>BULK COLLECT INTO l_tab</strong></blockquote><blockquote><strong>FROM some_table</strong></blockquote><blockquote><strong>FOR i IN l_tab.first .. l_tab.last</strong></blockquote><blockquote><strong>LOOP</strong></blockquote><blockquote><strong>BEGIN</strong></blockquote><blockquote><strong>INSERT INTO some_other_table(col_1, col_2, col_3) // considerting col_1 as a PK</strong></blockquote><blockquote><strong>VALUES (l_tab(i).value_1, l_tab(i).value_2,l_tab(i).value_3);</strong></blockquote><blockquote><strong>EXCEPTION</strong></blockquote><blockquote><strong>WHEN OTHERS THEN</strong></blockquote><blockquote><strong>UPDATE some_other_table SET</strong></blockquote><blockquote><strong>col_2= l_tab(i).value_2,</strong></blockquote><blockquote><strong>col_3= l_tab(i).value_3</strong></blockquote><blockquote><strong>WHERE col_1= l_tab(i).col_1;</strong></blockquote><blockquote><strong>END;</strong></blockquote><blockquote><strong>END LOOP;</strong></blockquote><blockquote><strong>end;</strong></blockquote><p>now let’s try to rebuild this using the MERGE statement and then I will show you how to compare and calculate the performance.</p><blockquote><strong>BEGIN</strong></blockquote><blockquote><strong>MERGE INTO some_other_table a</strong></blockquote><blockquote><strong>USING some_table b</strong></blockquote><blockquote><strong>ON (a.col_1 = b.col_1) // col_1 is a reference ID in both the tables</strong></blockquote><blockquote><strong>WHEN MATCHED THEN</strong></blockquote><blockquote><strong>UPDATE SET</strong></blockquote><blockquote><strong>col_2 = b.col_2,</strong></blockquote><blockquote><strong>col_3 = b.col_3,</strong></blockquote><blockquote><strong>WHEN NOT MATCHED THEN</strong></blockquote><blockquote><strong>INSERT (col_1, col_2, col_3)</strong></blockquote><blockquote><strong>VALUES (b.col_1, b.col_2, b.col_3);</strong></blockquote><blockquote><strong>END;</strong></blockquote><p>This looks short and simple with no need to use bulk collect and collection and rather than going in rows the MERGE operation works on the sets of data and performs better in many scenarios.</p><p>Use the script below and edit as per your requirement to calculate and compare the performance:</p><blockquote><strong>DECLARE</strong></blockquote><blockquote><strong>TYPE t_tab IS TABLE OF source_tab%ROWTYPE;</strong></blockquote><blockquote><strong>l_tab t_tab;</strong></blockquote><blockquote><strong>v_start NUMBER;</strong></blockquote><blockquote><strong>BEGIN</strong></blockquote><blockquote><strong>— calculating the time for the merge operation</strong></blockquote><blockquote><strong>v_start := DBMS_UTILITY.get_time;</strong></blockquote><blockquote><strong>MERGE INTO some_other_table a</strong></blockquote><blockquote><strong>USING some_table b</strong></blockquote><blockquote><strong>ON (a.col_1 = b.col_1) // col_1 is a reference ID in both the tables</strong></blockquote><blockquote><strong>WHEN MATCHED THEN</strong></blockquote><blockquote><strong>UPDATE SET</strong></blockquote><blockquote><strong>col_2 = b.col_2,</strong></blockquote><blockquote><strong>col_3 = b.col_3,</strong></blockquote><blockquote><strong>WHEN NOT MATCHED THEN</strong></blockquote><blockquote><strong>INSERT (col_1, col_2, col_3)</strong></blockquote><blockquote><strong>VALUES (b.col_1, b.col_2, b.col_3);</strong></blockquote><blockquote><strong>DBMS_OUTPUT.put_line(‘MERGE Operation: ‘ || (DBMS_UTILITY.get_time — v_start) || ‘ sec’);</strong></blockquote><blockquote><strong>ROLLBACK;</strong></blockquote><blockquote><strong>— calculating the time for bulk collect/collection</strong></blockquote><blockquote><strong>v_start := DBMS_UTILITY.get_time;</strong></blockquote><blockquote><strong>SELECT *</strong></blockquote><blockquote><strong>BULK COLLECT INTO l_tab</strong></blockquote><blockquote><strong>FROM some_table</strong></blockquote><blockquote><strong>FOR i IN l_tab.first .. l_tab.last</strong></blockquote><blockquote><strong>LOOP</strong></blockquote><blockquote><strong>BEGIN</strong></blockquote><blockquote><strong>INSERT INTO some_other_table(col_1, col_2, col_3) // considerting col_1 as a PK</strong></blockquote><blockquote><strong>VALUES (l_tab(i).value_1, l_tab(i).value_2,l_tab(i).value_3);</strong></blockquote><blockquote><strong>EXCEPTION</strong></blockquote><blockquote><strong>WHEN OTHERS THEN</strong></blockquote><blockquote><strong>UPDATE some_other_table SET</strong></blockquote><blockquote><strong>col_2= l_tab(i).value_2,</strong></blockquote><blockquote><strong>col_3= l_tab(i).value_3</strong></blockquote><blockquote><strong>WHERE col_1= l_tab(i).col_1;</strong></blockquote><blockquote><strong>END;</strong></blockquote><blockquote><strong>END LOOP;</strong></blockquote><blockquote><strong>DBMS_OUTPUT.put_line(‘Using Bulk collect and Collection: ‘ || (DBMS_UTILITY.get_time — v_start) || ‘sec’);</strong></blockquote><blockquote><strong>ROLLBACK;</strong></blockquote><blockquote><strong>END;</strong></blockquote><blockquote><strong>/</strong></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=163be4e7e3d6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Cleanfox to rescue your emails]]></title>
            <link>https://medium.com/@dhavalsingh_37254/cleanfox-to-rescue-your-emails-a-tech-d6a415fafdf4?source=rss-185dce164aa0------2</link>
            <guid isPermaLink="false">https://medium.com/p/d6a415fafdf4</guid>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[cleanfox]]></category>
            <category><![CDATA[email]]></category>
            <category><![CDATA[security]]></category>
            <category><![CDATA[spam]]></category>
            <dc:creator><![CDATA[Dhaval Singh]]></dc:creator>
            <pubDate>Sun, 08 Apr 2018 18:41:39 GMT</pubDate>
            <atom:updated>2018-04-08T18:46:10.031Z</atom:updated>
            <content:encoded><![CDATA[<p>The first thing that I do every morning after getting ready for the office is to go through my emails. And then I start deleting dozens of emails which I don’t need.</p><p>Well I know it’s very annoying but we use our email ID in lot places and we end up getting those unwanted emails by the names of newsletters and promotional emails.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*akMDbooHyQueXkzQ.png" /></figure><p>One thing you can do is to start unsubscribing from all the services you do not want sending you emails.</p><p>One way to do this by opening each email and then look for the unsubscribe option to opt out.</p><p>Another very simple way is to use a service like <strong>unroll.me</strong> which can let you unsubscribe through all your subscription emails in a very Tinder like fashion.</p><p>But again it is not the very effective way as after sometimes you start getting those emails and you end up spending a lot of time in deleting those annoying emails.</p><h3>Efficient way to get rid of these mails</h3><p>Recently I came across an Android application called <strong>Cleanfox</strong> that lets you unsubscribed from that newsletter and also lets you delete all the existing old emails from the subscribed services in a single click and that too on a very interesting concept.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*mJhM4R8X-z0-MTWD.jpg" /></figure><p>Cleanfox claims an email emits about 10g of CO² per year. Yes, you read that right 10 gram of CO² is the annual carbon footprint of an email.</p><p>More than 200 million emails are sent every minute. Emails are directly responsible for the emission of more than 2,000 tons of CO² per minute!</p><p>This application will inform you on statistics about how much carbon dioxide is reduced per year by opting out and deleting all those unwanted emails. This must be the <strong>most ecological way of cleaning your mailbox.</strong></p><p>Cleanfox currently supports almost all major email providers like Gmail, Yahoo, Microsoft (Hotmail and Outlook), Orange, SFR, Free, AOL, La Poste, Noos, Numericable, GMX, BBOX (and Bouygtel), Apple and iCloud.</p><p>Cleanfox is currently in English and French languages.</p><p>The developers also <strong>claim to plant a tree</strong> for every person that creates an account on Cleanfox. They are partnered with <strong>WeForest Project</strong> to fight against deforestation in Zambia.</p><p>You can use my personal <strong>sponsor code:</strong> <strong>Folksy-Claim-N63</strong> to join Cleanfox and let’s build a greener tomorrow.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d6a415fafdf4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Online Data Privacy- a Modern day Myth]]></title>
            <link>https://medium.datadriveninvestor.com/online-data-privacy-a-modern-day-myth-70e085bd1090?source=rss-185dce164aa0------2</link>
            <guid isPermaLink="false">https://medium.com/p/70e085bd1090</guid>
            <category><![CDATA[application]]></category>
            <category><![CDATA[security]]></category>
            <category><![CDATA[ecommerce]]></category>
            <category><![CDATA[privacy]]></category>
            <category><![CDATA[technology]]></category>
            <dc:creator><![CDATA[Dhaval Singh]]></dc:creator>
            <pubDate>Sun, 08 Apr 2018 18:31:00 GMT</pubDate>
            <atom:updated>2018-04-20T06:27:56.775Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KycLCjuYj9lia_VnKEK1EA.jpeg" /></figure><p>Online Data privacy sounds like a modern-day myth. Social media tech giants like Google and Facebook seems to have taken the matter of privacy for granted.</p><p>Last week #deleteFacebook took over the world of internet by storm and users all around the globe are in shock.</p><p>Many have gone out to express their anger on social media and have also gone to the extent to completely delete their facebook account.</p><p>Once a good friend of mine had told me that in order to apply for a job in google you do not have to send your resume, Google knows everything better than you do your qualification, your address, your ex, your future partner and what not.</p><p>It sounds funny and scary at the same time. It’s high time that YOU take the matter of protecting your data in your own hand and follow these steps to ascertain your data does not fall into the wrong hands.</p><h3>Follow the following steps:</h3><p><strong>Step1</strong> — Run a quick pawned search for all your email id’s on <a href="https://haveibeenpwned.com/">https://haveibeenpwned.com/</a></p><p><strong>Step2</strong>- If the above result in a danger red sign that means your email id has already been leaked to some third party and you should immediately change your password.</p><p>Keep a strong password of at least 15 characters and please do not use something like <strong>password1234567</strong> or any such password that includes your name or your date of birth.</p><p><strong>Step3</strong>- Enable the two-factor authentication.</p><p>And most importantly be wise and keep changing your password at certain intervals. Keep changing your password every month.</p><p><strong>Step4</strong>- Stop using Facebook, Twitter, Amazon account for signing up for other services.</p><p>This step is very crucial as it involves data exchange between third-party services. I know it is very easy and saves a lot of time by avoiding filling up those long sign up forms but it comes with a huge risk.</p><h4>Let me give you a real instance.</h4><p>Recently I have installed an app called Audible from play store it provides a lot of Audiobooks.</p><p>As soon as I have opened the app I was being prompted to use my Amazon account to create a new Audible account.</p><p>Now I was using the 30-day trial service from Audible and on the 31st day, I have received a message from my bank that certain amount has been deducted from a service called Audible.</p><p>I have contacted Audible for the explanation of how they have access to my debit card details which I have never provided to them and the response I got from them was really shocking and upsetting.</p><p>They said Audible and Amazon are same company and the Debit card details that I stored in my Amazon can be used by an Amazon subsidiary. Shocking right! This lets to next step.</p><p><strong>Step5</strong>- Do not save your debit/credit card details on any e-commerce platform.</p><p>I certainly will not delete my facebook account but will surely implement the next few steps (6–7) to control how Facebook uses my data to share it with third-party websites.</p><p><strong>Step6</strong>- Go to setting -&gt; Apps -&gt; List of all the website where your Facebook credentials and data are used.</p><p>Remove all the unwanted websites and services which you no longer use.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*N33iKYNOArzdtNbZ.jpg" /></figure><p><strong>Step7</strong>- Restrict the amount of personal data that Facebook share with different advertising agencies.</p><p>Go to setting -&gt; Ad preferences -&gt; Your information -&gt; un select the data you no longer wish to share.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*t9_JppdoUZ1wiYS0.jpg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*9GK9X5ofFutjdDQI.jpg" /></figure><p><strong>Step8 </strong>— Do not click links or download attachments in your emails from an unwanted sender. You can use <a href="https://virusdesk.kaspersky.com/">https://virusdesk.kaspersky.com/</a> to scan for any virus or trojan.</p><p>To conclude the topic, protecting your data from prying eyes on the internet falls in your own hand. Be smart and safe.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=70e085bd1090" width="1" height="1" alt=""><hr><p><a href="https://medium.datadriveninvestor.com/online-data-privacy-a-modern-day-myth-70e085bd1090">Online Data Privacy- a Modern day Myth</a> was originally published in <a href="https://medium.datadriveninvestor.com/">DataDrivenInvestor</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>