PLSQL procedure to find the minimum of the two number

DECLARE a number; b number; c number; 

PROCEDURE findMinimum(x IN number, y IN number, z OUT number) IS
BEGIN
    IF x < y
         THEN z:= x;
    ELSE
         z:= y;
    END IF;
END; 

BEGIN
    a:= 12;
    b:= 13;
    findMinimum(a, b, c);
    dbms_output.put_line(' Minimum of (12, 13) : ' || c);
END;
/

PLSQL Procedure to print HELLO WORLD!!

CREATE OR REPLACE PROCEDURE beginner

AS 

 BEGIN 

         dbms_output.put_line('HELLO WORLD!!'); 

 END; 

/

// to execute 

EXECUTE beginner;

Node js program to write HELLO WORLD

 // node js code to create a server and write HELLO WORLD!

var http = require ('http');

http.createServer (function (req,res) => {
res.writeHead(200, {'Content-Type': 'text/html'});
res.end('HELLO WORLD!');})
.listen(8080);

// Copy and paste the above code into a file and name it helloworld.js
// Now to run it, open the command prompt and go to the file location
// Execute the first command - >
//                                                 npm i http
//Execute the second command ->
//                                                node helloworld.js
// now open browser and copy and paste the link in the URL - http://localhost:8080

C++ Program to call the function

## C++ Program to call the function ##

#include<iostream.h>
#include<conio.h>
class first
{  
public:
   void my()
    {
      cout<<"Welcome to C++";
     }
};
void main()
{
first a;
a.my();
getch();
}


===OUTPUT=== 

Welcome to C++

Java Program to print an integer entered by user

## Java program to print an integer ##

import java.util.Scanner;

public class PrintInteger {

    public static void main (String[] args){
    
        Scanner reader = new Scanner (System.in);    

        System.out.println ("Input a Number: ");

        int number = reader.nextInt ();

        System.out.println ("Number you entered: " + number);
    }

}

===OUTPUT===

Input a Number: 4

Number you entered: 4

Node JS program to connect to SQL table and use WHERE clause

  ## Node JS program to connect to SQL table and use WHERE clause ## 

var mysql = require ('mysql');

// create a connection 
var con = mysql.createConnection({
    host: "localhost",
    user: "admin",
    password: "admin",
    database: "dummy"
});

con.connect(function(err)){
    if (err) throw err;

    con.query("Select * from student where age>15", function (err, result, fields) {
    if (err) throw err;
   
    console.log (" Result is: ", result);
    });
});

Node JS program to delete a text file

 ## Node JS program to delete a text file ##

var fs = require ('fs');

fs.unlink ('file.txt', function (err){
    if (err) throw err;

    console.log (' File deleted successfully!! ');
});

===OUTPUT===

Run the program using the node command:
$ node deleteFile.js
File deleted successfully!! 

C++ program to create star pattern

WRITE A PROGRAM TO PRINT THE FOLLOWING STAR PATTERN

#include<iostream.h>
#include<conio.h>
void main()
{
 clrscr();
 int i, j, n;
 cout<<"Enter number of rows\n";
 cin>>n;
 for(i=1;i<=n;i++)
  {
   for(j=1;j<=i;j++)
    {
     cout<<"*";
    }
   cout<<endl;
  }
 for(i=n-1;i>=1;i--)
  {
   for(j=1;j<=i;j++)
    {
     cout<<"*";
    }
   cout<<endl;
 }
 getch();
}

Node JS program to connect to sql server

## Node js program to connect to SQL server ##

var express = require ('express');
var app = express();

app.get ('/', function (req,res){
    var sql = require ("mssql");

    // database config
    var config = {
        user: 'admin',
        password: 'admin',
        server: 'localhost',
        database: 'db'
    };

    // Database connectivity
    sql.connect (config, function (err){
        if (err) console.log (err);
        
        //create a request object
        var request = new sql.Request();

        // database query
        request.query (' Select * from student', function (err, record){
        res.send (record);
        });
    });
});

var server = app.listen(3000, function (){
    console.log (' Server running ....');
});