DBA Blogs

Exporting multiple rows from a table to single row text using utl

Tom Kyte - Thu, 2017-11-16 10:06
In my project, I need export multiple rows from a single column to single row text using utl file Example below My table : Employees Employee_name ----------------------------- Smith John Tom Adam And my output text file should export like...
Categories: DBA Blogs

INSTR Function to find exact match of a value

Tom Kyte - Thu, 2017-11-16 10:06
Hi, Struggling for sometime now. I have a list read from a table column - (1,2,3,10,11) I need to check if my number is present in the above list So for 1 INSTR(1, List) return 2 which is fine. Now the issue is if the list contain (2,3,10,11)...
Categories: DBA Blogs

Strangler Pattern For Linked Oracle DB - how could it be done?

Tom Kyte - Wed, 2017-11-15 15:46
Hi, I'm not a big expert with Oracle databases so please forgive my fumbling description. We're working with a system where there are two databases which are connected using a database link. A -> queries and RPCs -> B There is a need to intr...
Categories: DBA Blogs

Storing a calculated value in a variable at run time without using triggers.

Tom Kyte - Wed, 2017-11-15 15:46
Is there a way to store a calculated data without the use of triggers? With some input data, calculations will be done and a variable will store the output data. When the input data is modified, the variable will have another calculated data. Is ther...
Categories: DBA Blogs

Is Using ROWTYPE is better then fetching 75% columns values to different variables

Tom Kyte - Wed, 2017-11-15 15:46
Hi Tom, I am using multiple variables to get columns values from a table(obviously I am using INTO clause and getting one row with filter criteria). I can do this by using %ROWTYPE as well. This way it will fetch all of the columns. Now, pro...
Categories: DBA Blogs

Virtual Private Database

Tom Kyte - Wed, 2017-11-15 15:46
Hello Tom, I know you can use VPD to restrict data horizontally - that is restrict rows based on where clauses. However, is there a way to automatically hide columns from users using VPD? Let's say there is a table called MBR(MBR_ID NUMBER, LNAM...
Categories: DBA Blogs

merge the cursor output of multiple stored procedures into one result

Tom Kyte - Wed, 2017-11-15 15:46
Hello Tom, Can you please tell me how can i merge the output of 6 stored procedures into one result. The output of each stored procedure is a cursor which holds n number of records(records data structure is same). I have to merge the data and ...
Categories: DBA Blogs

need a single update query for below question

Tom Kyte - Wed, 2017-11-15 15:46
I've table locations and it contains below data : loc_id location_name 101 newyork 102 losangels 103 chicago 104 boston 105 dallas now is that possible to write a single query to update all records like below loc_id location_name 101...
Categories: DBA Blogs

Creating a PDB in a desired location in 12.2

Hemant K Chitale - Wed, 2017-11-15 08:53
A video on creating a Pluggable Database in a desired location, using the command-line.
.
.
.

Categories: DBA Blogs

Import connections

Tom Kyte - Tue, 2017-11-14 21:26
Need way to import *new* connections to SQL Developer without manual typing. Is it possible to import them from a spreadsheet or csv?
Categories: DBA Blogs

Snapshot database

Tom Kyte - Tue, 2017-11-14 21:26
Dear Team, I have active data guard whose flash retention policy is 1 hour and undo retention is 900. want to convert standby database to snapshot database for few days, please let me know its possible or not. is above mention parameter is depe...
Categories: DBA Blogs

Alert log monitoring script

Tom Kyte - Tue, 2017-11-14 21:26
Hi, Could you please anyone help me on the script for Alert log monitoring for every one 1 hour need to fetch the errors and send it mail. Thanks
Categories: DBA Blogs

Disabling DBMS_SCHEDULER jobs on import

Tom Kyte - Tue, 2017-11-14 21:26
We refresh our test and development environments from production weekly. Is there a way to automatically disable DBMS_SCHEDULER jobs on import? I have a "reset" script that I run after the refresh, but "overdue" jobs seem to run immediately after imp...
Categories: DBA Blogs

Arizona Oracle User Group meeting Thursday

Bobby Durrett's DBA Blog - Tue, 2017-11-14 13:25

The Arizona Oracle User Group (AZORA) is meeting this Thursday, November 16th, 2017 from 12:30 to 3:30 pm Arizona time.

Here is the link to the Meetup:

#meetup_oembed .mu_clearfix:after { visibility: hidden; display: block; font-size: 0; content: " "; clear: both; height: 0; }* html #meetup_oembed .mu_clearfix, *:first-child+html #meetup_oembed .mu_clearfix { zoom: 1; }#meetup_oembed { background:#eee;border:1px solid #ccc;padding:10px;-moz-border-radius:3px;-webkit-border-radius:3px;border-radius:3px;margin:0; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; }#meetup_oembed h3 { font-weight:normal; margin:0 0 10px; padding:0; line-height:26px; font-family:Georgia,Palatino,serif; font-size:24px }#meetup_oembed p { margin: 0 0 10px; padding:0; line-height:16px; }#meetup_oembed img { border:none; margin:0; padding:0; }#meetup_oembed a, #meetup_oembed a:visited, #meetup_oembed a:link { color: #1B76B3; text-decoration: none; cursor: hand; cursor: pointer; }#meetup_oembed a:hover { color: #1B76B3; text-decoration: underline; }#meetup_oembed a.mu_button { font-size:14px; -moz-border-radius:3px;-webkit-border-radius:3px;border-radius:3px;border:2px solid #A7241D;color:white!important;text-decoration:none;background-color: #CA3E47; background-image: -moz-linear-gradient(top, #ca3e47, #a8252e); background-image: -webkit-gradient(linear, left bottom, left top, color-stop(0, #a8252e), color-stop(1, #ca3e47));disvplay:inline-block;padding:5px 10px; }#meetup_oembed a.mu_button:hover { color: #fff!important; text-decoration: none; }#meetup_oembed .photo { width:50px; height:50px; overflow:hidden;background:#ccc;float:left;margin:0 5px 0 0;text-align:center;padding:1px; }#meetup_oembed .photo img { height:50px }#meetup_oembed .number { font-size:18px; }#meetup_oembed .thing { text-transform: uppercase; color: #555; }
AZ-ORA November Meetup – Dan Morgan live!

Thursday, Nov 16, 2017, 12:30 PM

Republic Services – 2nd Floor Conference Rooms
14400 N 87th St (AZ101 & Raintree) Scottsdale, AZ

13 AZORAS Attending

It’s time to learn more about Oracle and Oracle products! Dan Morgan from Forsythe Meta 7 will be speaking at our November 16 Arizona Oracle User Group (AZ-ORA) meeting on two topics: “Channeling Oracle OpenWorld 2017” for DBAs and SQL & PL/SQL Developers and “Security for Oracle DBAs and Developers” – more details to come…When: Thursday Novembe…

Check out this Meetup →

Here is a link to the user group site with more information:

AZORA Meeting Nov 16, 2017

I’m looking forward to it. I hope to see you there!

Bobby

Categories: DBA Blogs

Admin vs Design

Tom Kyte - Tue, 2017-11-14 03:06
First of all why people or do not understand or u people force . DBA primary role and still they r rude ( back up , recovery ,upgrade, monitoring ) a system. It is the most crucial part as Data Loss , recovery can not not be priced. It is a 24*7...
Categories: DBA Blogs

Object info w.r.t redo

Tom Kyte - Tue, 2017-11-14 03:06
Dear Sir, How can I found which object generate more redo in database. Thanks Pradeep
Categories: DBA Blogs

DBMS facilities

Tom Kyte - Tue, 2017-11-14 03:06
I am not able to understand this question. What are they asking in the question? Thank You!: "Starting at the client invocation describe the mechanics of the DBMS through a SQL SELECT all the way through the response to the client. Name all faci...
Categories: DBA Blogs

difference between sql tuning advisor and sql access advisor

Tom Kyte - Tue, 2017-11-14 03:06
After reading both "Sql Tuning advisor" and "sql access advisor" , getting little confused on -- what is exact difference behind these advisors -- which situation one can use one advisor over another Please provide your guidance. thx A...
Categories: DBA Blogs

Table with date column datatype (Storing datetime) causing issue in fetching result and when use with to_date and to_char causing performance issue.

Tom Kyte - Tue, 2017-11-14 03:06
Hello Tom, Good Morning. This is my first time posting question, I always got helped for my most of problems from your post. Need your help in understanding what will be good way with respect of performance. I have one table with date dat...
Categories: DBA Blogs

Partner Webcast – Setting up API strategy with Oracle API Platform Cloud Service

APIs are at the center of the digital economy as they provide the software plumbing between ever more distributed modes of digital interaction.  Several business models are associated with...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs