ClearSQL for Oracle - PL/SQL analyzer, formatter and editor

Edit, format and analyze your Oracle PL/SQL code. Count metrics and enforce coding standards. ClearSQL for Oracle is a full-blown code analyzer and editor for legacy code maintenance. Analyze declarations, exceptions and the control flow. Remove anomalies. Fix and format your PL/SQL automatically. Flowchart legacy code to discover the logic, visualize the conditional branches, loops and jumps, in order to see the visual patterns of your code.

Key features

Analyze PL/SQL code
ClearSQL for Oracle performs declaration analysis, DML analysis, cursor analysis, control flow analysis, procedure analysis, exception analysis and module analysis and displays the results in a Structure View, facilitating quick navigation through your code.

Automated code review
Catch bugs early in the development cycle and avoid common mistakes. Produce code that is easy to read, understand and maintain. The nearly 60 code review rules detect the misuse of GOTO, parameter declaration problems, unreferenced parameters, missing or misplaced RETURN, unlabeled END, etc.

Auto fix known PL/SQL problems
ClearSQL for Oracle adds missing END and LOOP labels, defines IN parameters and re-parenthesizes complex operations.

Enforce coding standards
Improve readability and standardize code written by others. Enforce naming standards with regular expressions.

Format your code automatically
Set margins and indentation. Insert blank lines. Apply standard casing to keywords and identifiers. Tidy up procedure headers. Align SQL statements.

Flowchart PL/SQL code
ClearSQL for Oracle takes a package or a stand-alone subroutine and makes a set of flow chart diagrams that visualize the code execution path. Such diagrams show the conditional branches, loops and jumps, thereby helping to understand the opaque logic. The visual patterns help to find the points of possible code refactoring or module restructuring, and make the reasons for high values of Cyclomatic Complexity metrics obvious.

Metrics
Determine the complexity of your system. Identify potential problem areas based on complexity, size and modularity. Available metrics: lines of code (LOC), effective LOC, logical statements LOC, comment lines, blank lines, physical lines, McCabe cyclomatic complexity v(G), number of input parameters, number of return points, interface complexity, functional complexity, Halstead Program Length, Vocabulary, Volume, Difficulty and Effort, and Maintainability Index.

Code editor with syntax highlighting
The editor supports ANSI SQL, Oracle SQL, PL/SQL and Java and allows different versions of the same code. It provides power features such as bookmarks, comment out and uncomment a block of code, auto completion and code templates.

More features

• Auto Save keeps you from losing your work.
• Enhanced Find with regular expressions.
• Pre-processor directives let you generate different versions of the same code and include/exclude debug code.
• Save as CHM lets you export analysis results in a convenient HTML help file.
• Syntax Checker verifies your PL/SQL syntax without executing it on Oracle.
• Import from Database let's you connect to your Oracle database and import your files directly
• Bulk Import/Export allows you to handle large numbers of files in a single process

ClearSQL for Oracle is a code review and quality control tool for Oracle PL/SQL. With ClearSQL for Oracle's code review feature you get recommendations for better coding style and check for error-prone places in your project. ClearSQL for Oracle generates a series of industry standard quality control metrics about PL/SQL source code to help you to identify potential problems in the development and maintenance of your software and to fine-tune your software development process.

ClearSQL for Oracle flowcharts PL/SQL code of packages on per-subroutine basis, stand-alone subroutines or anonymous blocks of code. ORACLE 10g2's pre-processor directives are supported.

Key features

Coding standards enforcement

Automated code review

• Catch more bugs earlier in the development and testing cycle
• Avoid common mistakes
• Help junior developers learn from their more experienced peers
• Produce code that is easier to read, understand and maintain
• Automatically fix 9 of the analyzer's rules, accelerating code development

Metrics

• Determine and report the complexity of the system
• Generate a set of quality control code metrics to identify potential problem areas based on complexity, size and modularity
• Keep your software reliable, testable and manageable

Preprocessor

• Include debug code in your PL/SQL code and exclude it from the production
• Write code that is portable across multiple Oracle Server versions
• Maintain a module that can be used by different clients
• User defined and substitution variables create command files that allow end-user input

Instrumented Code Insertion

• Locate bugs quickly

Powerful and Intuitive Graphical User Interface

• Compact program loads quickly so your code is always at your fingertips
• Easy to use Explorer-like interface
• Hierarchical tree view for organizing scripts
• Editor with syntax highlighting for ANSI SQL, Oracle SQL&PL/SQL and Java
• Multiple versions of a script.
• User-customized SQL code templates
• Drag-and-drop function throughout the system
• Easily search your code for keywords through the tree or through separate script
• Regular expressions for describing string matching patterns
• Export code fragments as text files, that can be executed later using any client/server program that reads text files
• Import code fragments as text files or using the drag-and-drop function
• Right-click menus throughout the program
• Advanced clipboard functions easily accessed with tool buttons
• Toolbar access to the most commonly used commands
• Tools to convert text into Comments and vice versa
• Auto Save option: saving work is guaranteed

고액결제의 경우 안전을 위해 카드사에서 확인전화를 드릴 수도 있습니다. 확인과정에서 도난 카드의 사용이나 타인 명의의 주문등 정상적인 주문이 아니라고 판단될 경우 임의로 주문을 보류 또는 취소할 수 있습니다.  

무통장 입금은 상품 구매 대금은 PC뱅킹, 인터넷뱅킹, 텔레뱅킹 혹은 가까운 은행에서 직접 입금하시면 됩니다.  
주문시 입력한 입금자명과 실제입금자의 성명이 반드시 일치하여야 하며, 7일 이내로 입금을 하셔야 하며 입금되지 않은 주문은 자동취소 됩니다.

• 배송 방법 : 택배
• 배송 지역 : 전국지역
• 배송 비용 : 무료
• 배송 기간 : 3일 ~ 7일
• 배송 안내 : - 산간벽지나 도서지방은 별도의 추가금액을 지불하셔야 하는 경우가 있습니다.
  고객님께서 주문하신 상품은 입금 확인후 배송해 드립니다. 다만, 상품종류에 따라서 상품의 배송이 다소 지연될 수 있습니다.
  

교환 및 반품이 가능한 경우
- 상품을 공급 받으신 날로부터 7일이내 단, 가전제품의
  경우 포장을 개봉하였거나 포장이 훼손되어 상품가치가 상실된 경우에는 교환/반품이 불가능합니다.
- 공급받으신 상품 및 용역의 내용이 표시.광고 내용과
  다르거나 다르게 이행된 경우에는 공급받은 날로부터 3월이내, 그사실을 알게 된 날로부터 30일이내

교환 및 반품이 불가능한 경우
- ESD(Electronic Software Distribution), 이메일로 설치key, 설치파일 또는 사용증서로 납품되는 제품의 경우는 제품 자체에 심각한 문제가 있는 경우를 제외하고는

  반품이 불가 합니다.

- 고객님의 책임 있는 사유로 상품등이 멸실 또는 훼손된 경우. 단, 상품의 내용을 확인하기 위하여
  포장 등을 훼손한 경우는 제외
- 포장을 개봉하였거나 포장이 훼손되어 상품가치가 상실된 경우
  (예 : 가전제품, 식품, 음반 등, 단 액정화면이 부착된 노트북, LCD모니터, 디지털 카메라 등의 불량화소에
  따른 반품/교환은 제조사 기준에 따릅니다.)
- 고객님의 사용 또는 일부 소비에 의하여 상품의 가치가 현저히 감소한 경우 단, 화장품등의 경우 시용제품을
  제공한 경우에 한 합니다.
- 시간의 경과에 의하여 재판매가 곤란할 정도로 상품등의 가치가 현저히 감소한 경우
- 복제가 가능한 상품등의 포장을 훼손한 경우
  (자세한 내용은 고객만족센터 Q&A게시판 또는 E-MAIL상담을 이용해 주시기 바랍니다.)

※ 고객님의 마음이 바뀌어 교환, 반품을 하실 경우 상품반송 비용은 고객님께서 부담하셔야 합니다.
  (색상 교환, 사이즈 교환 등 포함)

_

상품의 사용후기를 적어주세요.

게시물이 없습니다

상품에 대해 궁금한 점을 해결해 드립니다.

게시물이 없습니다