General MySQL Oracle SQL Server

<< < 1 2 3 4 5 6 7 8 9 … > >>   Sort: Rank

Install Oracle Database 10g XE in Oracle
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts. It will guide you to finish the installation process. You should take notes about: The SYSTEM password you selected: fyicenter. Database server port: 1521. Da... 2020-05-05, 1869👍, 0💬

Verify 10g XE Server Installation in Oracle
How To Check Your Oracle Database 10g XE Installation in Oracle? If you want to check your fresh installation of 10g Express Edition without using any special client programs, you can use a Web browser with this address, http://localhost:8080/apex/. You will see the login page. Enter SYSTEM as the u... 2020-05-05, 1787👍, 0💬

Limitations of Oracle Database 10g XE in Oracle
What Are the Limitations of Oracle Database 10g XE in Oracle? Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Database XE on any server May be installed on a multiple CPU s... 2020-05-05, 1544👍, 0💬

Systems Supported by 10g XE Server in Oracle
What Operating Systems Are Supported by Oracle Database 10g XE in Oracle? Oracle Database 10g Express Edition is available for two types of operating Systems: Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu Microsoft Windows   ⇒ Download Oracle Database 10g XE in Oracle ⇐ Limitations of Or... 2020-05-05, 1428👍, 0💬

Differences between DATE and TIMESTAMP in Oracle
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and TIMESTAMP are: DATE stores values as century, year, month, date, hour, minute, and second. TIMESTAMP stores values as year, month, day, hour, minute, second, and fractional seconds.   ⇒ Differences b... 2020-04-25, 1968👍, 0💬

Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle
What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle? The main differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND are: INTERVAL YEAR TO MONTH stores values as time intervals at the month level. INTERVAL DAY TO SECOND stores values as time in... 2020-04-25, 1521👍, 0💬

Differences between CHAR and VARCHAR in Oracle
What Are the Differences between CHAR and VARCHAR2 in Oracle? The main differences between CHAR and VARCHAR2 are: CHAR stores values in fixed lengths. Values are padded with space characters to match the specified length. VARCHAR2 stores values in variable lengths. Values are not padded with any cha... 2020-04-25, 1454👍, 0💬

Differences between NUMBER and BINARY_FLOAT in Oracle
What Are the Differences between NUMBER and BINARY_FLOAT in Oracle? The main differences between NUMBER and BINARY_FLOAT are: NUMBER stores values as fixed-point numbers using 1 to 22 bytes. BINARY_FLOAT stores values as single precision floating-point numbers.   ⇒ Differences between DATE and TIMES... 2020-04-25, 1406👍, 0💬

Differences between CHAR and NCHAR in Oracle
What Are the Differences between CHAR and NCHAR in Oracle? Both CHAR and NCHAR are fixed length character data types. But they have the following differences: CHAR's size is specified in bytes by default. NCHAR's size is specified in characters by default. A character could be 1 byte to 4 bytes long... 2020-04-25, 1348👍, 0💬

Differences between BLOB and CLOB in Oracle
What Are the Differences between BLOB and CLOB in Oracle? The main differences between BLOB and CLOB are: BLOB stores values as LOB (Large OBject) in bitstreams. CLOB stores values as LOB (Large OBject) in character steams.   ⇒ ANSI Data Types in Oracle ⇐ Differences between INTERVAL YEAR TO MONTH ... 2020-04-14, 1784👍, 0💬

Numeric Literals in Oracle
How To Write Numeric Literals in Oracle? Numeric literals can coded as shown in the following samples: SELECT 255 FROM DUAL -- An integer 255 SELECT -6.34 FROM DUAL -- A regular number -6.34 SELECT 2.14F FROM DUAL -- A single-precision floating point 2.14 SELECT -0.5D FROM DUAL -- A double-precision... 2020-04-14, 1653👍, 0💬

Text Literals in Oracle
How To Write Text Literals in Oracle? There are several ways to write text literals as shown in the following samples: SELECT 'FYICenter.com' FROM DUAL -- The most common format FYICenter.com SELECT 'It''s Sunday!' FROM DUAL -- Single quote escaped It's Sunday! SELECT N'Allo, C''est moi.' FROM DUAL ... 2020-04-14, 1489👍, 0💬

Date and Time Literals in Oracle
How To Write Date and Time Literals in Oracle? Date and time literals can coded as shown in the following samples: SELECT DATE '2002-10-03' FROM DUAL -- ANSI date format 03-OCT-02 SELECT TIMESTAMP '1997-01-31 09:26:50.124' FROM DUAL 31-JAN-97 09.26.50.124000000 AM -- This is ANSI format   ⇒ Date and... 2020-04-14, 1410👍, 0💬

ANSI Data Types in Oracle
What Are the ANSI Data Types Supported in Oracle in Oracle? The following ANSI data types are supported in Oracle: CHARACTER(n) / CHAR(n) CHARACTER VARYING(n) / CHAR VARYING(n) NATIONAL CHARACTER(n) / NATIONAL CHAR(n) / NCHAR(n) NATIONAL CHARACTER VARYING(n) / NATIONAL CHAR VARYING(n) / NCHAR VARYIN... 2020-04-14, 1393👍, 0💬

Convert Character Strings to Numbers in Oracle
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the TO_NUMBER() function as shown in the following examples: SELECT TO_NUMBER('4123.4570') FROM DUAL 4123.457 SELECT TO_NUMBER(' $4,123.46','$9,999,999.99') FROM DUAL 4123.46 SELECT TO_NUMBER(' -4.12E+03')... 2020-03-25, 2454👍, 0💬

Convert Dates to Character Strings in Oracle
How To Convert Dates to Characters in Oracle? You can convert dates to characters using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') FROM DUAL; -- SYSDATE returns the current date 07-MAY-2006 SELECT TO_CHAR(SYSDATE, 'YYYY/MM/DD') FROM DUAL; 2006/0... 2020-03-25, 2115👍, 0💬

Date and Time Interval Literals in Oracle
How To Write Date and Time Interval Literals in Oracle? Date and time interval literals can coded as shown in the following samples: SELECT DATE '2002-10-03' + INTERVAL '123-2' YEAR(3) TO MONTH FROM DUAL -- 123 years and 2 months is added to 2002-10-03 03-DEC-25 SELECT DATE '2002-10-03' + INTERVAL '... 2020-03-25, 1550👍, 0💬

Convert Character Strings to Dates in Oracle
How To Convert Character Strings to Dates in Oracle? You can convert dates to characters using the TO_DATE() function as shown in the following examples: SELECT TO_DATE('07-MAY-2006', 'DD-MON-YYYY') FROM DUAL; 07-MAY-06 SELECT TO_DATE('2006/05/07 ', 'YYYY/MM/DD') FROM DUAL; 07-MAY-06 SELECT TO_DATE(... 2020-03-25, 1401👍, 0💬

Convert Numbers to Character Strings in Oracle
How To Convert Numbers to Character Strings in Oracle? You can convert numeric values to characters by using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(4123.4570) FROM DUAL 123.457 SELECT TO_CHAR(4123.457, '$9,999,999.99') FROM DUAL $4,123.46 SELECT TO_CHAR(-4123.457, ... 2020-03-25, 1270👍, 0💬

Increment Dates by 1 in Oracle
How To Increment Dates by 1 in Oracle? If you have a date, and you want to increment it by 1. You can do this by adding the date with a date interval. You can also do this by adding the number 1 directly on the date. The tutorial example below shows you how to adding numbers to dates, and take date ... 2020-03-15, 1498👍, 0💬

Use LIKE Conditions in Oracle
How To Use LIKE Conditions in Oracle? LIKE condition is also called pattern patch. There 3 main rules on using LIKE condition: '_' is used in the pattern to match any one character. '%' is used in the pattern to match any zero or more characters. ESCAPE clause is used to provide the escape character... 2020-03-15, 1485👍, 0💬

Use of Regular Expression in Oracle
How To Use Regular Expression in Pattern Match Conditions in Oracle? If you have a pattern that is too complex for LIKE to handle, you can use the regular expression pattern patch function: REGEXP_LIKE(). The following script provides you some good examples: SELECT CASE WHEN REGEXP_LIKE ('FYICenter.... 2020-03-15, 1386👍, 0💬

Use IN Conditions in Oracle
How To Use IN Conditions in Oracle? An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the script below: SELECT CASE WHEN 3 IN (1,2,3,5) THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE S... 2020-03-15, 1335👍, 0💬

Date and Time Differences in Oracle
How To Calculate Date and Time Differences in Oracle? If you want to know how many years, months, days and seconds are there between two dates or times, you can use the date and time interval expressions: YEAR ... TO MONTH and DAY ... TO SECOND. The tutorial exercise below gives you some good exampl... 2020-03-15, 1203👍, 0💬

<< < 1 2 3 4 5 6 7 8 9 … > >>   Sort: Rank

General MySQL Oracle SQL Server