Sumário Itens Encontrados: 310Download the JDKCreate a ConnectionCreate a New UserCreate a Connection with New UserCreate a TableInsert Some DataLiveSQLPart II: Viewing DataChapter 3: Retrieving DataHow Can You See the Data?What Is the SELECT Statement?A Few Things to NoteOur First SELECT StatementRunning a Statement in SQL DeveloperResultsRun ScriptErrors in SQLMissing KeywordTable Does Not ExistChapter 4: Selecting Specific ColumnsSelecting a Single ColumnSelecting Multiple ColumnsSelecting All ColumnsSELECT Columns or SELECT *?Chapter 5: Restricting the ResultsWhy Restrict Data?What is the WHERE Clause?Example with a Text ValueExample with a Number ValueFinding Rows Not Equal to a ValueGreater ThanGreater Than or Equal ToLess ThanLess Than or Equal ToBest PracticesSpecify Columns on the LeftSelect Only What You NeedChapter 6: Comparing DataWhat Is a Partial Match?Syntax of LIKEThe Percent Wildcard CharacterThe Underscore Wildcard CharacterSearching for Wildcard CharactersPerformanceChapter 7: Applying Multiple FiltersWhy Use Multiple Filters?The AND KeywordFinding Records That Match a Last Name and a SalaryFinding Records that Match Greater Than and Less Than on Two ColumnsThe OR KeywordFinding Records that Match a Last Name or a SalaryFinding Records that Match Greater Than or Less Than on Two ColumnsMore Than Two ConditionsMultiple AND ConditionsMultiple OR ConditionsCombining Multiple AND and OR ConditionsSpecifying the Order with Multiple ConditionsChapter 8: Working with NullsMissing DataWhat is NULL?How Should NULL Be Treated?Examples of Working with NULLAdding More DataSelecting the RecordsRestricting the NULL ValuesHiding Null ValuesMultiple Queries in One SQL WindowChapter 9: Removing Duplicate ResultsAdd New RecordsSelect the DataWhat is DISTINCT?Finding Unique Last Name ValuesFinding Unique Salary ValuesFinding Unique Combinations of ValuesChapter 10: Applying Filters on Lists and Ranges of ValuesToo Many ConjunctionsThe IN KeywordExample of Using INA Longer Value ListUsing IN with Text ValuesUsing IN with Other ClausesIN with AND?IN with LIKE?Filtering on Ranges of ValuesThe BETWEEN OperatorUsing Between with Two Salary ValuesUsing BETWEEN When Values Donât MatchUsing BETWEEN with Text ValuesAn Example of an Inclusive and Exclusive CheckShould You Use BETWEEN?Chapter 11: Ordering Your DataResults Are Not OrderedOrdering Results with ORDER BYORDER BY ExamplesOrder by a Text ValueOrder by a Number ValueOrder by a Column Not in the SELECT ClauseOrder by a NumberORDER BY and NULLsOrder by Multiple ColumnsDo You Really Need to Order Your Data?Chapter 12: Applying Table and Column AliasesWhat is a Table Alias?Example of a Table AliasIntellisense or AutoCompleteLonger Table AliasesWhat If I Donât Use a Table Alias?What Is a Column Alias?Example of a Column AliasThe AS KeywordMathematical Operations and Column AliasesAdditionSubtractionMultiplicationDivisionColumn Aliases with Table AliasesPart III: Adding,Updating,Deleting DataChapter 13: Understanding the Data TypesWhat is a Data Type?Why Do We Have Different Data Types?What Are the Different Data Types?Text Data TypesCHARVARCHAR2NCHARNVARCHAR2RAWLONG RAWNumber Data TypesNUMBERINTEGERFLOATDECIMALBINARY_FLOATBINARY_DOUBLEDate Data TypesDATETIMESTAMPTIMESTAMP WITH TIME ZONETIMESTAMP WITH LOCAL TIME ZONEINTERVAL YEAR TO MONTHINTERVAL DAY TO SECONDOther Data TypesBLOBCLOBData Type RecommendationsChapter 14: Creating a TableCreating Tables Using SQL CodeThe CREATE TABLE StatementOur Employee TableStoring Office DetailsThe Office TableThe Sales Meeting TablePrimary KeyRecording the Employee AgainForeign KeyChapter 15: Adding Data to a TableThe INSERT StatementRunning an INSERT StatementInserting More DataInserting Date ValuesSaving and Undoing ChangesBest Practices for Inserting DataChapter 16: Updating and Removing DataThe UPDATE StatementUpdate to a New ValueChecking an Update Statement Before Running ItUpdate a NULL ValueUpdate Based on Existing ValueUpdate a Date ValueViewing and Updating the Date FormatUpdate Two ColumnsUpdate Without WHERE ClauseRemoving Data from a TableDeleting a RecordCheck What Records Will Be DeletedDelete All Records in a TableChapter 17: Updating or Deleting a TableWhy Update the Structure of a Table?The ALTER TABLE StatementExample: Adding a ColumnExample: Change a Data TypeExample: Add a Primary KeyExample: Add a Foreign KeyExample: Rename a ColumnExample: Remove a ColumnExample: Rename a TableRemoving a Table with DROP TABLEPart IV: Joining TablesChapter 18: Inner JoinMultiple TablesWhat is a Join?An Example of a JoinJoins,Formatting,and Table AliasesAn INNER JOINChapter 19: Outer JoinWhat is an Outer Join?Writing a Left Outer JoinShowing All Employees with a Left Outer JoinWriting a Right Outer JoinWhen Would You Use a Right Outer Join?Writing a Full Outer JoinUsing a Full Outer Join on Our TablesChapter 20: Other Join TypesThe USING KeywordUpdating the Office TableWriting a Query with the USING KeywordWhat is a Natural Join?Writing a Query with a Natural JoinWhat is a Cross Join?Using a CROSS JOINAlternative Join SyntaxInner JoinOuter JoinWhy You Shouldnât Use the Alternative Join SyntaxChapter 21: Joining Many TablesJoining Three TablesJoining Our Tables TogetherUsing Outer Join TypesMixing Join TypesJoining Four or More TablesPart V: FunctionsChapter 22: Using functions in SQLWhat is a Function?Where Can You Use Functions?Simple Numeric CalculationsThe DUAL TableNumber FunctionsConcatenation of StringsString FunctionsChanging CaseChecking for Matches on the Same CaseGetting Part of a StringCalculations on DatesDate FunctionsCurrent Date and TimeAdding MonthsChapter 23: Writing Conditional LogicThe CASE StatementSimple Case StatementSearched Case StatementThe DECODE FunctionCASE or DECODE?Chapter 24: Understanding Aggregate FunctionsAggregate FunctionsThe SUM FunctionA Simple SUM ExampleSUM with WHERESUM with ExpressionSUM with DISTINCTThe COUNT FunctionCounting All RecordsCount a Specific ColumnCount with DISTINCTCount with WHEREThe AVG FunctionAverage of All ValuesAverage with DISTINCTAverage with WHEREThe MIN FunctionMinimum of All RecordsMinimum with WHEREThe MAX FunctionMaximum of All RecordsMaximum with WHEREChapter 25: Grouping Your ResultsGrouping Your DataThe GROUP BY KeywordGROUP BY with a JoinGROUP BY and SUMGROUP BY with WHERERestricting Results After GroupingThe HAVING ClauseGROUP BY,HAVING,and SUMFinding Duplicate RecordsChapter 26: What Are Indexes?What Is an Index?How to Create an IndexExample of Creating an IndexWhy Is Performance Important?Web ApplicationOvernight Batch JobsReporting SystemIndex Using a JoinCreating an IndexThe Disadvantages of IndexesBest Practices for Creating IndexesPart VI: Command LineChapter 27: Using the Command LineWhat is SQL*Plus and Why Would You Use It?Itâs FastItâs Easy to Run ScriptsItâs Available on Every Oracle DatabaseYou Donât Always Have Access to SQL DeveloperHow to Start SQL*PlusAlternative Login SyntaxLogin with Two StepsLog in with One StepRunning a Query in SQL*PlusFormatting Output in SQL*PlusCopy and Paste into SQL*PlusThe Forward Slash CharacterExiting SQL*PlusWhat About SQLcl?How to Download and Run SQLclPart VII: AppendixesAppendix: How to Find and Navigate the Oracle SQL ReferenceFinding the Oracle SQL ReferenceThe Oracle SQL ReferenceFind What You Need Using Search