{"id":"https://openalex.org/W33222063","doi":"https://doi.org/10.1007/978-1-4302-0702-3_10","title":"PL/SQL Debugging","display_name":"PL/SQL Debugging","alternate_titles":[],"publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W33222063","doi":"https://doi.org/10.1007/978-1-4302-0702-3_10","mag":"33222063"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-0702-3_10","doi":"https://doi.org/10.1007/978-1-4302-0702-3_10","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-0702-3_10","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress 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":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Mastering Oracle PL/SQL: Practical Solutions","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W2428407843","display_name":"Mastering Oracle PL/SQL: Practical Solutions","relationship":"volume"}],"lineage":["https://openalex.org/W33222063","https://openalex.org/W2428407843"],"child_works_count":0,"type":"book-chapter","is_traditional":true,"indexed_in":["crossref"],"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/A5024082032","display_name":"Connor McDonald","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Connor McDonald","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029111056","display_name":"Chaim Katz","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chaim Katz","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Christopher Beck","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Christopher Beck","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042222932","display_name":"Joel R. Kallman","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Joel R. Kallman","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5033229157","display_name":"David C. Knox","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"David C. Knox","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"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":"505","last_page":"558"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10743","display_name":"Software Testing and Debugging Techniques","score":0.92330002784729,"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"}},"topics":[{"id":"https://openalex.org/T10743","display_name":"Software Testing and Debugging Techniques","score":0.92330002784729,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.021700000390410423,"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.01720000058412552,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/pl-sql","display_name":"PL/SQL","score":0.9919999837875366},{"id":"https://openalex.org/keywords/debugging","display_name":"debugging","score":0.875},{"id":"https://openalex.org/keywords/oracle-database","display_name":"Oracle database","score":0.4480000138282776},{"id":"https://openalex.org/keywords/sql-programming","display_name":"SQL programming","score":0.38600000739097595},{"id":"https://openalex.org/keywords/error-handling","display_name":"error handling","score":0.4480000138282776}],"concepts":[{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.9376958608627319},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7533204555511475},{"id":"https://openalex.org/C2777179996","wikidata":"https://www.wikidata.org/wiki/Q911222","display_name":"Mistake","level":2,"score":0.7438561916351318},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6581647396087646},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.600964367389679},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.5084225535392761},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4209159314632416},{"id":"https://openalex.org/C2779304628","wikidata":"https://www.wikidata.org/wiki/Q3503480","display_name":"Face (sociological concept)","level":2,"score":0.4118337333202362},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3658216595649719},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.052077412605285645},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-0702-3_10","doi":"https://doi.org/10.1007/978-1-4302-0702-3_10","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-0702-3_10","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress 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":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Mastering Oracle PL/SQL: Practical Solutions","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W26846205","https://openalex.org/W4243720287","https://openalex.org/W117404650","https://openalex.org/W70006416","https://openalex.org/W2595069231","https://openalex.org/W4239955123","https://openalex.org/W2292746063","https://openalex.org/W52784400","https://openalex.org/W2493520803","https://openalex.org/W2484435754"],"abstract_inverted_index":{"Developers":[0],"know":[1,15],"that":[2],"code":[3],"debugging":[4,36],"can":[5],"be":[6,71],"a":[7,30],"large":[8],"part":[9],"of":[10],"their":[11],"job.":[12],"I":[13],"don\u2019t":[14],"any":[16],"developer":[17],"who":[18],"gets":[19],"it":[20],"right":[21],"the":[22,41,61,68,74],"first":[23],"time,":[24,26],"every":[25],"and":[27,38,58,67],"never":[28],"makes":[29],"mistake,":[31],"so":[32],"developers":[33,44],"must":[34],"employ":[35],"tips":[37],"techniques":[39],"along":[40],"way.":[42],"PL/SQL":[43],"are":[45],"no":[46],"different\u2014we":[47],"face":[48],"those":[49],"same":[50],"challenges.":[51],"These":[52],"keywords":[53,69],"were":[54],"added":[55],"by":[56,60],"machine":[57],"not":[59],"authors.":[62],"This":[63],"process":[64],"is":[65],"experimental":[66],"may":[70],"updated":[72],"as":[73],"learning":[75],"algorithm":[76],"improves.":[77]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W33222063","counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}
