{"id":14485,"date":"2018-08-29T04:11:51","date_gmt":"2018-08-29T04:11:51","guid":{"rendered":"http:\/\/demo.thimpress.com\/eduma\/?p=60"},"modified":"2023-03-04T20:45:03","modified_gmt":"2023-03-04T20:45:03","slug":"sql-developer-command-line-sqlcl-18-2","status":"publish","type":"post","link":"https:\/\/kiusi.com\/en\/sql-developer-command-line-sqlcl-18-2\/","title":{"rendered":"SQL Developer Command Line SQLcl 18.2"},"content":{"rendered":"<p>A mi particularmente me gusta mucho trabajar con SQL*Plus, pero ahora me encuentro con esta nueva herramienta el Oracle SQL Developer Command Line (SQLcl) el cual es una interfaz de l\u00ednea de comandos gratuita para Oracle Database.<\/p>\n<p>Nos permite ejecutar de forma interactiva o por lotes SQL y PL\/SQL. SQLcl proporciona edici\u00f3n en l\u00ednea, finalizaci\u00f3n de instrucci\u00f3n y recuperaci\u00f3n de comandos para una experiencia rica en caracter\u00edsticas, a la vez que admite sus secuencias de comandos SQL*Plus escritas previamente.<\/p>\n<p><span id=\"result_box\" class=\"\" lang=\"es\"><b>Caracter\u00edsticas principales<\/b><\/span><span id=\"result_box\" class=\"\" lang=\"es\">&nbsp;<\/span><\/p>\n<ul>\n<li><span id=\"result_box\" class=\"\" lang=\"es\"><b>Editor en l\u00ednea<\/b>: edite secuencias de comandos y sentencias de varias l\u00edneas de forma interactiva en el indicador SQLcl<\/span><span id=\"result_box\" class=\"\" lang=\"es\">&nbsp;<\/span><\/li>\n<li><span id=\"result_box\" class=\"\" lang=\"es\"><b>Historial de comandos<\/b>: recorre tus 100 scripts\/comandos anteriores<\/span><span id=\"result_box\" class=\"\" lang=\"es\">&nbsp;<\/span><\/li>\n<li><span id=\"result_box\" class=\"\" lang=\"es\"><b>Completion Insight<\/b>: autocompletar nombres de objetos o palabras clave con la tecla tab<\/span><\/li>\n<li><span id=\"result_box\" class=\"\" lang=\"es\"><b>Nuevos comandos<\/b>: CTAS, DLL, Repeat, ALIAS, SCRIPT, FORMAT y muchos m\u00e1s.<\/span><\/li>\n<li><span id=\"result_box\" class=\"\" lang=\"es\"><b>Secuencias de comandos del lado del cliente<\/b>: ejecute javascript para manipular los resultados de las consultas, crear comandos din\u00e1micos, interactuar con la sesi\u00f3n y mucho m\u00e1s.<\/span><\/li>\n<li><span id=\"result_box\" class=\"\" lang=\"es\"><b>Compatibilidad con SQL*Plus<\/b>: configuraci\u00f3n del entorno SQL * Plus, comandos y comportamientos<\/span><\/li>\n<\/ul>\n<p><span id=\"result_box\" class=\"\" lang=\"es\">Aqu\u00ed puedes descargarla para probarla:<\/span><br \/>\n<span id=\"result_box\" class=\"\" lang=\"es\"><br \/>\n<\/span><a href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/sqlcl\/overview\/index.html\"><span id=\"result_box\" class=\"\" lang=\"es\">http:\/\/www.oracle.com\/technetwork\/developer-tools\/sqlcl\/overview\/index.html<\/span><\/a><br \/>\n<span id=\"result_box\" class=\"\" lang=\"es\"><br \/>\n<\/span><span id=\"result_box\" class=\"\" lang=\"es\">Para aprender m\u00e1s sobre este herramienta mira este video:<\/span><\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/b-iHX2EA77w\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>","protected":false},"excerpt":{"rendered":"<p>A mi particularmente me gusta mucho trabajar con SQL*Plus, pero ahora me encuentro con esta nueva herramienta el Oracle SQL Developer Command Line (SQLcl) el cual es una interfaz de l\u00ednea de comandos gratuita para Oracle Database. Nos permite ejecutar de forma interactiva o por lotes SQL y PL\/SQL. SQLcl proporciona edici\u00f3n en l\u00ednea, finalizaci\u00f3n [\u2026]<\/p>\n","protected":false},"author":132749711,"featured_media":16655,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_crdt_document":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":true,"_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":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false},"categories":[121913,121891],"tags":[121886,121968,121969],"class_list":["post-14485","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-sql-developer","tag-oracle","tag-sql","tag-sqlcl","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/kiusi.com\/wp-content\/uploads\/2018\/08\/01-SQL-Developer-Command-Line-SQLcl-18.2.jpg?fit=2952%2C1737&ssl=1","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paMvMS-3LD","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/14485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/users\/132749711"}],"replies":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/comments?post=14485"}],"version-history":[{"count":2,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/14485\/revisions"}],"predecessor-version":[{"id":16560,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/posts\/14485\/revisions\/16560"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media\/16655"}],"wp:attachment":[{"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/media?parent=14485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/categories?post=14485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiusi.com\/en\/wp-json\/wp\/v2\/tags?post=14485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}