{"id":1580,"date":"2015-09-05T19:06:36","date_gmt":"2015-09-06T00:06:36","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1580"},"modified":"2015-09-05T19:06:36","modified_gmt":"2015-09-06T00:06:36","slug":"oca12c-1z0-061-additional-reading-03","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2015\/1580\/","title":{"rendered":"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 03"},"content":{"rendered":"<p><strong>[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.<\/strong><\/p>\n<p><strong>Chapter 3: Using Single-Row Functions<\/strong>\u00a0discusses the single-row functions and conversion functions available, with details on how and where to use them.<\/p>\n<ul>\n<li>4 Using Single-Row Functions to Customize Output\n<ul>\n<li>4.1 Describe various types of functions available in SQL<\/li>\n<li>4.2 Use character, number, and date functions in SELECT statements<\/li>\n<\/ul>\n<\/li>\n<li>5 Using Conversion Functions and Conditional Expressions\n<ul>\n<li>5.1 Describe various types of conversion functions that are available in SQL<\/li>\n<li>5.2 Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions<\/li>\n<li>5.3 Apply conditional expressions in a SELECT statement<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">Reading Material<\/span><\/p>\n<ul>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/functions002.htm#SQLRF51178\">Single-Row Functions<\/a><\/li>\n<li><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQLRF\/expressions.htm#SQLRF004\">Expressions<\/a><\/li>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/9i\/case-expressions-and-statements-9i\">CASE Expressions And Statements in Oracle<\/a><\/li>\n<li><a href=\"http:\/\/psoug.org\/reference\/convert_func.html\">Oracle conversion functions<\/a><\/li>\n<\/ul>\n<p style=\"text-align: center;\"><a href=\"https:\/\/bijoos.com\/oraclenotes\/certification-12c\/oracle-1z0-061\">1Z0-061\u00a0Objectives List<\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/bijoos.com\/oraclenotes\/certification-12c\">Oracle Database 12c OCA Certification<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 3: Using Single-Row Functions\u00a0discusses the single-row functions and conversion functions available, with details on how and where to use them. 4 Using Single-Row Functions to Customize Output 4.1 Describe various types of functions available in SQL 4.2 Use character, number, and date functions &#8230; <a title=\"OCA12c \u2013 1Z0-061 \u2013 Additional Reading 03\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2015\/1580\/\" aria-label=\"Read more about OCA12c \u2013 1Z0-061 \u2013 Additional Reading 03\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1580","post","type-post","status-publish","format-standard","hentry","category-certification-learning"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1580"}],"version-history":[{"count":0,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1580\/revisions"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}