DBA Blogs

Execute immediate and passing clob as a parameter is not working.

Tom Kyte - Thu, 2017-10-12 23:06
I have the following procedure <code> create or replace PROCEDURE bscs_rateplan_sync ( tmcode_list IN CLOB, project_id IN VARCHAR2, requestname IN VARCHAR2, v_errm OUT VARCHAR2 ) ...
Categories: DBA Blogs

Differrent Character set and NLS

Tom Kyte - Thu, 2017-10-12 23:06
Hi TOM, Some question on Character set and NLS. 1) What is the different between US7ASCII and WE8ISO8859P1 character set and NLS? 2) Is there any problem for the DB with two diferrent character sets to interact, - trigger - dblink - e...
Categories: DBA Blogs

Auditing Operating system program name

Tom Kyte - Thu, 2017-10-12 23:06
Sir, i am developing a client/server program using VB & Oracle, it is in testing stage. i want to track whether the programmer is doing changes to the database using the application program(VB) or by logging into database(SQLPLUS) for this i us...
Categories: DBA Blogs

How you manage you're work-spaces!!

Tom Kyte - Thu, 2017-10-12 23:06
Greetings Team, I am very curious to know how you actually manage you're work spaces.I mean you always face different kind of questions all day along.How many laptops you use(of course you are using VM). But my question is if you guide someone fo...
Categories: DBA Blogs

SQL * Loader connection errors

Tom Kyte - Thu, 2017-10-12 23:06
To previous answer to MY SQL*Loader question I had asked, you said: Examples of SQL*Loader String <code>sqlldr.exe userid=my_user/my_password@some_string control=my_control.ctl sqlldr.exe userid=scott/tiger@//my_host:my_port/my_service_name con...
Categories: DBA Blogs

ORA-01722: invalid number error in decode

Tom Kyte - Thu, 2017-10-12 04:46
1. select decode('a',1,1,2) from dual --------> O/P Error saying Invalid Number 2. select decode(1,'a',1,2) from dual --------> O/P : 2 what is the difference in the above two cases and also please explain the execution process? Thanks I...
Categories: DBA Blogs

Using Analytical Functions to get Group Total

Tom Kyte - Thu, 2017-10-12 04:46
I need a GROUP TOTAL for EACH MONTH that SUMS up all the values in APPL column even when the query is for a particular APPL value. <code>create table test_grp_total (dttm_month date, appl varchar2(5), mins number) insert into test_grp_total va...
Categories: DBA Blogs

Convert row to matrix and save in table

Tom Kyte - Wed, 2017-10-11 10:26
Good Day I want to ask for your valuable help on a problem that I found, there is a table that stores the information in a single column in Clob format and is copied to another table of a second Oracle Schema, which separates the information with ...
Categories: DBA Blogs

ORA-12560: TNS:protocol adapter error (when running rman backup from scheduler on windows Oracle database)

Tom Kyte - Wed, 2017-10-11 10:26
Hi, I trying to setup a scheduler job on my windows 64bit Oracle database version 12C Below is the script i used where i created OS authentication and create a scheduler to run the backup_script. -- Create a credential so script is run as the co...
Categories: DBA Blogs

Numeric Overflow

Tom Kyte - Wed, 2017-10-11 10:26
I am attempting to Solve some mathematical problems using PL/SQL and I am facing a problem with huge numbers. One such question involves calculating 2 power 1000 (2 power 3 = 2*2*2 => 8). I tried assigning the values to multiple datatypes that I knew...
Categories: DBA Blogs

oracle on linux

Tom Kyte - Wed, 2017-10-11 10:26
i am not well verserd with linux ..i know that we have to write "sqlplus" on the comand prompt in linux to open sql*plus application...is there any place from where i can know how to open other (oracle) applications in linux like "oralce enterprise...
Categories: DBA Blogs

bind variables/ define confusion

Tom Kyte - Wed, 2017-10-11 10:26
Tom, Could you please clarify the DEFINE command in the example below. I am having trouble using the DEFINE command. INPUT: define naming = 'Ivan' insert into emp2 (fname) values (:naming); OUTPUT: Bind variable "NAMING" not declare...
Categories: DBA Blogs

SQLPLUS query output to *.csv or *.txt format

Tom Kyte - Wed, 2017-10-11 10:26
Hello Tom is there anyway to do a query in sql*plus, then have the result output to a file in *.csv or .*.txt format without invoking UTL_FILE, using only sql*plus command. I'm not allowed to creat any procedure. PS: this link "http://asktom.ora...
Categories: DBA Blogs

Partner Webcast – Achieve Database High Availability and Disaster Recovery with Oracle Cloud

The High Availability and Disaster Recovery needs of customers traditionally have required significant capital investment in the infrastructure that provides the redundant capabilities that are...

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

Second Highest Sal

Tom Kyte - Mon, 2017-10-09 21:46
Hello Tom, How are you, After long time i visited the site and able to find the button. Ok Here is my question how can i get from sql second highest salary record from the table but with deparment wise Ram 10 1000 Jai 10 2000 San 20 3000...
Categories: DBA Blogs

Process Cloud Service - Using correlations to communicate between processes (part 2)

Continuing my previous article Process Cloud Service - Using correlations to communicate between processes (part 1) I would like to demonstrate correlations in action using PCS Player. The PCS...

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

Submitted two abstracts to RMOUG Training Days 2018

Bobby Durrett's DBA Blog - Fri, 2017-10-06 18:05

I finally broke down and submitted my two talks to the RMOUG Training Days 2018. I’m not sure how likely I am to get my talks accepted but I learned a lot just through constructing my two abstracts. I have two talks that I have processed in my mind for a while:

  • Python for the Oracle DBA
  • Toastmasters for the Oracle DBA

These are just two things I’ve worked with and that I think have helped me in my job. Plus, they are two topics that interest me. Why talk about something boring just because you think other people want you to?

Anyway, it was fun to write the abstracts for two topics that I am passionate about. I have never been to RMOUG Training Days but I have heard a lot of good things. Hopefully I will get accepted and be able to get these talks out to the public.

I’m off next week so I don’t expect to blog until I get back to work. Maybe after I get back I can start to outline my Toastmasters talk in a few posts. I have given a couple of Toastmasters talks with similar material but this would be geared specifically for people who are more like me in the sense that they are Oracle DBAs.

Anyway, it was fun to get the abstracts turned in.

Bobby

Categories: DBA Blogs

Long to Varchar2 conversion....

Tom Kyte - Fri, 2017-10-06 02:06
Hi, Thanks for your earlier responses.... See, i have one more problem, like i want to retrive the first 4000 characters of the long datatype, with out using the pl sql code. i just wrote a function like // create or replace function g...
Categories: DBA Blogs

Indexing Seminar: Why Small Classes? (A Small Plot Of Land)

Richard Foote - Wed, 2017-10-04 16:50
Firstly, a huge thank-you to everyone who has enroled in one of my “Indexing Internals and Best Practices” Seminars running soon is Australia. The feedback and overall reaction has been extremely positive and I can’t wait to present all the material I’ve been putting together these past few weeks. There are currently limited places still […]
Categories: DBA Blogs

Oracle Infrastructure Automation with Chef

Chef is one of the most popular configuration management tools that automates the building of your infrastructure especially if you are working with many servers. In this blog post, I am going to...

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

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs