General MySQL Oracle SQL Server

<< < … 7 8 9 10 11 12 13 14 15 16 17 … > >>   ∑:1349  Sort:Rank

Oracle Built-in Data Types in Oracle
What Are the Oracle Built-in Data Types in Oracle? There are 20 Oracle built-in data types, divided into 6 groups: Character Datatypes - CHAR, NCHAR, NVARCHAR2, VARCHAR2 Number Datatypes - NUMBER, BINARY_FLOAT, BINARY_DOUBLE Long and Row Datatypes - LONG, LONG RAW, RAW Datetime Datatypes - DATE, TIM... 2020-05-29, 2612🔥, 0💬

Categories of Data Types in Oracle
How Many Categories of Data Types in Oracle? Oracles supports the following categories of data types: Oracle Built-in Datatypes. ANSI, DB2, and SQL/DS Datatypes. User-Defined Types. Oracle-Supplied Types.   ⇒ Oracle Built-in Data Types in Oracle ⇐ What Is SQL Standard in Oracle ⇑ Understanding SQL ... 2020-05-29, 2537🔥, 0💬

Show Execution Statistics Reports in Oracle
How To Get Execution Statistics Reports on Query Statements in Oracle? If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON STATISTICS" command to turn on execution statistics reports on query statements. The tutorial exercise bellow shows you a good example: S... 2020-05-29, 2413🔥, 0💬

Introduction to Oracle Database 10g Express Edition
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want to learn how to install Oracle database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Oracle Database 10g Express Edition with installation instr... 2020-05-15, 3344🔥, 0💬

What Is Oracle Database 10g Express Edition in Oracle
What Is Oracle Database 10g Express Edition in Oracle? Based on Oracle Web site: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download;... 2020-05-15, 2873🔥, 0💬

What Is ODBC in Oracle
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect... 2020-05-15, 2728🔥, 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, 3103🔥, 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, 2826🔥, 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, 2483🔥, 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, 5323🔥, 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, 2876🔥, 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, 2670🔥, 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, 2659🔥, 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, 2613🔥, 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, 3009🔥, 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, 2670🔥, 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, 2574🔥, 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, 2565🔥, 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, 2345🔥, 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, 7162🔥, 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, 3420🔥, 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, 2612🔥, 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, 2401🔥, 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, 2373🔥, 0💬

<< < … 7 8 9 10 11 12 13 14 15 16 17 … > >>   ∑:1349  Sort:Rank

General MySQL Oracle SQL Server