This SQL tutorial focuses on cross join in Oracle, and provides explanations, examples A CROSS JOIN in Oracle is a JOIN operation that produces the Cartesian product of two tables. i,e if one of the table is having 100 rows and another one 8 rows, then cross join will produce 800 rows Here table emp […]
Cross Join in Oracle Read More »
We need to connect system for monitoring,administration.We need to have ssh passwordless login setup to remote server for monitoring and administration. In this article ,I will post steps on How to Setup ssh passwordless login using SSH keygen between two servers System 1 : serv1 System 2 : serv2 Username : orac Lets us first describe
How to Setup ssh passwordless login using SSH keygen between two servers Read More »
There are various joins in Oracle like inner join,left outer join,right outer join,full outer join,cross join. This SQL tutorial provides oracle join syntax on each of them with examples Inner Join syntax and ExampleTwo tables examples and syntax SELECT EMP.EMPNO,EMP.ENAME, DEPT.DEPTNO,DEPT.DNAMEFROM EMP , DEPTwhere EMP. DEPTNO= DEPT. DEPTNO; or ANSI syntax SELECT EMP.EMPNO,EMP.ENAME, DEPT.DEPTNO,DEPT.DNAMEFROM EMP INNER
oracle join syntax examples Read More »
Sometimes we need to drop the datafile or tempfile from the tablespace in Oracle. We have the different procedures as per the Oracle release Procedure to drop the datafile till 10gR2 There is no direct SQL statement to drop data files from a tablespace. In that case, we need to drop the tablespace after all
How to Drop a datafile from Tablespace in Oracle Read More »
We often need to find out how big is that particular oracle table. Suppose you did a huge data load and want to know the allocated oracle table size. We can use the below Query to check table size in oracle For oracle table size in MB select owner as “Schema” , segment_name as “Object
Query to check table size in Oracle database Read More »
What is the pinning in Shared pool Oracle Applications requires space in the ORACLE System Global Area (SGA) for stored packages and functions. If SGA space is fragmented, there may not be enough space to load a package or function. You should pre-allocate space in the SGA shared pool for packages, functions, and sequences by
Why pinning objects into the shared pool? Read More »
