SQLS*Plus

Assigning Permissions and Roles in SQL Server

SQL Server applies role-based security rights delimitation. A role is a certain set of rights that can be assigned to a certain user or group of users.In SQL Server there are default server...

How to specify the version and edition of SQL server

One of the tasks that one has to face during software development or DBMS administration (and, in particular, SQL Server) is determining which version of the SQL Server is installed, in which edition...

Oracle TO_MULTI_BYTE function

The Oracle/PLSQL TO_MULTI_BYTE function returns a character value from all single-byte characters and converts it into multi-byte characters. To use this function, your database character set...

Oracle TO_LOB function

The Oracle/PLSQL TO_LOB function converts LONG or LONG RAW values to LOB values. Syntax of the Oracle/PLSQL TO_LOB function TO_LOB( long_column_id ) Parameters or argumentslong_column_id...

Oracle TO_DSINTERVAL function

The Oracle/PLSQL TO_DSINTERVAL function converts the string to INTERVAL DAY TO SECOND. Syntax of the Oracle/PLSQL TO_DSINTERVAL function TO_DSINTERVAL( character [ nls_parameter_id ] )...

Oracle TO_CLOB function

Oracle/PLSQL TO_CLOB function converts character data of CLOB type Syntax of the Oracle/PLSQL TO_CLOB function TO_CLOB(expression_id) Parameters or argumentsexpression_id - can accept...

Oracle RAWTOHEX function

The Oracle/PLSQL RAWTOHEX function converts a RAW value into a hexadecimal character representation. Syntax of the Oracle/PLSQL RAWTOHEX function RAWTOHEX( raw_id ) Parameters or arguments...

Oracle NUMTOYMINTERVAL function

The Oracle/PLSQL NUMTOYMINTERVAL function converts a numerical value into a value of type INTERVAL YEAR TO MONTH. Function Oracle/PLSQL NUMTOYMINTERVAL syntax NUMTOYMINTERVAL( number_id,...

What happens if you turn off the clustered index?

You probably already know that you can disable the index. This can be handy with large loads, and loading + enabling indexes (you will have to completely rebuild them) is faster than loading with...

Oracle HEXTORAW function

The Oracle/PLSQL HEXTORAW function converts a string representing a hexadecimal number into a RAW value. Syntax of the Oracle/PLSQL HEXTORAW function HEXTORAW( char_id ) Parameters or...

Oracle FROM_TZ function

The Oracle PLSQL FROM_TZ function converts the TIMESTAMP value to TIMESTAMP with the time zone value. Oracle/PLSQL FROM_TZ function syntax FROM_TZ( timestamp_value_id, time_zone_value_id...

Oracle DECOMPOSE function

The Oracle/PLSQL DECOMPOSE function takes a string and returns a Unicode string. Oracle/PLSQL DECOMPOSE function syntax DECOMPOSE( string_id ) Parameters or argumentsstring_id - a string...

How to make SELECT COUNT(*) requests very fast

When you run SELECT COUNT(*), the speed of results depends largely on the structure and settings of the database. Let's do a survey on the Votes table in the Stack Overflow database - 300 GB version...

Cool hints of requests

Cool hints of requests - SQL Server documentation contains a pretty cool list of query hints: But what is the color box? Let's see.Since SQL Server query optimizer usually chooses the best...

Oracle CONVERT function

The Oracle/PLSQL CONVERT function converts a string from one character set to another. CONVERT function syntax CONVERT( string1_id , char_set_to_id , [ char_set_from_id ] ) Parameters or...

SQL SELECT statement

The SQL SELECT operator is used to extract records from one or more tables in a SQL database. Syntax of the SELECT operator SELECTexpressions_id FROM tabs [WHERE conds] Parameters or...

Tag: SQL