In this tutorial, we are getting to find out how to use SQL in PL/SQL. SQL is that the actual component that takes care of fetching and updating of knowledge within the database whereas PL/SQL is that the component that processes these data. Further, during this article, we’ll also discuss the way to combine the SQL within the PL/SQL block. DML Transactions in PL/SQL DML stands […]
(INSERT): Create table dept: CREATE TABLE departments ( deptno NUMBER(2) CONSTRAINT departments_pk PRIMARY KEY, dname VARCHAR2(14), loc VARCHAR2(13)); Insert a single row into a table: INSERT INTO dept VALUES (10, ‘Branding’, ‘Dhaka’); Insert rows from one table into another table: INSERT INTO emp2 SELECT * FROM emp; CREATE TABLE emp3 AS SELECT * FROM emp; […]
What is CRUD operation? Within programming , the acronym CRUD stands for create, read, update and delete. These are the four basic functions of CRUD. Also, each letter within the acronym can ask all functions executed in electronic database applications and mapped to a typical HTTP method, SQL statement or DDS operation. The first regard […]
What is Prime Number? A positive integer greater than 1 which has no other factors except 1 and therefore the number itself is named a prime number. 2, 3, 5, 7 etc. are prime numbers as they are doing not have the other factors. But 6 isn’t prime (it is composite) since, 2 x 3 […]
Program mentioned in below, the three numbers are stored in num1, num2 and num3 respectively. We’ve used the if…elif…else ladder to seek out the Greatest among the three and display it. Source Code # Python program to seek out the Greatest number among the three input numbers # change the values of num1, num2 and […]
What is Leap year: A leap year is exactly divisible by 4 apart from century years (years ending with 00). The century year will be leap year if it is perfectly divisible by 400. For example, 2019 is not a leap year 1700 is a not leap year 2016 is a leap year 2000 is […]
Python Program to see if a Number is Odd or Even CODE OUTPUT # Python program to see if the input number is odd or maybe . # variety is albeit division by 2 provides a remainder of 0. # If remainder is 1, it’s odd numbernum = int(input(“Enter a number: “))if (num % 2) == 0: print(“{0} is Even”.format(num))else: print(“{0} is Odd”.format(num)) Enter a number: 4343 […]
What is SQL? SQL may be a language which is employed to work your database. SQL is that the basic language used for all the databases. There are minor syntax changes amongst different databases, but the essential SQL syntax remains largely an equivalent . SQL may be a short abbreviation of Structured command language . […]
Brief History of Oracle Database: The current version of Oracle Database is a results of over 30 years of innovative development. The main highlights within the evolution of Oracle Database include the following: Founding of Oracle: In 1977, Larry Ellison, Bob Miner, and Ed Oates started the consultancy Software Development Laboratories, which change name to […]
 Visit Today : 75 |
 Visit Yesterday : 97 |
 This Month : 2022 |
 This Year : 7402 |