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.
Share tech news, updates, or what's on your mind.
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 Comments
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.
In this article, we will see how to use FIRST_VALUE & LAST_VALUE in Oracle with simple examples.
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.
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.
In this article, we will see how to use Order by Clause in Oracle with simple examples.
An introductory discussion about how to use Partition by Clause in Oracle.
This is about the change in the value setting for the rp_filter parameter in Linux.
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
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.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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.
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.
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.
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.
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.
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.png]()
You 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-.jpg]()
Cick on New and proceed next :
![2015-07-05-19-19-08-Oracle-VM-VirtualBox]()
Give any name to the virtual machine and select the type and version , click Next:
![2015-07-05-19-19-26-.jpg]()
Select 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-.jpg]()
Click Next.
![2015-07-05-19-21-00-Oracle-VM-VirtualBox]()
I am trying all default setting for installing the OS but you can choose as per your need.
![2015-07-05-19-21-18-.jpg]()
Here 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]()
…
You 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:
Cick on New and proceed next :
Select the memory size you want the VM to have - I am using 1GB of RAM i.e. 1024 MB approximately. Click on Create button.
Click Next. 
Here we can set the size of the virtual hard drive . Once filled click on Create button. 
Now set the ISO file which was downloaded from Linux Mint website. 
…
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.png]()
If 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.png]()
Now open your virtual machine box to create our new VM.
![pic-6.png]()
Click 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.png]()
Select the memory size and click on next.
![pic-9.png]()
Click on create.
![pic-10.png]()
Click next.
![pic-11.png]()
![pic-12.png]()
Keep 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.png]()
Now 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.png]()
Now click on “Install elementary”.
![pic-2.png]()
Click on continue.
![pic-3.png]()
Click Install Now and proceed with default selection including location as below.
![pic-4.png]()
Select the Keyboard type you want to choose I am going with the default option with US English.
![pic-5.png]()
![pic-6.png]()
…
If you scroll down on the website you will see like below, to download click on Download button as shown below:
Now you can choose 32 0r 64 bit ISO file:
Now open your virtual machine box to create our new VM.
Click on New button to start:
Provide the name of the VM you want to create, I used as “elementaryOS”. Now click on next button and proceed further.
Select the memory size and click on next.
Click on create.
Click next.
Keep as default and click next and then choose the directory where you want the VM to be installed. Finally click on create button. 
Now click on the setting gear icon to map the iso file. 
Now “Ok” button. After all the basic settings start the VM to install the OS.
Now click on “Install elementary”.
Click on continue. 
Click Install Now and proceed with default selection including location as below. 
Select the Keyboard type you want to choose I am going with the default option with US English. 
…
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:
To insert some sample data let's execute the below PLSQL block:
I am using the sample table to simulate the issue and to check how we can resolve this problem.
Here is my sample table:
Create the sample table:
create table MY_SURVEY_RESP
(
SURVEY_REQUEST_NAME VARCHAR2(100),
QUESTION_NAME VARCHAR2(4000),
RESPONDENT VARCHAR2(100),
RESPONSE VARCHAR2(100)
);
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'
Active 4 days ago
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
Here's the question referenced above where slobaray asked how to do it.
http://www.experts-exchange.com/Database/Oracle/Q_28680635.html
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.
Top Experts In
Oracle Database
-
1
slightwv (䄆 Netminder)16,400 points -
2
Ora_Techie6,475 points -
3
Pratik Somaiya4,600 points -
4
schwertner4,050 points -
5
johnsone3,350 points
-
6
Mark Geerlings3,200 points -
7
Franck Pachot3,200 points -
8
Erman Arslan2,800 points -
9
Swadhin Ray2,725 points -
10
sdstuber940 points -
11
Abhimanyu Suri509 points -
12
awking00500 points
-
13
Jeffrey Dake219 points -
14
mrjoltcola143 points -
15
Javier Morales133 points -
16
arana75 points -
17
Steve Wales66 points -
18
Geert G64 points -
19
Doug Walton60 points -
20
Ivo Stoykov49 points -
21
Mike Eghtebas34 points -
22
MikeOM_DBA32 points -
23
Christoffer Swanström25 points -
24
Chakravarthi Ayyala24 points
-
25
Anjugarg6621 points