- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Environmental Science
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- articles and Answers
- Effective Resume Writing
- HR Interview articles
- Computer Glossary
- Who is Who
CEO & Founder of Codegyan
About
Prathmesh Yelne is an Indian artist, web developer, painter and Hindi, Urdu, English poet and Lyricist. He is known for founding the Educational Website Codegyan Pvt Ltd. Of which he is the chairman and chief executive officer.
Prathmesh Yelne has Published 381 Answers
Problem Statement : Write a program to read the values of x, y and z and print the results of the following expressions in one line. (x+y+z) / (x-y-z) (x+y+z) / 3 (x+y) * (x-y) * (y-z) Program : #include<stdio.h> #include<conio.h> void main() { int x, y, z; float a, b, c; clrscr(); printf("\nEnter the values of x,y and z : "); scanf("%d %d %d", &x, &y, &z); a = (x + y + z) / (x - y - z); b = (x + y + z) / 3; c = (x + y) * (x - y) ... Read More
Hello, in this tutorials we are going to create Animated Login Form Using Only HTML CSS SignIn Form Design. In the last tutorial we created Slicing Design Newsletter Subcribe Modal using HTML & CSS. HTML <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Login Form | Codegyan Pvt Ltd</title> <link rel="stylesheet" href="./style.css"> &... Read More
Different database management systems have different queries to see all the tables. To see all the tables in MYSQL, we would have to use this query: show tables; This is how we can see all tables in ORACLE: SELECT table_name FROM User_tables; This is how we can extract all tables in SQL Server: SELECT * FROM Information_schema.tables; ... Read More
To understand exactly what is MYSQL, we need to understand what is DBMS and RDBMS. DBMS stands for Database Management System. When we have a huge database with us, we would need a proper management system which would help us organise this database. There are 4 types of database management systems: Hierarchical Network Relational Object – Oriented. Out of these database management systems, MYSQL comes under the category of Relational database management system. A relati... Read More
PL SQL stands for Procedural language constructs for Structured Query Language. PL SQL was introduced by Oracle to overcome the limitations of plain sql. So, pl sql adds in procedural language approach to the plain vanilla sql. One thing to be noted over here is that pl sql is only for oracle databases. If you don’t have an Oracle database, then you cant work with PL SQL. While, with the help of sql, we were able to DDL and DML queries, with the help of PL SQL, we will be able to create ... Read More
To view tables in SQL, all you need to do is give this command: Show tables; ... Read More
Introduction : In the world of databases, a primary key is a fundamental concept that plays a crucial role in maintaining data integrity and ensuring efficient data retrieval. It is a concept that is essential for anyone working with relational databases and forms the backbone of their structure. In this article, we will delve into the definition of a primary key, explore its examples, understand its significance, and learn how to choose and implement it effectively. Definition of Primary ... Read More
If the RDBMS is MYSQL, this is how we can insert date: INSERT INTO tablename (col_name, col_date) VALUES (‘DATE: Manual Date’, ‘2020-9-10’); ... Read More
To understand what exactly is SQL Server, we need to understand what is DBMS and RDBMS. DBMS stands for Database Management System. When we have a huge database with us, we would need a proper management system which would help us organise this database. There are 4 types of database management systems: Hierarchical Network Relational Object-Oriented. Out of these database management systems, SQL Server comes under the category of Relational database management system. A re... Read More
Joins are used to combine rows from two or more tables, based on a related column between them. Types of Joins: • INNER JOIN − Returns rows when there is a match in both tables. • LEFT JOIN − Returns all rows from the left table, even if there are no matches in the right table. • RIGHT JOIN − Returns all rows from the right table, even if there are no matches in the left table. • FULL OUTER JOIN − Returns rows when there is a match in one of the tables. • ... Read More
ads