Flashcards
dbs midterm
Flashcards do conjunto (26)
- 1aliasbruh
- 2display table stucture eliminate duplicate rowsdescribe
distinct - 3between in likevalue and value
('value','value')
wildcard: %_ - 4null,and or not, asc, descbruh
- 5& and &&prompt user for value
reuse the previously prompted value - 6define undefine verifyset and unset value from variable
verify shows the var - 7upper lower initcapbruh
- 8concat substr length instrcolumn1,column2
column,num,char
column
column,string,start,occurence# - 9lpad rpad replace trimcolumn, num,char
column,num,char
text,searchstr,replacestr
char FROM source - 10return current date and timesysdate
- 11rr date format vs yy date formatknow
- 12round trunc modnum, decimal places
""
num,num - 13math w datesknow
- 14months_between add_months next_day last_day round truncdate,date
date,numMonth
date,whatdayofweek
date,whatdayofweek
date,'MONTH'
date,'YEAR' - 15TO_DATE TO_NUMBER TO_CHARstr,format
str,format
number/date,format - 16TH SPth
spelled out - 17nvl nvl2 nullifcolumn,string
column,strIfTrue,strIfFalse
column, column
last returns null if 2 columns are equal - 18coalesceexp,exp,exp,etc
returns first non-null expression in expression list - 19avg max min sum count varienceknow
- 20know when to use where and havingbruh
- 21natural jointables have same names and data types for both tables
- 22usingused for equijoins so u can join 2 tables when one column is the same for both
- 23on clausespecify join conditions that are seperate
- 24subqueries: IN ANY ALLequal to any member to the list
=,!=,<,>,<=,>=
<,>,<=,>= - 25equivalent of <> ALLNOT IN
- 26order by recognized by which queryfirst
Informações
- Descrição
- FlashCards sobre dbs midterm, criado por hasdfhfsd gsdhhgsdh em 15-10-2019.
- Criado por
- hasdfhfsd gsdhhgsdh
- Visualizações
- 0
- Avaliação