Wednesday, May 26, 2021

Financial Year Oracle PLSQL Program

CREATE OR REPLACE function FINANCIAL_YEAR(p_date DATE) return varchar2 IS

v_first varchar2(4);

v_second varchar2(4);

v_year varchar2(4);

first_date date;

second_date date;

third_date date;

four_date date;

financial_year varchar2(9);

BEGIN

v_year := to_char(p_date,'yyyy');

first_date := to_date('01-APR-'||v_year);

second_date := to_date('31-dec-'||v_year);

third_date := to_date('01-JAN-'||v_year);

four_date := to_date('31-MAR-'||v_year);

IF p_date >= first_date AND p_date <= second_date THEN

financial_year := to_char(v_year||'-'||to_number(v_year+1));

END IF;

IF p_date >= third_date AND p_date <= four_date THEN

financial_year := to_char(to_number(v_year)-1||'-'||to_number(v_year));

END IF;

return financial_year;

END;

Monday, September 28, 2020

Java String Class and its method Program

public class MyClass

{

public static void main(String args[])

{

String a = new String("College");

String b = new String("Sushmit");

String z = new String("Sushmit");

System.out.println("value of a -> " + a);

System.out.println("value of b -> " + b);

System.out.println("Converting string into upper case -> " + a.toUpperCase());

String c = b.toUpperCase();

System.out.println("Converting string into upper case -> " + c);

boolean res;

c = c.toLowerCase();

System.out.println("Converting string into Lower case -> " + c);

c = a.replace('S','x');

System.out.println("Converting string into Lower case -> " + c);

res = a.equals(b);

System.out.println("Output is -> " + res);

System.out.println("Output is -> " + a.equals(b));

res = z.equals(b);

System.out.println("Output is equal -> " + res);

System.out.println("Output is equal -> " + z.equals(b));

res = z.equalsIgnoreCase(b);

System.out.println("Output is Ignore Case -> " + res);

System.out.println("Output is Ignore Case -> " + z.equalsIgnoreCase(b));

int count;

count = z.length();

System.out.println("Output is Length -> " + count);

System.out.println("Output is Length -> " + z.length());

System.out.println("Output is Length -> " + z.charAt(4));

count = b.compareTo(z);

System.out.println("Output is Compare to -> " + count);

System.out.println("Output is Compare to -> " + b.compareTo(z));

z = b.concat(z);

System.out.println("Output is Concate -> " + z);

System.out.println("Output is Concate -> " + b.concat(z));

System.out.println("Output is SUbstring -> " + a.substring(11));

System.out.println("Output is SUbstring -> " + a.substring(4,8));

System.out.println("Output is Value of -> " + String.valueOf(c));

System.out.println("Output is Index of -> " + a.indexOf('s'));

System.out.println("Output is Index of -> " + a.indexOf('s',3));

}

Wednesday, September 23, 2020

जावा - अस्थैतिक चर सदस्य

इस क्रमादेश में तीन क्लास kaksha में तीन सदस्य चरों को घोषित किया गया है। इन्हे कन्स्ट्रक्टर के माध्यम से प्रारंभिकरण किया गया है। फलन show_data के माध्यम से निर्गत को स्क्रीन पर मुद्रित किया गया है। मेन फलन में kaksha का अभिलक्ष्य बनाकर show_data फलन को निष्पादित किया गया है। इस क्रमादेष में सभी सदस्य अस्थैतिक है।

जावा क्रमादेश

-------------------------------------

class kaksha

{

int admid;

String name;

String batch;

public kaksha( int p_admid, String p_name, String p_batch )

{ admid = p_admid;

name = p_name;

batch = p_batch;

}

public void show_data()

{

System.out.println("\n Admission ID -> " + admid);

System.out.println("\n Name -> " + name);

System.out.println("\n Batch -> " + batch);

}

class main_class_2109

{

public static void main(String args[])

{

kaksha bca_2021= new kaksha(41730,"Prachi","2018-21");

kaksha bca_2022 = new kaksha(41702,"Ritika","2019-22");

kaksha bca_2023 = new kaksha(43460,"Ankita","2020-23");

bca_2021.show_data();

bca_2022.show_data();

bca_2023.show_data();

}

-----------------

क्रमादेश में उपयोग किये गये

अस्थैतिक चर एवं फलन की स्मृति संरचना

छात्र स्पष्ट रूप से देख सकतें है कि प्रत्येक अभिलक्ष्य ने स्वयं के चरों एवं फलनों हेतु स्मृति में व्यक्तिगत स्थान है।

Friday, September 18, 2020

Student Class - Java Prorgram ( जावा क्रमादेश)

class student

{

int admid;

String name;

String course;

String batch;

public void get_data()

{

admid = 43460;

name = "Ankita Sharma";

course = "BCA";

batch = "2018-2021";

}

public void show_data()

{

System.out.println("admin id ->" + admid);

System.out.println("\n name "+ name);

System.out.println("\n Course "+ course);

System.out.println(" \n Batch " + batch);

}

class class_main

{

public static void main(String args[])

{

student obj = new student();

obj.get_data();

obj.show_data();

}

Tuesday, August 4, 2020

क्रमादेशन भाषा/संरचित पृच्छा भाषा पुस्तक की लिपि

CREATE TABLE vibhag

(

id NUMBER(2,0),

naam VARCHAR2(14),

sthan VARCHAR2(13),

CONSTRAINTS pk_vibhag PRIMARY KEY (id)

);

INSERT INTO vibhag(id,naam,sthan)

VALUES(10,'DHARM','KEDARNATH');

INSERT INTO vibhag(id,naam,sthan)

VALUES(20,'ARTH','SOMNATH');

INSERT INTO vibhag(id,naam,sthan)

VALUES(30,'KAAM','VISHWANATH');

INSERT INTO vibhag(id,naam,sthan)

VALUES(30,'MOKSHA','MAHAKAAL');

CREATE TABLE karmchari

(

id NUMBER(4,0),

naam VARCHAR2(10),

karya VARCHAR2(9),

adhikari NUMBER(4,0),

pratham_dinank DATE,

vetan NUMBER(7,2),

dastoor NUMBER(7,2),

vibhagid NUMBER(2,0),

CONSTRAINTS pk_karmchari PRIMARY KEY ( id),

CONSTRAINTS fk_vibhag FOREIGN KEY (vibhagid) REFERENCES vibhag (id)

);