×
Expect problems and eat them for breakfast.
--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
  • 241 Views
  • Uploaded 9 months ago
Johnson Gade
Johnson Gade
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

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. :

Text from page-5

EXP NO. : ……………… DATE : ……………….… EXP(10) ---------------22026.4658 Round () : Returns a number rounded to a certain number of decimal places : SQL> select round(12354.656887) from dual; ROUND(12354.656887) -----------------------------12355 Power () : Return m raised to the nth power : SQL> select power (5,3) from dual; POWER(5,3) ---------------125 Max () : Returns the maximum value of an expression : SQL> select max(salary) as largestsal from employee; LARGESTSAL ------------------50000 Min () : Returns the minimum value of an expression : SQL> select min(salary) as lowestsal from employee; 5 PIN NO. :

Lecture Notes