Servicii baze de date

MySql 60 Solutii

SQL Server 264 Solutii

Tabele fara Primary Key

Pentru cazurile in care ne cere audit-ul sau chiar pentru cazurile in care avem nevoie noi de asa ceva pentru o mai buna administrare a serverului de sql, am facut o procedura ce returneaza toate tabelele ce nu au definite PK pe acestea.

[mai mult...]

Useful SRVCTL Commands (Oracle RAC)

If you have to administer an Oracle Real Application Clusters (Oracle RAC) databases and instances using the Server Control Utility (SRVCTL).

The Server Control (SRVCTL) utility is installed on each node by default. You can use SRVCTL to start and stop the database and instances, manage configuration information, and to move or remove instances and services. You can also use SRVCTL to add services. SRVCTL also manages configuration information.

Syntax:

srvctl command object [parameters]

To see the command syntax and a list of options for each SRVCTL command, from the command line enter:

srvctl command (or verb) object (or noun) -h
[mai mult...]

Word count

Mai jos am creat o functie care returneaza numarul de cuvinte care se afla intr-o fraza. Functia poate fi rulata, desigur, avand ca parametru si numele unei coloane dintr-o tabela, cu conditia ca acea coloana sa fie de tipul varchar.

[mai mult...]