Tom Kyte

Subscribe to Tom Kyte feed Tom Kyte
These are the most recently asked questions on Ask Tom
Updated: 2 hours 17 min ago

Dynamic sql

Wed, 2016-07-20 08:06
HI TOM, 1)exactly in which situation we need to use these concepts in dynamic sql. i)"dbms_sql package" in dynamic sql ii)"Native dynamic sql" in dynamic sql .... .... show me with an example what is the vary in both the cases? ...
Categories: DBA Blogs

Mapping columns from two tables ,if match replace with another string

Tue, 2016-07-19 13:46
Hi Tom, I have a question?could you assist regarding this issue? 1. I have two tables are order table and product table. 2. order table containing two columns are order test and order app.the column data format is order test ...
Categories: DBA Blogs

SQL Injections

Tue, 2016-07-19 13:46
Hi Tom, 1)What is the sql injection,And how to solve sql injection problems with an example program tom?
Categories: DBA Blogs

Tom Kyte's books

Tue, 2016-07-19 13:46
Hi Tom, I have some of your fine Oracle books. Effective Oracle by design and Expert Oracle Database Architecture (latest version). I prefer reading on an ipad rather than carrying them around with me. Is there a PDF version of these books? Do ...
Categories: DBA Blogs

Converting Row to Column and Vice-versa

Tue, 2016-07-19 13:46
Hi Tom, I have a table Assigned_Task. ENAME JANUARY FEBRUARY MARCH APRIL ------ -------- -------- ------ ------ RASHMI 20 25 30 05 SOUMYA 11 21 09 15 BISWA 17 33 19 00 I want the output as below format: M...
Categories: DBA Blogs

Unique value in Oracle Collection variable

Tue, 2016-07-19 13:46
Hi team, I have one doubt on oracle collection while implementing on Scenario in my assignment. We need to have collection variable column (vARRAYS) inside a Table , Sample table structure looks like below id name list 1 ABC varra...
Categories: DBA Blogs

Alternatives for to_char(dt, 'DAY')

Tue, 2016-07-19 13:46
--->A simple SQL issue that I faced few days back. We normally perform some executions on weekends(SATURDAY or SUNDAY) like some sort of cleaning activity,stats gathering,partition creation etc. Please take caution If your are planning to achieve ...
Categories: DBA Blogs

The New Ask Tom

Mon, 2016-07-18 19:26
Why do parts of the new Ask Tom appear in another language? e.g. on the list of questions asked previously: Kedd Februar 18, 2003 (H. Feb 17, 2003, 0 days old) Thanks.
Categories: DBA Blogs

pivot data into named columns

Mon, 2016-07-18 19:26
Hi, I have a table that looks like the following PHOTOID PHOTO PRODUCT_ID 1 BLOB 123 2 BLOB 123 3 BLOB 123 4 BLOB 123 5 BLOB 123 6 BLOB 124 7 BLOB 124 8 BLOB 125 9 BLOB 126 10 BLOB 126 11 BLOB 126 12 BLOB 126 13 BLOB 126 each PRODUC...
Categories: DBA Blogs

Code enchancement

Mon, 2016-07-18 19:26
Hello Chris Saxon, I have a below table structure. CREATE TABLE "PEOPLE" ( "PERSON_ID" NUMBER, "GIVEN_NAME" VARCHAR2(100), "CATEGORY" number(50) ) INSERT INTO people VALUES(1,Connor,1001); / INSERT INTO people VALU...
Categories: DBA Blogs

difference between soft parse and hard parse

Mon, 2016-07-18 19:26
Hi Tom Can you explain briefly the difference between soft and hard parse? cheers
Categories: DBA Blogs

Time conversion

Mon, 2016-07-18 19:26
Hi Team, Please let me know how we can convert <b>14-JUL-2016 17:11:05 PM</b> into 1<b>7:11:05 or 05:11:05 PM only</b> in Oracle. Regards, Atin
Categories: DBA Blogs

Why it is difficult to scale oracle

Mon, 2016-07-18 19:26
Why it is difficult to scale oracle database. Thanks!!
Categories: DBA Blogs

Document No. Repeat

Mon, 2016-07-18 01:26
Hello,Dear Tom: Document No. repeated in the database! SELECT T.*,T.ROWID FROM AR_BILL T WHERE T.BILL_NO = '201607-141055001-001-000091' BILL_ID BILL_TYPE BILL_NO CO_CODE ND REASON PROJECT_CODE APP_ID INPUTOR_ID ORG_CODE INPUT_DATE BILL...
Categories: DBA Blogs

Hash partitioning and number of partition

Mon, 2016-07-18 01:26
Hi Tom, I have a question regarding the choice of the number of partitions when using hash partitioning. I have the following table used to store documents <code>CREATE TABLE "DOCUMENT" ( "DOCUMENT_ID" NUMBER(38,0), "CREATED_BY" VARCHA...
Categories: DBA Blogs

Explanation of Hints

Mon, 2016-07-18 01:26
Hi Tom, 1)first up all great thanks to you for spending time for me explain about following hints Parallel append index no_index first_rows and all_rows with an example in which situation we may use what hint in select the data from table? ...
Categories: DBA Blogs

Member procedures & Member function in plsql i.e member sub programs in oracle(plsql)

Mon, 2016-07-18 01:26
Hi Tom, 1)why we are using,what is purpose of Member procedures & member functions in plsql subprograms explain an example? 2)Difference between stored subprograms and member subprograms?
Categories: DBA Blogs

How to set all elements of collections

Mon, 2016-07-18 01:26
I've three questions 1) Suppose I have a collection of numbers say 300 values & i want to initialise with number 72 what would be the best way to do so ,rather than writing 300 times 2) I've to generate reports in pdf so what would you sugg...
Categories: DBA Blogs

Will open cursor hold up more tablespace when it is not closed?

Mon, 2016-07-18 01:26
Hi Tom, I am using oracle 11g and the tablespaces keeps growing, I have recently identified a issue with open cursors which is not closed when the session was closed. Will open cursor eats up all the spaces which leads to consume more temp spa...
Categories: DBA Blogs

ORA-01578: ORACLE data block corrupted (file # , block # )

Mon, 2016-07-18 01:26
Hi Tom, I m getting following error in my production data base alert log since last 5 month. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_j000_26775.trc: ORA-01578: ORACLE data block corrupted (file # , block # ) ORA-01578: O...
Categories: DBA Blogs

Pages