Search results
1 cze 2021 · USEFUL FUNCTIONS. Get the count of characters in a string: SELECT LENGTH('LearnSQL.com'); -- result: 12. Convert all letters to lowercase: SELECT LOWER('LEARNSQL.COM'); -- result: learnsql.com. Convert all letters to uppercase: SELECT UPPER('LearnSQL.com'); -- result: LEARNSQL.COM.
Learning SQL eBook (PDF) Download this eBook for free. Chapters. Chapter 1: Getting started with SQL. Chapter 2: ALTER TABLE. Chapter 3: AND & OR Operators. Chapter 4: Cascading Delete. Chapter 5: CASE. Chapter 6: Clean Code in SQL.
PdfGen - An Oracle PL/SQL PDF Generator. Create an attractive report from a SQL query with capabilities similar to those available in sqlplus report generator, but with control over fonts, margins, page size, and orientation. (See samples directory for PDF files it produced.)
USEFUL FUNCTIONS. Get the count of characters in a string: SELECT LENGTH('LearnSQL.com'); -- result: 12. Convert all letters to lowercase: SELECT LOWER('LEARNSQL.COM'); -- result: learnsql.com. Convert all letters to uppercase: SELECT UPPER('LearnSQL.com'); -- result: LEARNSQL.COM.
This document summarizes built-in SQL functions in Oracle. It covers character functions that return character and numeric values, numeric functions, date functions, conversion functions, group functions, and other miscellaneous functions. Examples are provided for many of the functions to demonstrate their usage.
Fast and Easy Conversion. Upload your SQL files, set table style if needed, choose the save format type and click on "Convert" button. You will get the download link as soon as the file is converted.
Download this eBook for free Chapters. Chapter 1: Getting started with Microsoft SQL Server; Chapter 2: Advanced options; Chapter 3: Aggregate Functions; Chapter 4: Alias Names in Sql Server; Chapter 5: Analyzing a Query; Chapter 6: Backup and Restore Database; Chapter 7: Basic DDL Operations in MS SQL Server
