Top "Oracle" questions

select distinct constraint_type from user_constraints; C - C P R U Seems P means primary key and R …

I'd like to set default database schema in Oracle Connection URL jdbc:oracle:thin:@<server>:<port1521>:&…

The whole question is pretty much in the title. For each row of the table I'd like to select the …

I have this table create table student ( stu_id int, s_name nvarchar(max), s_subject nvarchar(max), ) and this …

I tried searching for an answer to my problem but failed to get an answer that actually helped. I've written …

This should be simple and shows my SQL ignorance: SQL> select max(1,2) from dual; select max(1,2) from dual * ERROR …

Is there a reason why Oracle is case sensitive and others like SQL Server, and MySQL are not by default? …

Using CONNECT BY LEVEL seems to return too many rows when performed on a table. What is the logic behind …

I have a homegrown Oracle role that was created long ago: create role MyRole; It's been granted the ability to …

Can somebody tell me how to extract my table definitions using SQL? I want to extract the datatypes of all …