Viraj Sabhayavirajsabhaya23.hashnode.dev·Mar 18, 2024Database Developer Interview Questions1. What is the difference between PL SQL and SQL? ComparisonPL/SQLSQL ExecutionSingle command at a timeBlock of code ApplicationSource of data to be displayedApplication created using the data from SQL Structures includeDDL and DML based que...DiscussSQL
Yasith Wimukthiyasithwimukthi.hashnode.dev·Jan 22, 2024Mastering the Power of PL/SQL: A Comprehensive Guide to Efficient Database ProgrammingPL/SQL, or Procedural Language/Structured Query Language, is a programming language that's a big deal in the world of Oracle databases. It's like the secret sauce that makes your database applications robust and efficient. Think of it as the wizard b...Discuss·93 readsSQL
Sahitya Guptasahityagupta25.hashnode.dev·Jan 11, 2024How to group data , Sub-queries & questions: Enhancing(SQL) (Part-4)PRE-REQUISTES PART-1 (Understand concept of all keys (theory) and what are anomalies in database) PART-2 (CRUD operations in database , learn syntax & understand concept by doing) PART-3 (1st Normal form , 2NF , 3NF , Partial Dependency , Transitive ...DiscussFundamentals & Core Concepts of Database Management System (SQL)BlogsWithCC
pradnya dhongadepradnyaa.hashnode.dev·Jan 1, 2024Concept of DevOpsIf you want to build better software faster, DevOps is the answer. In today's fast-paced digital landscape, businesses are constantly seeking ways to deliver high-quality software faster and more efficiently. This is where DevOps comes into play. Dev...Discuss·46 readsDevops
Sahitya Guptasahityagupta25.hashnode.dev·Dec 26, 2023Super Key , Primary key , Candidate Key , Functional Dependency , Anomalies: Enhancing (SQL) (Part-1)What is Normalization? Normalization is the process of organizing the data in the database. It simply means there should be no redundancy . Redundancy means duplicate data , so avoid redundancy we should use normalization. If you are managing the Du...Discuss·35 readsFundamentals & Core Concepts of Database Management System (SQL)BlogsWithCC
Sahitya Guptasahityagupta25.hashnode.dev·Dec 24, 2023Mastering PL/SQL : Syntax, Identifiers , Comments , Declaration , Datatypes (Part-1) .What PL/SQL ? PL/SQL is nothing but a combination of SQL along with the procedural features of programming language. It means that in SQL we run query one at a time but in PL/SQL we make a program in which we use SQL and that program works similar li...DiscussAdvanced Database Management System (PL/SQL)BlogsWithCC
Priya Jainpriya-jain.hashnode.dev·Dec 10, 2023Boost Your Database Efficiency with PL/pgSQL - Part 1Ever felt like your database is stuck in slow motion? Meet PL/pgSQL, your new best friend in the world of databases. It's the secret sauce that makes PostgreSQL more awesome than ever by introducing something cool: special tools that live right insid...Discuss·1 likePostgreSQL
Sanjiv Paulsanjivpaul.hashnode.dev·Nov 29, 2023How to run PL/SQL ProgramsPL/SQL (Procedural Language/Structured Query Language), is a programming language designed to manage and manipulate data in Oracle databases. Including procedural features from programming languages expands SQL and enables programmers to create code ...DiscussSQL
Martin Giffy D'SouzaProtalkapex.com·Nov 26, 2023Regular expression patterns [[:upper:]] vs [A-Z]Note: the comparisons in this article also applies to [[:lower:]] vs [a-z] regexp patterns. Oracle regular expressions (regexp) support both [[:upper:]] or [A-Z] to find uppercase letters. At first glance they appear the same. Even regex101.com defin...Discuss·320 readsSQL
Arun Mohanforapexvarsityapexvarsity.com·Oct 19, 2023Course objective and course contentWelcome to our SQL and PL/SQL Essentials for APEX Beginners Course! Course Objective The primary objective of this course is to equip you with a fair understanding of SQL and PL/SQL specifically tailored for Oracle APEX. We understand that as beginne...Discuss·48 readsSQL