×
In order to succeed, we must first believe that we can.
--Your friends at LectureNotes
Close

Lab Manual for Database Management System - DBMS by Johnson Gade

  • Database Management System - DBMS
  • Practical
  • Chaitanya institute of science & technology - Jntuk
  • Computer Science Engineering
  • B.Tech
  • 16 Views
  • Uploaded 3 months ago
Johnson Gade
Johnson Gade
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1

EXP NO. : ……………… DATE : ……………….… AIM : Queries to facilitate acquaintance of Built-In Functions, String Functions, Numeric Functions, Date Functions and Conversion Functions. String functions Lower () : Convert the text to lower-case: SQL> select Lower ('Data Base Management Systems') as lower from dual; LOWER ------------------------------------data base management systems Upper () : Convert the text to upper-case : SQL> select upper ('Data Base Management Systems') as upper from dual; UPPER ----------------------------------------------------DATA BASE MANAGEMENT SYSTEMS Concat () : Concatenate strings together: SQL> select concat('John','son') as concat from dual; CONCAT -----------Johnson 1 PIN NO. :

Text from page-2

EXP NO. : ……………… DATE : ……………….… Length () : Return the length of the string, in bytes: SQL> select length('Data base Management Systems') as Length from dual; LENGTH --------------28 Instr () : Search for “3” in string “Database”, and return position : SQL> select instr('Database','b') AS Position from dual; POSITION --------------5 Substr () : Extract a substring from a string (start at position 5, extract 3 characters): SQL> select substr('Database', 3, 3) as str from dual; STR -----tab Lpad () : Returns a string that is left-padded with a specified string to a certain length: SQL> select lpad('Databse', 15, '+*+*') as lpad from dual; LPAD ---------------------+*+*+*+*Databse 2 PIN NO. :

Text from page-3

EXP NO. : ……………… DATE : ……………….… Rpad () : Returns a string that is right-padded with a specified string to a certain length: SQL> select rpad('Databse', 15, '+*+*') as lpad from dual; LPAD ----------------------Databse+*+*+*+* Ltrim () : Removes leading spaces from a string : SQL> select ltrim(' Johnson') as ltrim from dual; LTRIM ---------Johnson Rtrim () : Removes trailing spaces from a string SQL> select rtrim('Johnson ') as ltrim from dual; LTRIM ---------Johnson Numeric Functions : ABS () : Retruns the absolute value of a number : 3 PIN NO. :

Text from page-4

EXP NO. : ……………… DATE : ……………….… SQL> select abs(-243.25) from dual; ABS(-243.25) ----------------243.25 Count () : Returns the count of an expression : SQL> select count(ID) from employee; COUNT(ID) ---------------5 Floor () : Return the largest integer value that is equal to or less than a number : SQL> select floor(569852.45632) from dual; FLOOR(569852.45632) ----------------------------569852 Exp () : Returns e raised to the power of number : SQL> select exp(1) from dual; EXP(1) ---------------2.71828183 SQL> select exp(10) from dual; 4 PIN NO. :

Lecture Notes