Help! Não consigo visualizar as constraints das tabelas.
SQL> create table tb_disciplina (id_disciplina integer constraint disc_id_pk primary key, nome_disciplina varchar2(20) constraint disc_nome_nn not null);
Tabela criada.
SQL> create table tb_aluno (id_aluno integer constraint alun_id_pk primary key, nome_aluno varchar2(50) constraint alun_nome_nn not null);
Tabela criada.
Tentando consultar constraints
SQL> select constraint_name, constraint_type, table_name from user_constraints where table_name = 'tb_aluno';
nÒo hß linhas selecionadas
SQL> select constraint_name, constraint_type, table_name from user_constraints where table_name = 'tb_disciplina';
nÒo hß linhas selecionadas