Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
How To Display Output Message Like DBMS_OUTPUT.PUT_LINE In Oracle Using PostgreSQL || Learn PL/pgSQL
How To Display Output Message Like DBMS_OUTPUT.PUT_LINE In PostgreSQL Using PgAdmin | Learn PL/pgSQL
-- The Purpose is to Display Message like DBMS_OUTPUT.PUT_LINE
-- of Oracle in PostgreSQL
CREATE OR REPLACE PROCEDURE public.proc(p_num1 IN numeric,p_num2 IN numeric)
CREATE OR REPLACE PROCEDURE public.testing_procedure(p_msg text)
LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
BEGIN
INSERT INTO public.testing_table(dummy_column) VALUES('Before Inserting Parameter Value');
INSERT INTO public.testing_table(dummy_column) VALUES (p_msg);
INSERT INTO public.testing_table(dummy_column) VALUES('After Inserting Parameter Value');
END;
$BODY$;
SELECT * FROM public.testing_table;
DELETE from public.testing_table;
CALL public.testing_procedure('Hello Akram, How are you?');
Before Inserting
the message I pass as a parameter
After Inserting...
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
How To Resolve/Fix Issue Could Not Connect To Server Connection Refused In PostgreSQL pgAdmin 4
How To resolve Issue Application Server Could Not Be Contacted In PostgreSQL
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
pg_restore -U postgres -d dvdrental D:\dvdrental.tar psql -U postgres postgres < D:\dvdrental.sql The Purpose is to load database using CMD in PostgreSQL, 2 ways to do it.
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
In this video, I have explained How To Take Backup Of Database As SQL/TAR File And How Restore Database In PostgreSQL Using pgAdmin4.
This is a very helpful video if you are a developer working with PostgreSQL.
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
In this project, you can play the popular “Snake Game” just like you played it elsewhere.
You have to use the up, down, right or left arrows to move the snake.
Foods are provided at the several co-ordinates of the screen for the snake to eat.
Every time the snake eats the food, its length will be increased by one element along with the '*'.
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
In this project, a number of questions are asked, and the user is awarded a cash prize for each correct answer given.
In the quiz games, questions are chosen in such a way that they cover all fields of a typical quiz contest.
The user’s general knowledge is tested with quiz questions regarding science, technology, movies, sports, general health, geography, and many more.
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
Using this project, we can easily add, view, edit, search, and delete contacts.
We can list contacts by name, phone no., address, and email.
File handling is used to record all data so that after the termination of the program data persists.
Here a data structure is used to store the name, email, and contact.
The coding of the project is short and simple.
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
Using this project you can perform and manage billing operations like they do in Telecom companies.
You can also make payment by providing your phone number instead of name and all data added or modified are recorded in a file.
You can add records with name, phone number, and the amount of payment, and You can view, modify, search, and delete existing records.
This project will also teach you how to add, list, edit, search, and delete records using file handling.
NB: You Need to change Drive/File path accordingly, Here I am doing in D:
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
In the C Tic Tac Toe game is a simple console application without graphics.
While making a Tic Tac Toe game using C language, it is important to make use of arrays.
The Xs and Os are kept in different arrays, and they are passed between several functions in the code to keep track of how the game goes.
With the code here you can play the game choosing either X or O against the computer.
To put your turn, you need to specify the position thinking it as a 3x3 array. For example,
if you want to put your turn in the middle of 3rd row, you should enter 8 and so on.
The game is so built, either it's Drawn or the Computer Wins, challenge for you to play this game and win against the computer !!!
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
The main purpose of this Hangman game project is to illustrate the use of control structures.
Hangman Game has been designed to demonstrate different application formats and syntaxes of C programming language.
The source code of the game is easy, short, understandable, and user friendly and when you start the game, the game asks you to guess a character.
The Hangman Game in C gives five chances to guess and If you are able to match the character in five guesses, you will be the winner.
If you fail to match the character in fives guesses, you will lose the game and hanged by Hangman Game in C.
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
How To Create And Call Stored Procedure In PostgreSQL Using pgAdmin4
Procedure In PostgreSQL.
In this video, I explained How To Create and Call a Stored Procedure in PostgreSQL.
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
RETURNING A TABLE FROM A FUNCTION IN POSTGRESQL
Sometimes for our needs, we may need to return a table from a user-defined function a table. In this blog, we will see how to accomplish this using the PostgreSQL database.
Before going to function and it’s implementation, let’s create a table and store several dummy records in it.
After insertion, let’s check the table values by executing the below statement.
select * from public.functiontest;
CREATE TABLE public.FunctionTest
(
id numeric,
name character varying
);
ALTER TABLE public.FunctionTest
OWNER to postgres;
We have created a table named FunctionTest having 2 columns only.
Let’s put records in it.
INSERT INTO public.functiontest(
id, name)
VALUES (1, 'Akram');
INSERT INTO public.functiontest(
id, name)
VALUES (2, 'Sohail');
The output is shown in the above snapshot.
Now suppose we want to retrieve all the data available in the table by using a user-defined function.
To do it, let’s create a function.
CREATE OR REPLACE FUNCTION public.get_data(
)
RETURNS TABLE(v_id numeric, v_name character varying)
LANGUAGE 'plpgsql'
COST 100
VOLATILE
ROWS 1000
AS $BODY$
DECLARE
BEGIN
RETURN QUERY
SELECT
id,name
FROM
public.functiontest;
END;
$BODY$;
ALTER FUNCTION public.get_data()
OWNER TO postgres;
We have created a simple function get_data() that will return us all the data present in the table functiontest.
To return a table from the function, we use RETURNS TABLE syntax and specify the columns of the table. Each column is separated by a comma (,).
In the function, we return a query that is a result of a SELECT statement. We can see that the columns in the SELECT statement must match with the columns of the table that we want to return.
To call the function, we use the following statement.
SELECT public.get_data();
As we know, the function is returning a table, so here is the output for the called function.
We can also call the function as below, that gives better tabular form output.
SELECT * from get_data();
The above snapshot are the outcome of the function get_data().
So in this way we return a table from a function in PostgreSQL.
Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
Hello Friends, I am Akram and in this blog, I will tell you how to download and install the PostgreSQL 12.3 latest release in your windows 10 PC of 64 bit.
1. Click this link to download the installation file, which is of 190 MBs.
2. Install the file and follow step by step procedure.
3. When the installation is done, click on the finish.
4. Search for PgAdmin.
5. Now Enter the password you had given while installing.
Note:- Please take a screenshot of the configuration summary. If you forgot to, please watch the video again and uninstall the file and again install it.
