Oracle SQL Developer multiple table views
In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. there where can … Read more
oracle
Select count(*) from multiple tables
How can I select count(*) from two different tables (call them tab1 and tab2) having as result: Count_1 Count_2 123 456 I’ve tried … Read more
How to connect to Oracle using Service Name instead of SID
I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, … Read more
Oracle “Partition By” Keyword
Can someone please explain what the partition by keyword does and give a simple example of it in action, as well as why … Read more
How do I do top 1 in Oracle? [duplicate]
This question already has answers here: How do I limit the number of rows returned by an Oracle query after ordering? (14 answers) … Read more
How do I list all the columns in a table?
For the various popular database systems, how do you list all the columns in a table? 12 Answers 12
Inner join vs Where
Is there a difference in performance (in oracle) between Select * from Table1 T1 Inner Join Table2 T2 On T1.ID = T2.ID And … Read more
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
We have an application running locally where we’re experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect … Read more
How can I create a copy of an Oracle table without copying the data?
I know the statement: create table xyz_new as select * from xyz; Which copies the structure and the data, but what if I … Read more
What is the difference between varchar and varchar2 in Oracle?
What is the difference between varchar and varchar2? 6 Answers 6