{"id":"https://openalex.org/W603024429","doi":null,"title":"Oracle Database 12c PL/SQL Advanced Programming Techniques","display_name":"Oracle Database 12c PL/SQL Advanced Programming Techniques","alternate_titles":[],"publication_year":2014,"publication_date":"2014-11-10","ids":{"openalex":"https://openalex.org/W603024429","mag":"603024429"},"language":"en","primary_location":{"id":"pmh:oai:cds.cern.ch:2658848","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/2658848","pdf_url":null,"source":{"id":"https://openalex.org/S4306400735","display_name":"International Linear Collider","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":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W603024429"],"child_works_count":0,"type":"article","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/A5067502616","display_name":"Mike John McLaughlin","orcid":"https://orcid.org/0000-0001-6796-4144","observed_orcids":["https://orcid.org/0000-0001-6796-4144"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Mike J. McLaughlin","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0001-6796-4144","affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5081928479","display_name":"John Harper","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"John Harper","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":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9746000170707703,"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.9746000170707703,"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.022299999371170998,"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/T11106","display_name":"Data Management and Algorithms","score":0.0003000000142492354,"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/pl-sql","display_name":"PL/SQL","score":0.9610000252723694},{"id":"https://openalex.org/keywords/oracle-database-12c","display_name":"Oracle Database 12c","score":1.0},{"id":"https://openalex.org/keywords/software-security","display_name":"software security","score":0.7789999842643738},{"id":"https://openalex.org/keywords/performance-tuning","display_name":"performance tuning","score":0.9049999713897705},{"id":"https://openalex.org/keywords/column-stores","display_name":"column stores","score":0.7649999856948853}],"concepts":[{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.9090238213539124},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8554552793502808},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.7699648141860962},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6772912740707397},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.6628007292747498},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.6336805820465088},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6176801919937134},{"id":"https://openalex.org/C22664368","wikidata":"https://www.wikidata.org/wiki/Q4045949","display_name":"Oracle Unified Method","level":5,"score":0.5546973347663879},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4987974166870117},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.48866894841194153},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.45760464668273926},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.42407259345054626},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.38366973400115967},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3627227246761322},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.21515953540802002},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:cds.cern.ch:2658848","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/2658848","pdf_url":null,"source":{"id":"https://openalex.org/S4306400735","display_name":"International Linear Collider","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":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"mag:603024429","doi":null,"is_oa":false,"landing_page_url":"http://ci.nii.ac.jp/ncid/BB17807792","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"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/W2756130066","https://openalex.org/W6998517322","https://openalex.org/W120427419","https://openalex.org/W7023319239","https://openalex.org/W1582420261","https://openalex.org/W1483181473","https://openalex.org/W1559662946","https://openalex.org/W18097234","https://openalex.org/W2253717087"],"abstract_inverted_index":{"Take":[0],"Your":[1],"PL/SQL":[2,12,20,96,123],"Programming":[3,22],"Skills":[4],"to":[5,27,80],"the":[6,38,77,119,135],"Next":[7],"Level":[8],"Build":[9],"robust":[10],"database-centric":[11],"applications":[13,112],"quickly":[14],"and":[15,29,40,43,47,54,68,83,87,92,98,109,116,130],"effectively.":[16],"Oracle":[17,34,55,63,73,136],"Database":[18,35,56,137],"12c":[19],"Advanced":[21],"Techniques":[23],"shows":[24],"you":[25],"how":[26],"write":[28],"deploy":[30,88,131],"Java":[31,70,89],"libraries":[32,71,91],"inside":[33],"12c,":[36],"use":[37,99,125],"utl_file":[39,78],"DBMS_SCHEDULER":[41,120],"packages,":[42],"create":[44],"external":[45,48,100,132],"tables":[46,101],"procedures.":[49],"Application":[50],"security,":[51],"performance":[52,127],"tuning,":[53],"In-Memory":[57,138],"are":[58],"also":[59],"covered":[60],"in":[61,126],"this":[62],"Press":[64],"guide.":[65],"Configure,":[66],"deploy,":[67],"troubleshoot":[69],"for":[72,124],"object":[74],"types":[75],"Use":[76],"package":[79,121],"manage":[81],"unstructured":[82],"structured":[84],"data":[85,104],"Develop":[86],"I/O":[90],"wrap":[93],"them":[94],"with":[95,118],"Create":[97,129],"Implement":[102,134],"high-speed":[103],"transfer":[105],"Harden":[106],"database":[107],"systems":[108],"develop":[110],"secure":[111],"Manage":[113],"complex":[114],"schedules":[115],"jobs":[117],"Optimize":[122],"tuning":[128],"procedures":[133],"column":[139],"store":[140],"feature":[141]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W603024429","counts_by_year":[],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2016-06-24T00:00:00"}
