oracle Archives - Page 3 of 5

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 ...

May 21, 2022
0 Comments

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 ...

May 19, 2022
0 Comments

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, ...

May 19, 2022
0 Comments

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 ...

May 18, 2022
0 Comments

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) ...

May 18, 2022
0 Comments

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

May 18, 2022
0 Comments

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 ...

May 18, 2022
0 Comments

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 ...

May 18, 2022
0 Comments

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 ...

May 17, 2022
0 Comments

What is the difference between varchar and varchar2 in Oracle?

What is the difference between varchar and varchar2? 6 Answers 6

May 17, 2022
0 Comments