Vamsikrishna Sudanagunta

• Nov 16th, 2022

Print first names and the last names of the artists who had zero sales or no sales?

Ekansh

• Jul 12th, 2022

Just add the ; in the end of quest :)

Answer Question  Select Best Answer

VIJAI VEDHA

• Sep 28th, 2022

ITS syn NOT sys,

SuryaRS

 Profile Answers by SuryaRS Questions by SuryaRS

• Aug 29th, 2017

TAB will give tables, views whereas CAT will give tables, views, sequences. TAB is having clustered column.

Code
 

Answer Question  Select Best Answer

How do I reverse a string using only Oracle SQL without using the reverse function??

rishitha

• Jan 5th, 2022

Then how can we make this into the loop to retrive for N no.of observations

Siva Kumar S

• Apr 7th, 2012

I just took employees tables last_name. See the code.

Code
span style="color: #ff0000;">"Reversing Name"

Answer Question  Select Best Answer

Construct a query which finds the job with the highest average salary

Shubham kumar

• Oct 21st, 2021

Hope, This Will Help

Code
 

taaznyonker

 Profile Answers by taaznyonker Questions by taaznyonker

• Mar 31st, 2010

If you want to get only highest average salary of particular dept, then you can use SELECT MAX(AVG(sal)) FROM emp GROUP BY deptno and if want the dept number too, with the average sal, then query ould...

Answer Question  Select Best Answer

EMP table (empno,deptno,sal)
DEPT table(deptno,dname)

i need Deptno, Dname, 2nd_highest_sal_in_dept
in output.

I can easily do this using row_number, Rank,Dense_rank etc but I am unable to do this using Group By.
Please suggest if this can be done using Group By.

bibek

• Jul 2nd, 2021

This is nice and simple way to solve.. thank you

kishanjha

 Profile Answers by kishanjha Questions by kishanjha

• May 20th, 2017

Code
 

Answer Question  Select Best Answer

May

• Apr 28th, 2021

It clearly mentioned "without using group by".

fire_starter

 Profile Answers by fire_starter Questions by fire_starter

• Oct 9th, 2011

You can use union A union result will eliminate the duplicate rows ( for info, if one wants the duplicate rows preserved, that the UNION ALL should be used). For example we have a table called test_...

Answer Question  Select Best Answer

Employee table has : Emp.Name, Emp.ID, Dep.ID & Location ID
Department Table has: Dep.ID, Dep. Name
Location table has: Location ID & Location Pincode

Need to find the list of employees who is from Finance department having 1200 pincode

sanjiwani

• Sep 8th, 2020

SELECT Emp.name, Dep.Name, Location Pincode FROM Employee JOIN Department on Dep.ID.Employee = Dep.ID.Department JOIN Location on employee.Location ID= Location.Location ID where Dep....

Answer Question  Select Best Answer

LONG RAW data type is used for storing BLOB's (binary large objects).

Shankha

• Apr 17th, 2020

I greatly appreciate you for coming to this guide on datatype is used to store picture can be uploaded and retrieved. Yet I would discourage this store picture in a database because traditional ...

goyal_tarun

• May 3rd, 2007

Hi,BLOB is generally used to store pictures. It stands for Binary Large Object. The maximum storage limit is 4GB. There is also one limitation using BLOB, you can have only one column of type BLOB.Cheers,Tarun

Answer Question  Select Best Answer

sanjay mehra

• Apr 3rd, 2020

Not possible

prerrak_pandya

• Mar 6th, 2020

Thank_you, its really worked!
its make my day,
something awesome new to learn

Answer Question  Select Best Answer

Anil Kumar

• Dec 11th, 2019

We can use listtag for such scenario.

Code
 

Answer Question  Select Best Answer

Is there any datatype in oracle to check whether a inserting value is at least a numeric and a character?

Rajiv

• Jul 17th, 2019

We can use regular expression such as REGEXP [A-Za-z0-9] in order to validate a column,which takes only number and charcater value.

Answer Question  Select Best Answer

How to display middle record in a given table?

Bibhudatta Panda

• Jun 18th, 2019

Suppose I want middle record 5-9 records

Code
 

shreyas varchasvi

• Oct 15th, 2018

In rownum we cant use >= operator, only < ,< = operator will work.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Mohan

• Jun 2nd, 2006

---

Hi,

Advantages of views:

1. View the data without storing the data into the object.

2. Restict the view of a table i.e. can hide some of columns in the tables.

3. Join two or more tables and show it as one object to user.

4. Restict the access of a table so that nobody can insert the rows into the table.

Disadvatages:

1. Can not?use DML operations on this.

2. When table is dropped view becomes inactive.. it depends on the table objects.

3. It is an object, so it occupies space.

Pls. add , if I miss any of them.

Thanks,

Mohan

Raj

• Mar 7th, 2019

These are following some advantages
1. Performance
2. Security
3. Easy and Reusable
4. Consistency and independent

Marcus

• Apr 6th, 2018

The view uses virtual space when in use, this is a temporary space on the server that goes away when not in use.

Improve Answer

Rupesh

• Dec 27th, 2018

IIF(cond as expression, expr1 as expression, [expr2 as expression])

Returns the value of expr1 if the cond is true or the value of expr2 if the cond is false.

In your case, If (condition) date IS NULL (returns true) then 0 (expr1)
else to_char(date,yyyy-mm) (expr2)

RAGHU

• Jun 29th, 2006

iif=immediate ifiif(isnull(date,0,to_char(date,'yyyy-mm'))if date is not null then 0 else to_char(date,'yyyy-mm');AS SIMPLE AS IT

Answer Question  Select Best Answer

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Nov 28th, 2018

Handling NULL values: NULL: It is a value which is Unavailable / Unassigned / Unknown / Inapplicable. A NULL is not the same as "Zero" or a "Blank space". If a row lacks the data for a particular co...

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Jul 18th, 2007

NVL is a built in function provided by oracle which accepts two parameters. NVL function returns the first parameter if the first parameter is not null  and it returns the second parameter if the...

Answer Question  Select Best Answer

Suresh Babu Nallamothu

• Nov 8th, 2018

No,Because only one primary key is available for the one table. If you want to use morethan one primary key in a table,it is called as composite primary key.

Code
 

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Sep 23rd, 2011

Yes, a primary key can contain more than one one column. Per EF Cobb's definition, a primary key is the sole candidate key on a relation variable (table) formed from one or more attribute values (c...

Answer Question  Select Best Answer

A view is stored procedure based on one or more tables, it’s a virtual table.

Suresh Babu Nallamothu

• Nov 8th, 2018

A view is a virtual table,Because it doesn't have its own data and it doesn't occupy the database memory.

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• Apr 30th, 2010

A view is a mirror image of one or more table. View provides data access privilages.

Answer Question  Select Best Answer

Mohammad salman

• Sep 29th, 2018

Its not working,,,,
error is that


Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword As.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Create table emp as select * from student where 1=2;

Answer Question  Select Best Answer

Dheeraj Singh

• Sep 16th, 2018

You can try this one.I think this query can work..

Select * from tbl_regex Where REGEXP_LIKE(ENAME,^0123456789);

Note:- tbl_regex is table name and ENAME is column name that contain numeric and string type data.

Asish

• Jan 7th, 2018

Here the where clause will be either

Lower(fn) = upper(fn)

Or

Regexp_like(fn, ^[0-9]*$)

Answer Question  Select Best Answer

Bobby

• Apr 18th, 2018

Rowid is pseudo column and it can change internally especially on transactional table

himabindu

• Apr 16th, 2018

Why use rownum < 2?

Answer Question  Select Best Answer