Forum

Notifications

Clear all

Interview Questions & Answers

Please post all Oracle interview Questions & Answers Here.

Author Name

Author Email

Topic Title *

Subscribe to this topic

I have read and agree to SQL Queries privacy policy.

Preview 0 Revisions Saved

Page 1 / 2 Next

Status

Topics

Replies

Views

Users

Date

What is Oracle Cloud ? What are the advantages of Oracle Cloud?

1

115

<img alt="Hari Priya" alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=40&r=g&d=mm 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="jeevan 123" alt='' src='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

May 29

May 29

Can we join view with table in oracle?

Topic Tags: joinviewwithtable,

3

346

<img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' src='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="KV Kumar" alt='' src='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-24 photo' height='24' width='24' />

May 14

May 14

SQL Query to Find the day name of 2021 new year day from Sysdate?

Topic Tags: nameof2021, newyearday, fromsysdate,

2

771

<img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' src='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="Mahesh Karpe" alt='' src='https://secure.gravatar.com/avatar/6648bf98edf28e393d56a127881267e8?s=24&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/6648bf98edf28e393d56a127881267e8?s=48&d=mm&r=g 2x' class='avatar avatar-24 photo' height='24' width='24' />

Oct 01

Oct 01

How to find only non matching records from both tables?

Topic Tags: nonmatchingrecordstwotabl, nonmatchingrowsoracle,

2

416

<img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' src='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="Siva Kumar" alt='' data-srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm 2x' height='24' width='24' data-src="//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Siva Kumar" alt='' src='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm' srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm 2x' class='avatar avatar-24 photo' height='24' width='24' />

Sep 04, 20

Sep 04, 20

Find last name of all employees from a full name column?

Topic Tags: lastnameofallemployees, fullnamecolumn, findlastname,

1

153

<img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' src='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="Hari Priya" alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=24&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=24&r=g&d=mm 2x' class='avatar avatar-24 photo' height='24' width='24' />

Jul 30, 20

Jul 30, 20

How to find profit percent from sale amount & purchase amount?

Topic Tags: profitpercentquery, salesamount, oraclesqlprofitquery, profit%,

1

148

<img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' data-srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' height='40' width='40' data-src="https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="avatar avatar-40 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="KV Kumar" alt='' src='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg' srcset='https://secureservercdn.net/198.71.233.37/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg 2x' class='avatar avatar-40 photo' height='40' width='40' />

<img alt="Siva Kumar" alt='' data-srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm 2x' height='24' width='24' data-src="//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm" class="avatar avatar-24 photo lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Siva Kumar" alt='' src='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm' srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=24&r=g&d=mm 2x' class='avatar avatar-24 photo' height='24' width='24' />

Jul 30, 20

Jul 30, 20

Page 1 / 2 Next

Share:

Forum Statistics

8 Forums

107 Topics

233 Posts

0 Online

1,280 Members

Latest Post: Create a PL/SQL Trigger to display the message "Re-Order Level reached for the item-item name" Our newest member: Cnukboync Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo version 1.9.9