{"id":167,"date":"2022-02-01T09:40:20","date_gmt":"2022-02-01T09:40:20","guid":{"rendered":"https:\/\/vkrastev1blog.com\/?p=167"},"modified":"2026-10-19T12:28:46","modified_gmt":"2026-10-19T12:28:46","slug":"sql-developer-execute-big-sql-files-scripts-in-sql-developer","status":"publish","type":"post","link":"https:\/\/vkrastev1blog.com\/2022\/02\/01\/sql-developer-execute-big-sql-files-scripts-in-sql-developer\/","title":{"rendered":"\u064a\u0642\u0648\u0645 SQL Developer &#8211; \u0628\u062a\u0646\u0641\u064a\u0630 \u0645\u0644\u0641\u0627\u062a\/\u0628\u0631\u0627\u0645\u062c \u0646\u0635\u064a\u0629 \u0643\u0628\u064a\u0631\u0629 \u0628\u062a\u0646\u0633\u064a\u0642 SQL \u0641\u064a SQL Developer"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u0645\u0637\u0648\u0631 SQL &#8211; \u062a\u0646\u0641\u064a\u0630 \u0645\u0644\u0641\u0627\u062a\/\u0628\u0631\u0627\u0645\u062c \u0646\u0635\u064a\u0629 \u0643\u0628\u064a\u0631\u0629 \u0628\u062a\u0646\u0633\u064a\u0642 SQL \u0641\u064a \u0645\u0637\u0648\u0631 SQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0627\u0641\u062a\u062d SQL Developer \u062b\u0645 \u0627\u0636\u063a\u0637 \u0639\u0644\u0649 Alt &#8211; F10 \u0648\u0633\u064a\u0638\u0647\u0631 \u0644\u0643 \u0645\u0631\u0628\u0639 \u062d\u0648\u0627\u0631 \u0627\u062e\u062a\u064a\u0627\u0631 \u0627\u062a\u0635\u0627\u0644. \u0627\u062e\u062a\u0631 \u0627\u062a\u0635\u0627\u0644\u0627\u064b \u0648\u0633\u064a\u0641\u062a\u062d \u0645\u062d\u0631\u0631 SQL \u0644\u0647\u0630\u0627 \u0627\u0644\u0627\u062a\u0635\u0627\u0644. \u0627\u0643\u062a\u0628 \u0641\u064a\u0647\u0627 \u0641\u0642\u0637 <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">@C:\\Users\\KrastevV\\Project\\sql.sql<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0642\u0645 \u0628\u062a\u0633\u062c\u064a\u0644 @ \u0645\u062a\u0628\u0648\u0639\u064b\u0627 \u0628\u0627\u0644\u0645\u0633\u0627\u0631 \u0625\u0644\u0649 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0646\u0635\u064a \u0648\u0642\u0645 \u0628\u062a\u0646\u0641\u064a\u0630\u0647 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0632\u0631 \u0627\u0644\u062a\u0634\u063a\u064a\u0644.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"451\" data-attachment-id=\"171\" data-permalink=\"https:\/\/vkrastev1blog.com\/2022\/02\/01\/sql-developer-execute-big-sql-files-scripts-in-sql-developer\/bild\/\" data-orig-file=\"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?fit=751%2C451&amp;ssl=1\" data-orig-size=\"751,451\" data-comments-opened=\"1\" data-image-title=\"bild\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?fit=751%2C451&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=751%2C451&#038;ssl=1\" alt=\"\" class=\"wp-image-171\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0645\u062d\u0631\u0643 SQL &#8211; \u064a\u0646\u0641\u0630 \u0627\u0644\u0645\u0644\u0641\u0627\u062a\/\u0627\u0644\u0628\u0631\u0627\u0645\u062c \u0630\u0627\u062a \u0627\u0644\u0646\u0635 \u0627\u0644\u0643\u0628\u064a\u0631 \u0628\u062a\u0646\u0633\u064a\u0642 SQL \u0641\u064a \u0645\u062d\u0631\u0643 SQL \u0633\u062c\u0644 SQL Developer \u062b\u0645 \u0627\u0646\u0642\u0631 \u0641\u0648\u0642 Alt &#8211; F10 \u062b\u0645 \u0648\u0633\u06cc\u0632\u0647\u0631 \u0644\u06a9 \u06a9\u0648\u0631\u06af \u062f\u0648\u0631\u06af\u0648 \u062d\u062f\u062f \u0627\u0644\u0627\u062a\u0635\u0627\u0644. \u0627\u062e\u062a\u0631 \u0627\u06cc\u0633\u062a\u0627\u0633\u0627\u064b \u0648\u0633\u06cc\u0641\u062a\u0647 \u0645\u062d\u0631\u0631 SQL \u0644\u0647\u0630\u0627 \u0627\u0644\u0627\u062a\u0635\u0627\u0644. \u0627\u0643\u062a\u0628 \u0641\u064a\u0647\u0627 \u0642\u0637\u0639 @C:\\Users\\KrastevV\\Project\\sql.sql \u0641\u0639\u0644 @ \u0645\u062a\u0628\u0648\u0639\u064b\u0627 \u0628\u0627\u0644\u0645\u0633\u0627\u0631 \u0625\u0644\u0649 \u0641\u0631\u0637 \u0627\u0644\u0646\u0633\u064a \u0648\u0642\u0645 \u0628\u0647 \u0648\u0642\u0645\u0647 \u0628\u062a\u0646\u0641\u064a\u062b\u0647 \u0648\u0628\u062a\u0646\u0641\u064a\u0632\u0647 \u0625\u0644\u0649 \u0632\u0631 \u062a\u0639\u0644\u064a\u0642\u0629.<\/p>\n","protected":false},"author":65283547,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[559],"tags":[729296054],"class_list":["post-167","post","type-post","status-publish","format-standard","hentry","category-others","tag-slq-developer"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4CoHV-2H","jetpack-related-posts":[{"id":237,"url":"https:\/\/vkrastev1blog.com\/2023\/09\/12\/mssql-configure-server-for-sql-authentication-mssql-login-with-username-and-password\/","url_meta":{"origin":167,"position":0},"title":"\u064a\u0642\u0648\u0645 MSSQL \u0628\u062a\u0643\u0648\u064a\u0646 \u0627\u0644\u062e\u0627\u062f\u0645 \u0644\u0645\u0635\u0627\u062f\u0642\u0629 SQL. \u062a\u0633\u062c\u064a\u0644 \u0627\u0644\u062f\u062e\u0648\u0644 \u0625\u0644\u0649 MSSQL \u0628\u0627\u0633\u0645 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0648\u0643\u0644\u0645\u0629 \u0627\u0644\u0645\u0631\u0648\u0631","author":"vkrastev2014","date":"12.09.2023","format":false,"excerpt":"In SQL Server Management Studio (SSMS) Object Explorer, right-click the server, and then select Properties. On the Security page, under Server authentication, select 'SQL and Windows authentication mode', and then select OK. You have to restart the server. You can try to access the Database from command line with: sqlcmd\u2026","rel":"","context":"In &quot;\u0622\u062d\u0631\u0648\u0646&quot;","block_context":{"text":"\u0622\u062d\u0631\u0648\u0646","link":"https:\/\/vkrastev1blog.com\/category\/others\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":174,"url":"https:\/\/vkrastev1blog.com\/2022\/02\/08\/create-dump-from-oracle-schema-in-console-in-linux\/","url_meta":{"origin":167,"position":1},"title":"\u0642\u0645 \u0628\u0625\u0646\u0634\u0627\u0621 \u062a\u0641\u0631\u064a\u063a \u0645\u0646 \u0645\u062e\u0637\u0637 Oracle \u0641\u064a \u0648\u062d\u062f\u0629 \u0627\u0644\u062a\u062d\u0643\u0645 \u0641\u064a Linux","author":"vkrastev2014","date":"08.02.2022","format":false,"excerpt":"It is not easy to find the correct way to execute expdp command in console. There are some steps before you execute expdp command. First you have to create a directory on the computer where Oracle DB is, where you will put the dump files than you have to grant\u2026","rel":"","context":"In &quot;\u0622\u062d\u0631\u0648\u0646&quot;","block_context":{"text":"\u0622\u062d\u0631\u0648\u0646","link":"https:\/\/vkrastev1blog.com\/category\/others\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":55,"url":"https:\/\/vkrastev1blog.com\/2014\/05\/11\/important-shell-script-commands-which-are-oft-used\/","url_meta":{"origin":167,"position":2},"title":"\u0623\u0648\u0627\u0645\u0631 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0646\u0635\u064a \u0627\u0644\u0647\u0627\u0645\u0629 \u0644\u0640 Shell \u0648\u0627\u0644\u062a\u064a \u064a\u062a\u0645 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\u0627 \u063a\u0627\u0644\u0628\u064b\u0627","author":"vkrastev2014","date":"11.05.2014","format":false,"excerpt":"Here is a list of some important shell commands: ---- Using Screen command screen -ls -- for a list of avaliable active screens screen -x .... - the Name from -ls output to join to this active screen Go out of the Screen with 'ctrl a+d' without stopping it ----\u2026","rel":"","context":"In &quot;\u0622\u062d\u0631\u0648\u0646&quot;","block_context":{"text":"\u0622\u062d\u0631\u0648\u0646","link":"https:\/\/vkrastev1blog.com\/category\/others\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2308,"url":"https:\/\/vkrastev1blog.com\/2026\/05\/29\/questions-and-informations-prepairing-for-java-developer-job-interview\/","url_meta":{"origin":167,"position":3},"title":"\u0623\u0633\u0626\u0644\u0629 \u0648\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0644\u0644\u062a\u062d\u0636\u064a\u0631 \u0644\u0644\u0645\u0642\u0627\u0628\u0644\u0629 \u0627\u0644\u0648\u0638\u064a\u0641\u064a\u0629 \u0644\u0645\u0637\u0648\u0631 Java","author":"vkrastev2014","date":"29.05.2026","format":false,"excerpt":"\u0412\u044a\u043f\u0440\u043e\u0441\u0438 \u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f \u0437\u0430 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0430 \u0437\u0430 \u0438\u043d\u0442\u0435\u0440\u0432\u044e \u0437\u0430 \u0440\u0430\u0431\u043e\u0442\u0430 \u043a\u0430\u0442\u043e Java Developer \u041a\u0430\u043a\u0432\u043e \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0432\u0430\u0442 SOLID \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0438\u0442\u0435? \u041a\u0430\u043a\u0432\u043e \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0432\u0430 Single Responsibility Principle (SRP) \u0415\u0434\u0438\u043d \u043a\u043b\u0430\u0441 \u0442\u0440\u044f\u0431\u0432\u0430 \u0434\u0430 \u0438\u043c\u0430 \u0441\u0430\u043c\u043e \u0435\u0434\u043d\u0430 \u043e\u0442\u0433\u043e\u0432\u043e\u0440\u043d\u043e\u0441\u0442 \u0438 \u0441\u0430\u043c\u043e \u0435\u0434\u043d\u0430 \u043f\u0440\u0438\u0447\u0438\u043d\u0430 \u0434\u0430 \u0431\u044a\u0434\u0435 \u043f\u0440\u043e\u043c\u0435\u043d\u044f\u043d.\u041f\u043e\u043b\u0437\u0438\u0442\u0435 \u0432\u043a\u043b\u044e\u0447\u0432\u0430\u0442 \u043f\u043e-\u043b\u0435\u0441\u043d\u043e \u0442\u0435\u0441\u0442\u0432\u0430\u043d\u0435, \u043f\u043e-\u043d\u0438\u0441\u043a\u043e n\u0438\u0432\u043e \u043d\u0430 coupling \u0438 \u043f\u043e-\u0434\u043e\u0431\u0440\u0430 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u044f.\u041f\u0440\u0438\u043c\u0435\u0440: public class Book\u2026","rel":"","context":"In &quot;\u062c\u0627\u0641\u0627&quot;","block_context":{"text":"\u062c\u0627\u0641\u0627","link":"https:\/\/vkrastev1blog.com\/category\/java\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2026\/05\/image-9.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2026\/05\/image-9.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2026\/05\/image-9.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2026\/05\/image-9.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":232,"url":"https:\/\/vkrastev1blog.com\/2022\/10\/31\/install-solr-8-under-windows-as-service\/","url_meta":{"origin":167,"position":4},"title":"\u0642\u0645 \u0628\u062a\u062b\u0628\u064a\u062a Solr 8 \u0636\u0645\u0646 Windows \u0643\u062e\u062f\u0645\u0629","author":"vkrastev2014","date":"31.10.2022","format":false,"excerpt":"Here is short explained how to install Solr 8 as Windows service Download nssm from https:\/\/nssm.cc\/release\/nssm-2.24.zip and extract it to C:\\Program Files\\nssm Donwload Solr 8 from https:\/\/dlcdn.apache.org\/lucene\/solr\/8.11.2\/solr-8.11.2.zip and extract it to C:\\web\\solr Java Version 8 or later have to be istalled and JAVA_HOME environment variable set Create Windows Service solr8.\u2026","rel":"","context":"In &quot;\u0622\u062d\u0631\u0648\u0646&quot;","block_context":{"text":"\u0622\u062d\u0631\u0648\u0646","link":"https:\/\/vkrastev1blog.com\/category\/others\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":194,"url":"https:\/\/vkrastev1blog.com\/2022\/03\/30\/java-configure-log4j2-in-your-project\/","url_meta":{"origin":167,"position":5},"title":"\u0642\u0645 \u0628\u062a\u0643\u0648\u064a\u0646 Java Log4j2 \u0641\u064a \u0645\u0634\u0631\u0648\u0639\u0643","author":"vkrastev2014","date":"30.03.2022","format":false,"excerpt":"Log4j2 and SLF4j Binding DependenciesTo make Log4j2 work with SLF4J, we need to include the following 3 dependencies. log4j-slf4j-impl.jar \u2013 Log4j 2 SLF4J binding. It allows applications coded to the SLF4J API to use Log4j2 as the implementation.log4j-api.jar \u2013 provides the adapter components required for implementers to create a logging\u2026","rel":"","context":"In &quot;\u062c\u0627\u0641\u0627&quot;","block_context":{"text":"\u062c\u0627\u0641\u0627","link":"https:\/\/vkrastev1blog.com\/category\/java\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/users\/65283547"}],"replies":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/comments?post=167"}],"version-history":[{"count":6,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/167\/revisions"}],"predecessor-version":[{"id":2827,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/167\/revisions\/2827"}],"wp:attachment":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/media?parent=167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/categories?post=167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/tags?post=167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}