#Interview questions for oracle sql developer code

Cell Mobile Smart Phone Radiation Checking Code.EEE Electrical Electronics Companies List in Hyder.ECE Electronics communication Companies List in Hy.Java Programs Most Frequently Asked In Adobe Syste.Sitel Most Frequently Asked Core Java Interview Qu.Apple Most Frequently Asked Latest PHP Interview Q.Oracle SQL Queries Most Frequently Asked In Adobe.

#Interview questions for oracle sql developer how to

How to Find Longest Substring Without Repeating Ch.How To Find Two Lines With Max Characters In Desce.How to Convert String to Number Without Using Inte.Write a Java program that prints all the values gi.Write a Java program to count the number of words.Write a Java Program to Get Distinct Word List Fro.How to Get Distinct Elements From An Array By Avoi.Write a Java Program to Implement Hashcode and Equals.Major Reasons Why Scala Is Better Than Java Progra.Deloitte Recent JAVA Interview Questions And Answers.

#Interview questions for oracle sql developer software

Eclipse Software Technical Interview Questions And.

Dojo Interview Questions And Answers For Freshers.

Infosys Recently Asked Java Technical Interview Qu.

Java Programs Recently Asked In Daum Written Test.

Java Programs Recently Asked In Mindtree Written T.

But this query is more efficient given the fact that we are only interested in knowing if table has any data. You can create count(*) on a table to know number of rows. This one can be written in multiple ways.

SELECT ROUND (DBMS_RANDOM.VALUE () * 100) + 1 AS random_num FROM DUAL generate random number between 0 and 100 Change the multiplier to number that you want to set limit for. This ones generate a random number between 0 and 100.

#Interview questions for oracle sql developer generator

Plain old random number generator in Oracle. You might want to generate some random data to quickly insert in table for testing.

#Interview questions for oracle sql developer mod

More info: Row Data Multiplication In OracleĪS (SELECT CASE MOD (COUNT (*), 2) WHEN 0 THEN 1 ELSE -1 END val This query use some tricky math functions to multiply values from each row. WHERE ROWNUM < (SELECT COUNT (*) FROM employees) WHERE ROWID IN (SELECT MAX (ROWID) FROM employees) Use this when your table does not have primary key or you cannot be sure if record having max primary key is the latest one. SELECT REGEXP_SUBSTR (csv.csvdata, '+', 1, LEVEL) pivot_charĬONNECT BY REGEXP_SUBSTR (csv.csvdata,'+', 1, LEVEL) IS NOT NULL Once you have this table you can join it with other table to quickly do some useful stuffs. Here we are converting ‘AA,BB,CC,DD,EE,FF’ string to table containing AA, BB, CC etc. The query can come quite handy when you have comma separated data string that you need to convert into table so that you can use other SQL queries like IN or NOT IN. SELECT SUM (bytes) / 1024 / 1024 / 1024 AS GB FROM dba_segments Ĭonvert Comma Separated Values into Table Gives the size occupied by data in this database. SELECT SUM (bytes) / 1024 / 1024 / 1024 AS GB FROM dba_data_files įind the size occupied by Data in a Database or Database usage details Yet another query to increase the datafile size of a given datafile.ĪLTER DATABASE DATAFILE '/u01/app/Test_data_01.dbf' RESIZE 2G SELECT tablespace_name, AUTOEXTENSIBLE FROM dba_data_files ĪLTER TABLESPACE data01 ADD DATAFILE '/work/oradata/STARTST/data01.dbf' SELECT SUBSTR (file_name, 1, 50), AUTOEXTENSIBLE FROM dba_data_files Query to check if autoextend is on or off for a given tablespace. Yet another DDL query to resize table space.ĪLTER DATABASE DATAFILE '/work/oradata/STARTST/STAR02D.dbf' resize 2000M Ĭhecking autoextend on/off for Tablespaces Resizing Tablespace without adding datafile ValueLabs Frequently Asked Oracle SQL Queries In Written Test Interview Questions Now in such cases, you might want to make your index case insensitive so that they don’t occupy more space. In your query you might do UPPER(.) = UPPER(.) on both sides to make it case insensitive. Sometime you might querying database on some value independent of case. Store data case sensitive but to index it case insensitive Display the character set information of database.