Create table using SQL. 

Create table using SQL.

SQL> connect
        Enter user-name: pandey121
        Enter password:
        Connected.

        SQL> CREATE TABLE COLLEGE_STUDENT1(ID NUMBER , NAME VARCHAR(20), GENDER VARCHAR(6) , STATE VARCHAR(10));

        Table created.

        SQL> DESC COLLEGE_STUDENT1;
        Name                                      Null?    Type
        ----------------------------------------- -------- ----------------------------
        ID                                                 NUMBER
        NAME                                               VARCHAR2(20)
        GENDER                                             VARCHAR2(6)
        STATE                                              VARCHAR2(10)

        SQL>
        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES(1, 'SHRADDHA NAND PANDEY' , 'MALE' , 'JHARKHAND');

        1 row created.
        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES(2, 'ARYAN' , 'MALE' , 'JHARKHAND');

        1 row created.

        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES(3, 'HARSH KUMAR', 'MALE' , 'JHARKHAND');

        1 row created.

        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES (4, 'NITIN' , 'MALE' , 'JHARKHAND');

        1 row created.
        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES (5, 'PRAKASH', 'MALE' , 'JHARKHAND');

        1 row created.
        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES(6, 'RAYAN' , 'MALE' , 'JHARKHAND');

        1 row created.

        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES(7, 'SONU' , 'MALE' , 'JHARKHAND');

        1 row created.

        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES(8, 'SOMU' ,'MALE' ,'JHARKHAND');

        1 row created.

        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES(9, 'ANUBHAVA' , 'MALE' , 'JHARKHAND');

        1 row created.

        SQL> INSERT INTO COLLEGE_STUDENT1 VALUES(10, 'SUNIL' , 'MALE' ,'JHARKHAND');

        1 row created.

        SQL> SELECT *FROM COLLEGE_STUDENT1;

        ID NAME                 GENDER STATE
        ---------- -------------------- ------ ----------
        1 SHRADDHA NAND PANDEY MALE   JHARKHAND
        2 ARYAN                MALE   JHARKHAND
        3 HARSH KUMAR          MALE   JHARKHAND
        4 NITIN                MALE   JHARKHAND
        5 PRAKASH              MALE   JHARKHAND
        6 RAYAN                MALE   JHARKHAND
        7 SONU                 MALE   JHARKHAND
        8 SOMU                 MALE   JHARKHAND
        9 ANUBHAVA             MALE   JHARKHAND
        10 SUNIL                MALE   JHARKHAND

        10 rows selected.
By:-Shraddha Nand Pandey 😎

Comments

Post a Comment

Popular posts from this blog

the distance between two cities (in km is input through the keyboard. write a program to convert and print this distance in meter ,feet inches and centimeter.

11 . The distance between two cities (in km is input through the keyboard. write a program to convert and print this distance in meter ,feet inches and centimeter. package com.company ; import java.util.Scanner ; public class Main { public static void main ( String [] args ) { // write your code here System . out . print ( "Enter distance between two cities : " ); Scanner sc = new Scanner ( System . in ); //sc is scanner name double distance , meter , feet , inches , centimetres ; //variable is declared distance = sc . nextDouble (); //taking input from user (in km) meter = distance * 1000 ; //1km = 1000m feet = distance * 3280.8399 ; //1km = 3280.8399; inches = distance * 39370.0787 ; //1km = 39370.0787; centimetres = distance * 100000 ; //1km = 100000; System . out . println ( distance + " kilometer = " + meter + " meter" ); System . out . println ( distance + " k
Read more

CREATE UNIT CONVERTER APP

Image
CREATE UNIT CONVERTER APP USING XML AND JAVA IN ANDROID STUDIO xml code :- <? xml version ="1.0" encoding ="utf-8" ?> < androidx.constraintlayout.widget.ConstraintLayout xmlns: android ="http://schemas.android.com/apk/res/android" xmlns: app ="http://schemas.android.com/apk/res-auto" xmlns: tools ="http://schemas.android.com/tools" android :layout_width ="match_parent" android :layout_height ="match_parent" android :background ="#F8E753" tools :context =".MainActivity" > < EditText android :id ="@+id/editTextTextPersonName" android :layout_width ="wrap_content" android :layout_height ="wrap_content" android :ems ="10" android :inputType ="number" android :textColor ="#E91E63" app :layout_constraintBottom_toBottomOf ="parent"
Read more

write a program to check whether a triangle is valid or not, when the threeangles of the triangle are entered through the keyboard. A triangle is valid if the sumof all the three angles is equal to 180 degrees

  /*write a program to check whether a triangle is valid or not, when the three angles of the triangle are entered through the keyboard. A triangle is valid if the sum of all the three angles is equal to 180 degrees. */ package com.company ; import javax.security.sasl. SaslClient ; import java.util.Scanner ; public class Main { public static void main ( String [] args ) { // write your code here int a , b , c , sum ; //angle of triangle Scanner angle = new Scanner ( System . in ); System . out . print ( "side a : " ); a = angle . nextInt (); System . out . print ( "side b : " ); b = angle . nextInt (); System . out . print ( "side c : " ); c = angle . nextInt (); //sum of angle of trinagle sum = a + b + c ; if ( sum == 180 ) { System . out . println ( "Triangle is valid" ); } else System . out . println (
Read more