Jio Contact

 Contact Reliance JIO:

General Enquirers Toll Free: 1800-103-8877
Customer Care Email ID: care@jio.com / jioworld.help@ril.com
Care support: 198 (From Jio number)
General Enquirers: 199 (From Jio number)
Customer Care support: 1800-88-99999 (From any other operator)
Jio Tele verification: 1977 (For HD calling)

Support on Twitter @JioCare- tried this, got support person pretty quickly.

Good Luck: Jio or not ....its reliance !!!!

Oracle : Get source code of package

Quickly get source code : Use last select for more generic output.

select dbms_metadata.get_ddl('PACKAGE','&PACK','&SCHEMA') from dual;
select dbms_metadata.get_ddl('PACKAGE_BODY','&PACK','&SCHEMA') from dual;
or
Select  TEXT  from SYS.DBA_SOURCE where NAME='&PACK' and TYPE='PACKAGE' order by LINE;
Select  TEXT from SYS.DBA_SOURCE where NAME='&PACK' and TYPE='PACKAGE BODY' order by LINE;
or
Select  TEXT from SYS.DBA_SOURCE where NAME='&PACK'  order by LINE;

Short Experiment : Oracle chained rows

 Dealing with chained rows simple experiment

Simple experiment:

Simple table created from demo tables XEMP1.

The updated rows until ora error 1489 generated.:

update xemp1 set ename=ename||'abcdabcdabsdfajsdkfkasdjfkasj;dfkljasdkfjas;ldfjsdlfkjas;lfjas;dfjasldkfjasldfjasldkfjasldkjfaslkdjfasldfjasldfjabcdabcdabsdfajsdkfkasdjfkasj;dfkljasdkfjas;ldfjsdlfkjas;lfjas;dfjasldkfjasldfjasldkfjasldkjfaslkdjfasldfjasldfjabcdabcdabsdfajsdkfkasdjfkasj;dfkljasdkfjas;ldfjsdlfkjas;lfjas;dfjasldkfjasldfjasldkfjasldkjfaslkdjfasldfjasldfj' where rownum<50000
*
ERROR at line 1:
ORA-01489: result of string concatenation is too long


SQL> commit;

Size :

select sum(bytes)/power(1024,2) from dba_segments where segment_name='XEMP1'

SUM(BYTES)/POWER(1024,2)
------------------------
                     591

ANALYZE TABLE xemp1 COMPUTE STATISTICS;

Table analyzed.

Select /*Chained rows*/ owner, table_name, num_rows, chain_cnt, (chain_cnt*100/num_rows) pct, empty_blocks, blocks

from dba_tables

where chain_cnt > 0

and owner not in ('SYS','SYSTEM')

/

SQL> SQL> SQL> SQL> SQL>   2    3    4    5

OWNER        TABLE_NAME             NUM_ROWS  CHAIN_CNT PCT Empty Blks     Blks

------------ -------------------- ---------- ---------- --- ---------- --------

SCOTT        XEMP1                   7421212     518965   7        124   75,524

alter table xemp1 enable row movement;

Alter table XEMP1 shrink space compact;

elect /*Chained rows*/ owner, table_name, num_rows, chain_cnt, (chain_cnt*100/num_rows) pct, empty_blocks, blocks
from dba_tables
where chain_cnt > 0
and owner not in ('SYS','SYSTEM')
/
SQL> SQL> SQL> SQL> SQL>   2    3    4    5
OWNER        TABLE_NAME             NUM_ROWS  CHAIN_CNT PCT Empty Blks     Blks
------------ -------------------- ---------- ---------- --- ---------- --------
SCOTT        XEMP1                   7421212     518965   7        124   75,524

Tried shrink no effect on chained rows, just for the heck of it :-)

alter table xemp1 move;

Table altered.

SQL> select /*Chained rows*/ owner, table_name, num_rows, chain_cnt, (chain_cnt*100/num_rows) pct, empty_blocks, blocks
from dba_tables
where chain_cnt > 0
and owner not in ('SYS','SYSTEM')
/
  2    3    4    5
no rows selected   <=============target achieved.

/

--------------More later

Short Review LeEco Le 2 (Gold, 32 GB)

Awesome mobile LeEco Le 2 (Gold, 32 GB)

Long time evaluation of multiple smart phone culminated on buying LeEco Le 2 for my wife. Ordered via FlipKart  on 3rd Oct and got it on 5th October, mega sale event was going when ordered for a very good price. It replaced my wifes Moto G and BOY SHE is happy !!!!.

Pros:

* Nicely packaged.

* Prompt delivery.

* Very powerful configuration.

* Nice looks.

* Few weeks old now with all required apps. Performance still as good as new.

* Dual Sim.

Cons:

* No SD Slot.

* No audio port. Adapter provided though.

More later ....

LeEcho Le 2 on Flipkart

Short Review LeEco 138.8cm (55) Ultra HD (4K) Smart LED TV (L553L2, 3 x HDMI, 3 x USB)

Exceptional TV(UHD) for the price or even otherwise.

I pre-ordered the TV 6th Oct with delivery tentatively scheduled for 4th Nov.  On 26th find out, if ordered, I can get it next day. Called Flip-kart support to find out why pre-ordered TV cannot be delivered sooner. Since didn't get satisfactory response, cancelled and reordered.

To my amazement, next day got the TV and setup call came in few hrs setup was also completed. TO GOOD. Fully satisfied the transaction went thru.

Setup fairly intuitive, completed in few mins and the tv on Tatasky HD was up and running. Here's the full list of experiences:
Pros:
* TV is gorgeous.
* Wall mounted, though missing the yoga stand. No regrets.
* Live channels took a day to settle down, initially none were working. I guess prob needs some cache buildup time.
* Remote is really smart, typing is easy and convenient  in cursor mode.
* Picture quality is amazing for all HD channels, others as expected. TV handles up scaling fairly well.
*Movie playback via Levidi is perfect. No Hollywood content though.
* Screen is very bright. Using custom setting to personalize.

Cons:
* Not getting audio for live content via my Home Theater. Still need to figure that out. TV sound is satisfactory.
* Missing google play, tried alternate methods to install...no success so far.
* No Hollywood movies in levidi. Only Indian movies. OK for free. Free for 2yrs.
* Limited apps available. Not care much.


More later...