Cause :
The database is in Restricted Mode, Usually database will be put in restricted mode while taking backup. While in restricted mode users with Restricted access will have access to database. Normal users will be able to access database.
Identification :
You can identify the current login mode of the database using the query
SQL> select logins from [...]
Continue reading about ORA-01035: ORACLE only available to users with Restricted Session privelege
Character Functions in oracle
String function plays important role in oracle as often it is required to convert the string or extract certain part of it. These functions accept column value or an expression as the input.
ASCII
This function is used to get the ASCII value of a character.
E.g. SELECT ASCII (’A’) from [...]
In Oracle 10G, when we return from a java stored a response which size can be greater than 32767 (PLSQL limit for a varchar2) then we get “ORA-24345: A TRUNCATION OR NULL FETCH ERROR ” error.
To avoid getting this error is to return a Clob instead of Varchar2.
Steps to be followed
Create a [...]
Continue reading about Good to use CLOB instead of VARCHAR2 in Java Stored Procedure
Virtual Private Database
Virtual Private Database which is also known as Fine Grained Access Control (FGAC) is a new feature available with Oracle for providing row level restrictions on tables. Normally data restrictions are provided with views. The complexity grows exponentially with the number of views present in a database. Maintenance becomes a big task with [...]
‘Oraload’ is a bulk data load utility which is used to load multiple database tables with data files, with a high performance.This is a highly customizable piece of code, written in C++ using Oracle utilities, which can process 3 kinds of files mainly:
Flat files with bulk data separated by a delimiter
Files containing multiple [...]
Continue reading about ORALOAD Oracle Utility for Bulk Data Load
Following are the list PL/SQL Features introduced in Oracle11g
Automatic subprogram inlining
A continue statement
A cross-session PL/SQL function result cache
Dynamic SQL enhancements
Mixed, named, and positional notation SQL calls
A multiprocess connection pool
A PL/SQL Hierarchical Profiler
That the PL/SQL Native Compiler now generates native code
PL/Scope
Regular expression enhancements
A SIMPLE_INTEGER datatype
Direct [...]
Continue reading about PL/SQL Features Introduced in Oracle11g
The difference between RANK() and DENSE_RANK() is that RANK() leaves gaps in the ranking sequence when there are ties. Let us see this function through an example.
Continue reading about SQL Tutorial : Using RANK() and DENSE_RANK()
In subqueries, regardless of whether one row or multiple rows are returned, each of these rows contains only one column worth of data to compare to the main query level. The main query can be set up to handle multiple columns in each row returned, too.
For example
select deptno,ename,job,sal, from emp [...]
Continue reading about SQL TIPS : Writing Multiple Column Subqueries
In this tutorial we can see how to convert rows into columns using Structured Query language SQL. We cover this tutorial from the basic steps i.e creating tables and inserting values into the table so that it can be useful for basic users as well
Continue reading about SQL Tutorial : Converting Rows to Columns
