This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[Unit] | |
Description=Oracle DB Startup-Shutdown | |
After=syslog.target network.target | |
[Service] | |
RemainAfterExit=yes | |
User=oracle | |
Group=oinstall | |
Restart=no | |
ExecStart=/app/oracle/ora122/bin/dbstart /app/oracle/ora122 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
systemctl enable oracle |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
systemctl start oracle |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
systemctl stop oracle |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
db01:/app/oracle/ora122:Y | |
db02:/app/oracle/ora122:N | |
db03:/app/oracle/ora122:Y | |
db04:/app/oracle/ora122:Y | |
db05:/app/oracle/ora122:N |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create event trigger et_exemple | |
on ddl_command_end | |
execute function fet_exemple(); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
declare | |
l_obj record; | |
l_table_name character varying := ''; | |
... | |
begin | |
... | |
for l_obj in select * from pg_event_trigger_ddl_commands() | |
loop | |
if l_obj.command_tag = 'CREATE TABLE' then | |
l_table_name = substr(l_obj.object_identity,position('.' in l_obj.object_identity) + 1); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
c1 cursor (c_exemple_table_name character varying) is | |
(select column_name from information_schema.columns | |
where table_name = c_exemple_table_name | |
order by ordinal_position); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
alter database <ddd> set default_with_oids to on; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
C:\Users\Administrateur>psql -U postgres test | |
psql (11.0) | |
Attention : l'encodage console (850) diffère de l'encodage Windows (1252). | |
Les caractères 8 bits peuvent ne pas fonctionner correctement. | |
Voir la section « Notes aux utilisateurs de Windows » de la page | |
référence de psql pour les détails. | |
Connexion SSL (protocole : TLSv1.2, chiffrement : ECDHE-RSA-AES256-GCM-SHA384, bits : 256, compression : désactivé) | |
Saisissez « help » pour l'aide. | |
test=# create table personnes(nom character varying(100),prenom character varying(100)); |
OlderNewer