-
The student (student’s name, total number, major, grade point
average, level)
Required
Set the appropriate data types with the fields listed and assign
the student's university number to be a master key.
The inclusion of five records with complete data for the previous
fields.
This is done by creating the table and specifying the primary
key and constraints through a window:
Go to database Home Page→OBJECT BROWSER
Through it, the necessary steps are followed - to create the
table, define restrictions, and fill in the data.
Write SQL/PL commands that allow
Data printing. The student is complete for the university number
23779
Note: The entire code is written (definition of variables and
exceptions if present, etc.)
the solution:
The required is implemented by writing the code in the SQL commands
window, creating the table, specifying data types and restrictions
from the object Browser window, then filling in the data through
the option: data
- The Student Data Database Contains The Following Table The Student Student S Name Total Number Major Grade Poin 1 (8.62 KiB) Viewed 39 times
- The Student Data Database Contains The Following Table The Student Student S Name Total Number Major Grade Poin 2 (104.55 KiB) Viewed 39 times
- The Student Data Database Contains The Following Table The Student Student S Name Total Number Major Grade Poin 3 (125.98 KiB) Viewed 39 times
previous picture, the data is filled in from the data option and
then create and create another until the required data is
completed.
. 1. To print the complete student data for the university
number 23779
You can switch between the SQL COMMAND and OBJECT BROWSER window
through the HOME option in the top left of the page.
- The Student Data Database Contains The Following Table The Student Student S Name Total Number Major Grade Poin 4 (26.36 KiB) Viewed 39 times
- The Student Data Database Contains The Following Table The Student Student S Name Total Number Major Grade Poin 5 (88.01 KiB) Viewed 39 times
ORACLE Database Express Edition User: SYSTEM Home > SQL > SQL Commands Autocommit Display 10 Results Explain Describe Saved SQL History Enter SQL statement or PL/SQL command and click Run to see the results.
ORACLE Database Express Edition her STIM Home > Out Browser Tables std LOGSTOBYSAPPLY_MILESTONE LOGOTDEYSAPPLY_PROGRESS LOGSTOOYSEVENTS LOGSTDBYSHISTORY LOBSTDBYSPWRAMETERS LOGSTDBYSPUSOL LOGSTDEYSSON LOGSTDAYSSKIP LOOSTDEYSSKIP SUPPORT LOGSTDEYSSKIP TRANSACTION STD Table Data Indexes Model Constraints Grants Statistics Default Triggers Dependencies SQL And Cute Modity Clemente Columns Columns Cheyence Centenoks Tallie Column Name Data TypeNullabie betaalt Primary. Key STO_O NUMBER NAME VARCHAR2(4000) MAJOR VARCHAR(4000) Yes AVERAGE NUMBER AC LEVEL VARCHAR240001 Yes 1.5 NO Yos STO
declare x varchar2(30); new std%rowtype; begin select * into new from std where std_id=23779; dbms_output.put_line(new.name|l'id: '||new.std_id||' Major: '||new.major||' Average is: '||new.average||'level:'||new.ac_level); exception when others then dbms_output.put_line('error'); end; / 100%
ORACLE Database Express Edition SYSTEM Home > SQL> SQL, Commands Autocommit Display 10 declara x varchar(30); new stotype; begin select into new from std where std 1d-23779 dons output.put line now.nanell' idi Tinew.std idll' major new.major Il' Average is: 'new averagell' level:'linu.ac_level): exception when others then dins outratyt_in'error") and; Results Explain Describe Saved SOL History raha id: 23779 Major: PO Average is: 4.5 level:2 statement processed. 0.01 seconds