initcap oracle

Initcap () Suppose C1 is a string. The function initcap () is to uppercase the first letter of each word, and other letters are converted to lowercase to return. A word is limited by spaces, control characters, punctuation marks, and other

Switch to Oracle's HR users to practice under 1. Check the name and salary of the employee whose salary is more than 12000 Select Initcap (concat (last_name,first_name)) "name" salary from employees where salary>12000; 2. Check the employee's

Like other programming languages, Oracle also has data types. Oracle has two main application scenarios: one is to specify the type of columns in a data table, and the other is to declare variables in PL/SQL programming. Oracle data types include

i) Oracle Overview (1) Understand some concepts about the databaseData: In the database field, data is the basic unit of storage, including text, pictures, video, audioDatabase: The Data Warehouse, the place where the data is stored, especially the

Oracle String FunctionsRecently changed the new company, and back to the Oracle database, a lot of things have forgotten, just have an impression, these two nights smoked a bit of time, the oracle of the string of some processing functions to do a

Oracle is still quite common, So I studied the Oracle Dual table and shared it with you here. I hope it will be useful to you. Character functions include conversion functions and character operation functions. Conversion functions include LOWER,

1, set linesize 100; Set length2, set pagesize 30; Set the number of displays per page3. Em A.sql Open Notepad4, @ A executes the code in file A, you can specify the path of the file @d:a.txt5, conn user name/password to connect to the database

Functions can be used to complete a series of operations. The difference between databases is that the support for functions is different. The learning function of this note. Functions are divided into single-row functions and multi-row functions.

---DQL: Data query statementsThe---Select statement must contain at least two words, namely the Select and from words.---the SELECT clause to specify the field to query.---the table that the FROM clause uses to customize the data source. The--select

Single-record functions in SQL1. ASCIIReturns the decimal number corresponding to the specified character;SQL> select ASCII ('A') A, ASCII ('A') A, ASCII ('0') zero, ASCII ('') space from dual;A A zero space------------------------------------65 97 4