Can we get partial set of data from two different partitions in oracle

Questions : Can we get partial set of data from two different partitions in oracle


If a table is partitioned by month and programming will there be any error while retrieving Learning the data from 15th of previous month to Earhost 15th of the current month as data is most effective spread across two different partitions.

Total Answers 1

Answers 1 : of Can we get partial set of data from two different partitions in oracle

Crappy interview question, but the wrong idea answer is No, ie, you can span use of case partitions with queries without any United issues:

SQL> create table t (   x date )
  2  _OFFSET);  partition by range ( x )
  3  (
  4    (-SMALL  partition p1 values less than ( date _left).offset  '2018-05-01' ),
  5    partition p2 arrowImgView.mas  values less than ( date '2018-06-01' ),
 (self.   6    partition p3 values less than ( equalTo  date '2018-07-01' )
  7  );

Table make.right.  created.

SQL> insert into t
 mas_top);   2  select date '2018-04-01'+ rownum
  3 ImgView.   from dual
  4  connect by date ReadIndicator  '2018-04-01'+ level < date _have  '2018-07-01';

90 rows .equalTo(  created.

SQL> select  count(*) from t partition ( p1 ) ;


1 row (TINY_  selected.

SQL> select count(*) from .offset  t partition ( p2 ) ;

  mas_right)  COUNT(*)

1 row ImgView.  selected.

SQL> select count(*) from Indicator  t partition ( p3 ) ;

  Read  COUNT(*)

1 row _have  selected.

SQL> select .equalTo(  count(*)
  2  from t
  3  where x make.left  between date '2018-05-15' and date *make) {  '2018-06-15';

    straintMaker      32

Top rated topics

Custom hosted AWS Server Security Audit - Penetration Testing (Odoo V10 CE)

Type hinting a function that takes the return type as parameter

Copy worksheet from cell reference

OpenSSL BIO operation

Nested layouts or use a RecyclerView?

CSS not applying to all children

Vs2019 - Xamarin: loses path settings of "Java Development Kit Location"

Adding entries to a column in a pandas DataFrame row-by-row using a dictionary

Get Backend name when I use VideoCapture

How does class know which implementation of an interface to take?

Transform a string into ISO datetime format | Freemarker

HLLAPI Search Presentation Space (Function 6)

What is exactly ".\" in zsh commands

Compare values in array and remove items that are not the same in Ruby/Rails

Update legend when adding data to existing plot (Pandas)

How do I interpret merge-with that takes a fn in clojure?

Why CGroups file memory.limit_in_bytes use 9223372036854771712 as a default value?

Form space the input box

How to lock on asynchronous file-writes with seperate locks per file in Rust?

Delete records from table, if it exceeds 100k records

Add a timestamp column to output table in Python Dash Example

How to extend RetryRegistry bean in resilience4j [Spring Boot]?

Why the for loop is not turning to true?

Validation failed: video_data.0._id: Cast to ObjectId failed for value \"\" (type string) at path \"_

How to convert contents of a text file into individual array

Class for remembering the length of data and split them up

Css transiton and css animation cannot be used together

True conditions, false evaluates

Why can't I use properties from my ObservableCollection inside a ListView

NodeJS JSON response required through key value mapping

Custom navigation arrow in React-Native image slider box

Dropdown going off to the out of the Header for RTL

Taking the unique values to a dataframe Pandas Python

Jstree get checked node without expanding

Trello Embed SDK: 401 when showing cards in Firefox only

How to get sql to pring in the same row instead multple rows (db is db2)

How can I work with pypac and other model like pygsheets?

Add the remaining quarterly columns that do not have any values

Release memory for Pycuda

Connecting with office365 fails with 401 but user is authorized

How to use vert.x eventbus to communicate between openfaas functions

Why can't extern find the parameter defined in dll?

How to translate C to MIPS?

What's the differenct between `go tool compile` and `go tool objdump`?

How to use vector as a private member in class to store and pass data

Use both Tailwind and SCSS with cssbundling-rails

Angular Login Issue with Authentication Service

How to create a dynamic 3d table in dart?

Vue-cli: dist/js/ is not found in website source

Oracle APEX Inserting Special Characters (Symbols) Instead of Words