{"id":"https://openalex.org/W207326370","doi":null,"title":"Oracle SQL by Example, Third Edition","display_name":"Oracle SQL by Example, Third Edition","publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W207326370","mag":"207326370"},"language":"en","primary_location":{"id":"mag:207326370","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=994948","pdf_url":null,"source":{"id":"https://openalex.org/S4306478100","display_name":"Prentice Hall PTR eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Prentice Hall PTR eBooks","raw_type":null},"volume":null,"type":"book","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5044630385","display_name":"Alice Rischert","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Alice Rischert","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5044630385"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9800000190734863,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9800000190734863,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.014800000004470348,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.001500000013038516,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/oracle-sql","display_name":"Oracle SQL","score":0.9990000128746033},{"id":"https://openalex.org/keywords/oracle-database-10g","display_name":"Oracle 10g","score":0.7979999780654907},{"id":"https://openalex.org/keywords/database-administration","display_name":"database administration","score":0.6449999809265137},{"id":"https://openalex.org/keywords/sql-plus","display_name":"SQL*Plus","score":0.6759999990463257},{"id":"https://openalex.org/keywords/join","display_name":"join","score":0.5199999809265137},{"id":"https://openalex.org/keywords/subqueries","display_name":"subqueries","score":0.9850000143051147},{"id":"https://openalex.org/keywords/hierarchical-queries","display_name":"hierarchical queries","score":0.7300000190734863},{"id":"https://openalex.org/keywords/regular-expressions","display_name":"regular expressions","score":0.8669999837875366},{"id":"https://openalex.org/keywords/database-performance","display_name":"database performance","score":0.3790000081062317},{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.781000018119812},{"id":"https://openalex.org/keywords/data-dictionary","display_name":"data dictionary","score":0.4819999933242798}],"concepts":[{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.8613111972808838},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.7904676198959351},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.759217381477356},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7232276201248169},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.7120702862739563},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.6198180913925171},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.5371995568275452},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5042215585708618},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4783420264720917},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.4496404230594635},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4393169581890106},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4203439950942993},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.4164336621761322},{"id":"https://openalex.org/C123327596","wikidata":"https://www.wikidata.org/wiki/Q212606","display_name":"Open Database Connectivity","level":5,"score":0.41138380765914917},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3002324104309082},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:207326370","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=994948","pdf_url":null,"source":{"id":"https://openalex.org/S4306478100","display_name":"Prentice Hall PTR eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Prentice Hall PTR eBooks","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W589814810","https://openalex.org/W2327539013","https://openalex.org/W2229313173","https://openalex.org/W2321393648","https://openalex.org/W2290904476","https://openalex.org/W2225125155","https://openalex.org/W4312142150","https://openalex.org/W640867714","https://openalex.org/W1915391702","https://openalex.org/W2249589203"],"abstract_inverted_index":{"The":[0,66],"book":[1,23,125],"...":[2,110],"has":[3],"enough":[4,14],"depth":[5],"for":[6,58,113,116,190,270],"even":[7],"a":[8,79],"seasoned":[9],"professional":[10,287],"to":[11,16,44,50,73,266],"pick":[12],"up":[13],"tips":[15],"pay":[17],"back":[18],"the":[19,22,69,74,135,140,150,171],"price":[20],"of":[21,68,97,156,178,188,228,243,297],"many":[24],"times":[25],"over.-Dr.":[26],"Paul":[27],"Dorsey,":[28],"President":[29],"Dulcian,":[30],"Inc.,":[31],"and":[32,64,81,93,119,183,198,203,208,223,236,247,262,268,276,281],"President,":[33],"New":[34],"York":[35],"Oracle":[36,40,62,107,114,129,180,195,211,286],"Users":[37],"Group.Students":[38],"find":[39],"SQL":[41,108,130,181],"by":[42],"Example":[43],"be":[45],"extremely":[46],"helpful":[47],"not":[48],"only":[49],"their":[51],"coursework":[52],"but":[53],"also":[54],"in":[55,121,165,206,213],"preparing":[56],"them":[57],"future":[59],"careers":[60],"as":[61],"DBAs":[63],"developers.":[65],"layout":[67],"text":[70],"is":[71],"conducive":[72],"learning":[75,118],"process.":[76],"It":[77],"introduces":[78],"concept":[80,85],"then":[82],"reinforces":[83],"that":[84,152],"with":[86,194],"an":[87,176,185,284],"exercise.-Betsy":[88],"Jenaway,":[89],"Coordinator,":[90],"Malcomb":[91],"Operations,":[92],"Senior":[94],"Lecturer":[95],"College":[96],"Management,":[98],"Lawrence":[99],"Technological":[100],"University,":[101],"Southfield,":[102],"MI.The":[103],"world's":[104],"#1":[105],"hands-on":[106,117],"workbook":[109],"fully":[111],"updated":[112],"10gCrafted":[115],"tested":[120],"classrooms":[122],"worldwide":[123],"this":[124],"illuminates":[126],"in-depth":[127],"every":[128,289],"technique":[131],"you'll":[132],"need.":[133],"From":[134],"simplest":[136],"query":[137],"fundamentals":[138],"through":[139],"newest":[141],"regular":[142,260],"expression":[143],"database":[144,290],"enhancements,":[145],"you":[146,173],"will":[147,160,174],"focus":[148],"on":[149],"tasks":[151],"matter":[153],"most.":[154],"Hundreds":[155],"guided":[157],"lab":[158],"exercises":[159],"systematically":[161],"strengthen":[162],"your":[163,191],"expertise":[164],"writing":[166],"effective,":[167],"high-performance":[168],"SQL.":[169,196],"Along":[170],"way,":[172],"acquire":[175],"arsenal":[177],"useful":[179],"knowledge":[182],"techniques:":[184],"extraordinary":[186],"library":[187],"solutions":[189,269,278],"real-world":[192],"challenges":[193],"Creating":[197],"using":[199],"tables,":[200],"views,":[201],"indexes,":[202],"sequences":[204],"Working":[205],"SQL*Plus":[207],"iSQL*Plus":[209],"environments":[210],"functions":[212,225],"depth-especially":[214],"number,":[215],"character,":[216],"date,":[217],"timestamp,":[218],"interval,":[219],"time":[220],"zone,":[221],"aggregate,":[222],"analytical":[224],"All":[226],"types":[227],"joins,":[229,233],"including":[230,245],"equijoins,":[231],"outer":[232],"self":[234],"joins":[235],"ANSI":[237],"join":[238],"syntax":[239],"options":[240],"Every":[241],"type":[242],"subquery,":[244],"correlated":[246],"scalar":[248],"subqueries,":[249],"set":[250],"operators,":[251],"hierarchical":[252],"queries,":[253,255],"flashback":[254],"data":[256],"dictionary,":[257],"object-relational":[258],"features,":[259],"expressions,":[261],"more":[263],"Common":[264],"pitfalls":[265],"avoid,":[267],"common":[271],"mistakes":[272],"Practical":[273],"performance,":[274],"security,":[275],"architectural":[277],"Insights,":[279],"tips,":[280],"tricks-of-the-trade":[282],"from":[283],"experienced":[285],"For":[288],"developer,":[291],"administrator,":[292],"designer":[293],"or":[294],"architect,":[295],"regardless":[296],"experience!":[298]},"counts_by_year":[],"updated_date":"2026-09-12T09:15:50.089291","created_date":"2016-06-24T00:00:00"}