Author Archives: trilochannayak

Recover USB Drive datas that are infected by the shortcut virus

In the command prompt of windows need to type below command and then run ATTRIB -H -R -S /S /D “G:\Mintu Docs” where “G” is the USB drive name and “Mintu Docs is the folder name You can able to see all the USB datas are back.EnjoyJ   Advertisements

Nexus Media Importer Problem Resolution Steps

If Nexus Media Importer is not working in Nexus Tablet follow below steps. 1.Install Nexus Media Importer or Nexus Photo Viewer 2.Under Security -> Lock Screen. Select None 3.Under Accessibility -> Auto-rotate screen. Make sure it is NOT checked 4.Under Language and input -> English (United States),[this step is very important! OTG function will not […]

Grant Oracle user to access oracle table

We can grant all oracle objects from one user to another user by below package CREATE OR REPLACE PROCEDURE GRANT_ORACLE_TABLES(FROM_USER VARCHAR2,TO_USER VARCHAR2) IS BEGIN FOR tab IN (SELECT table_name FROM   all_tables WHERE  owner = FROM_USER) LOOP EXECUTE IMMEDIATE ‘GRANT ALL ON ‘||tab.table_name||’ TO ‘||TO_USER; END LOOP; END; If you want to grant only one objects […]

My first Oracle cloud application using oracle cloud trail account

I have tested Oracle cloud application using oracle cloud trail account.Steps are given below 1.go to https://cloud.oracle.com/, login with your OTN account and request a trial period.need credit card for verification, but it will not get charged. 2.Download Oracle SQL Developer from below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 3.To start SQL Developer, run sqldeveloper.exe. 4.Log in to APEX. Once […]

Some Tips on Oracle Table space and Users

–List all users/schema SELECT DISTINCT USERNAME FROM DBA_USERS; SELECT * FROM DBA_USERS; –List ONLY your tables SELECT * FROM CAT; SELECT * FROM TAB; –List the Oracle Tablespaces SELECT * from v$TABLESPACE; –See your TABLESPACE SELECT * FROM ALL_TABLES WHERE TABLE_NAME = ‘BL_SESSION_EVENT_HIST’; SELECT TABLE_NAME, TABLESPACE_NAME, STATUS FROM USER_TABLES; –find table space of all tables […]

Configure MS SQL SERVER,MY SQL,MS ACCESS to run from Oracle SQL Developer

We can execute MS SQL SERVER,MY SQL,MS ACCESS from Oracle SQL Developer.Steps are given below 1.download Oracle SQL Developer from below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2.Oracle connection We can connect oracle by Host Name,Port and SID or by TNS details.                     3.MY SQL Server connection a.need to download […]

Random numbers using oracle query

create 10 random numbers between 1 and 99 using below query SELECT R FROM (SELECT R FROM (SELECT ROWNUM R FROM ALL_OBJECTS WHERE ROWNUM < 100) ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM <= 10;