We help IT Professionals succeed at work.

Oracle Database

79K

Solutions

26K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

In this article, we will see how we can automate the process of moving Oracle metadata to version control system, in my case I am using GIT using a simple shell script to avoid manual intervention.
0
In this article, I will be sharing the issues that we faced while converting the data type and NLS semantic to CHAR from BYTES. This was one of the business use cases where we needed to convert the entire columns throughout the schema from BYTES to CHAR types only for VARCHAR2 columns datatypes.
0
In this article, we will see how to use FIRST_VALUE & LAST_VALUE in Oracle with simple examples.
0
In this article, we will see how we can fix the OLE DB connection error when connecting to an Oracle database using SQL Server Integration Services.
0
In this article, we will see how to use the RANK analytical function in an Oracle database and how it helps us in an analysis.
0
In this article, we will see how to use Order by Clause in Oracle with simple examples.
0
ORA-12547: TNS:lost contact, "sqlplus / as sysdba"
1

Expert Comment

by:vishal srivastava
Hi Suri ,

Great Read ! The representation and explanation is very helpful  . Thanks for the blog .
Keep it up !!  :)

- Vishal.
0
An introductory discussion about how to use Partition by Clause in Oracle.
0
This is about the change in the value setting for the rp_filter parameter in Linux.
0
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
0
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
0
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
0
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
1
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
2
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
2
SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database objects which can later be used in our application.
0
APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
2
LVL 8

Expert Comment

by:Yashwant Vishwakarma
Good Article Voted Yes!!
0
LVL 18

Author Comment

by:Swadhin Ray
thanks Yashwant for your vote.

regards,
Sloba
0
Meta characters are the characters in a programming language that are interpreted by the programming language to have specific meanings within the language itself.
0
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
1

Expert Comment

by:alsatham hussain
i can easily understand.

Thanks
0
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
0
A short introduction on Oracle Apex: 
Oracle Application Express is mainly used to develop Web based applications with SQL and PL/SQL. The Web-based applications can be developed using a web browser which can easily be deployed for any desktop or mobile applications. There are various version that are been released by Oracle. In recent release on May 2015 they released APEX version 5. Oracle recommends that Oracle APEX to be used on latest web browsers available to have a good experience.

Below are the few listed browsers that oracle suggests:
  • Mozilla Firefox 35
  • Google Chrome 40
  • Apple Safari 7
  • Microsoft Internet Explorer 9
 
We can also use the earlier versions of the web browsers by using the legacy themes.

To access full documentation on Oracle APEX, you can open the link from by clicking on the link here

In this article we will see how we can upgrade the existing APEX version to Oracle Application Express Release 5.0.1 version. You can also see my other articles on upgrading APEX version from version 3 to 4 on 11g.
 
Here my DB version is 11g Release 11.2.0.1.0 where my current APEX version is 4.2.6.00.03:
 
Connected to Oracle Database 11g Release 11.2.0.1.0 
Connected as SYS


SQL> SELECT 

Open in new window

0
The purpose of this article is to show how we can create Linux Mint virtual machine using Oracle Virtual Box. To install Linux Mint we have to download the ISO file from its website i.e. http://www.linuxmint.com. Once you open the link you will see a download option at the right side of the page, go to the download page from the menu :

pic-2.pngYou can download 32 bit or 63 bit image and I am using 32 bit as my system is with 32 bit OS . I have downloaded and kept it on my specific directory where I can map to my Virtual Box while installing it.
Now open the VMBox and click on New to create virtual machine and map the ISO image to proceed with installing.  Once you set up all the necessary settings on memory space and disk space you will see the screen like below and then you can click on start button to start the installation.

Follow below steps shown with screen shot to start the virtual machine creation: 
2015-07-05-19-21-31-.jpgCick on New and proceed next :
2015-07-05-19-19-08-Oracle-VM-VirtualBoxGive any name to the virtual machine and select the type and version , click Next:
 
2015-07-05-19-19-26-.jpgSelect the memory size you want the VM to have -  I am using 1GB of RAM i.e. 1024 MB approximately. 

2015-07-05-19-19-46-Oracle-VM-VirtualBox
Click on Create button.
2015-07-05-19-20-52-.jpgClick Next. 

2015-07-05-19-21-00-Oracle-VM-VirtualBoxI am trying all default setting for installing the OS but you can choose as per your need. 
2015-07-05-19-21-18-.jpgHere we can set the size of the virtual hard drive . Once filled click on Create button. 

2015-07-05-19-21-31-.jpg Now set the ISO file which was downloaded from Linux Mint website. 
sloba-000006.jpg
1
Elementary operating system is a very pretty, high speed, lightweight Linux operating system for 32 and 64-bit x86 computers. This OS is built on an Ubuntu core. To install elementary OS we need to download the ISO file from its website i.e. https://elementary.io/
pic-1.pngIf you scroll down on the website you will see like below, to download click on Download button as shown below:

pic-2.png
Now you can choose 32 0r 64 bit ISO file:

pic-3.png
pic-4.pngNow open your virtual machine box to create our new VM.
pic-6.pngClick on New button to start:
pic-7.png
Provide the name of the VM you want to create, I used as “elementaryOS”.  Now click on next button and proceed further. 
pic-8.pngSelect the memory size and click on next.

pic-9.pngClick on create.

pic-10.pngClick next.

pic-11.pngpic-12.pngKeep as default and click next and then choose the directory where you want the VM to be installed. Finally click on create button. 

pic-13.pngNow click on the setting gear icon to map the iso file. 


pic-14.png
Now “Ok” button.  After all the basic settings start the VM to install the OS. 

pic-15.png
pic-1.pngNow click on “Install elementary”.

pic-2.pngClick on continue. 

pic-3.pngClick Install Now and proceed with default selection including location as below. 

pic-4.pngSelect the Keyboard type you want to choose I am going with the default option with US English. 

pic-5.pngpic-6.png
0
With the help of flashback queries we have the option to look back in time to a certain state of a database, for example say we did some operation yesterday at 10 AM and today we want to go back to the same state where we started yesterday. So using Oracle flashback queries we have the ability to go back into time to a certain state of a database.

This can be achieved by using the system change number (SCN) or using a timestamp. We also have the option to select a range of system change number or timestamp values that will help us to go back to the point of time. This option will only help us to see the past stage of the database, not the future.

How this is possible is the first question that we can think about. This is possible as because all the data in databases are stored in data files and the redo log file is more essential here; in other words we are doing a rollback.  

Syntax of flashback queries:
 
SELECT … 
FROM [schema.]table [alias]
[
	  AS OF { SCN | TIMESTAMP } expr
	| VERSIONS BETWEEN { SCN | TIMESTAMP}
		{ expr | MINVALUE } AND { expr | MAXVALUE } 
]
[ WHERE … ] 
[ GROUP BY … ] 
[ ORDER BY … ]

Open in new window

AS OF” will take you to back in time to a previous state of a table against a time or system change number.  For example we want to see the records in a table 10 minutes ago then we can use the “AS OF" condition with the SCN or timestamp with additional conditions, if required, like “where” / ”group by” / “order by” . The “VERSIONS BETWEEN
0
I got a requirement to export the table data into CSV file. The major issue was like the column values from the table needed to be transposed and used as a header on the flat file. The challenge was that the column values were more than 30 characters and can reach up to 4000 characters.
 
I am using the sample table to simulate the issue and to check how we can resolve this problem.
 
Here is my sample table:

pic-4.JPG
Create the sample table:
 
create table MY_SURVEY_RESP
(
SURVEY_REQUEST_NAME VARCHAR2(100),
QUESTION_NAME	VARCHAR2(4000),
RESPONDENT	VARCHAR2(100),
RESPONSE  VARCHAR2(100)
);

Open in new window


To insert some sample data let's execute the below PLSQL block:
 
BEGIN
        INSERT INTO MY_SURVEY_RESP
        VALUES
                ('Q1'
                ,'R1 Compliance narrative form'
                ,'USER-1'
                ,'');
        INSERT INTO MY_SURVEY_RESP
        VALUES
                ('Q2'
                ,'R1 Compliance narrative form'
                ,'USER-1'
                ,'');
        INSERT INTO MY_SURVEY_RESP
        VALUES
                ('Q2'
                ,'R1 Evidence List'
                ,'USER-1'
                ,'Registered an evidence');
        INSERT INTO MY_SURVEY_RESP
        VALUES
                ('Q1'
                ,'R1 Evidence List'
                ,'USER-1'
                ,'Registered an evidence');
        INSERT INTO MY_SURVEY_RESP
        VALUES
                ('Q1'
            

Open in new window

0
LVL 75

Expert Comment

by:sdstuber
For reader reference:

Here's the question referenced above where slobaray asked how to do it.
http://www.experts-exchange.com/Database/Oracle/Q_28680635.html
0
LVL 18

Author Comment

by:Swadhin Ray
Thanks @ sdstuber : I provided the link to the question on the article including the information.

Regards,
Sloba
0

Oracle Database

79K

Solutions

26K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.