Forum

Notifications

Clear all

Other Documents

Author Name

Author Email

Topic Title *

Attach file:

Maximum allowed file size is 10MB

Topic Tags (Separate tags using a comma)

Subscribe to this topic

Preview 0 Revisions Saved

Page 2 / 4 Prev Next

Status

Topics

Replies

Views

Users

Date

Create a PL/SQL Package with Procedure in it. Procedure will take designation and incentive as input and update the employee salary by adding the incentive for the given designation. Display the number of employee records that have got updated, e.g....

2

321

<img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" />

Sep 05

Sep 05

Create a PL/SQL Procedure to insert employee details into Employee table.

1

269

<img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" />

Sep 01

Sep 01

Can anyone help me to rewrite this query? It works well with MySQL but not in snowflake db

Topic Tags: mysqlquery, snowflakedb, errormysql,

1

214

Aug 27

Aug 27

Create a procedure that deletes rows from the Employee table. It should accept 1 parameter, department name; only delete the employee records belonging to that department. Display how many employees were deleted else raise "DeptNotFoundException" a...

0

101

<img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" />

Aug 23

Aug 23

write a query to display the booking and the payment made by guest. Display guest name, resort name, from date , to date , adult count, child count, and total charges made by guest. Sort the output in the ascending order of guestid.

1

61

<img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" />

<img alt="Deepak Raj" alt='' src='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=24&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=48&d=mm&r=g 2x' class='avatar avatar-24 photo' height='24' width='24' loading='lazy'/>

Aug 23

Aug 23

Write a query to display the guestid and guest name who has charged highest amount in the resort. sort the output on the guestid

1

90

<img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" data-src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img alt="Rahul Updhyay" src="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" class="gravatar avatar avatar-40 um-avatar um-avatar-default" width="40" height="40" alt="Rahul Updhyay" data-default="https://secureservercdn.net/198.71.233.106/9xz.ac2.myftpupload.com/wp-content/plugins/ultimate-member/assets/img/default_avatar.jpg" onerror="if ( ! this.getAttribute('data-load-error') ){ this.setAttribute('data-load-error', '1');this.setAttribute('src', this.getAttribute('data-default'));}" />

<img alt="Deepak Raj" alt='' src='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=24&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/d66d20af45d670466598417314d29f90?s=48&d=mm&r=g 2x' class='avatar avatar-24 photo' height='24' width='24' loading='lazy'/>

Aug 21

Aug 21

Page 2 / 4 Prev Next

Share:

Forum Statistics

8 Forums

95 Topics

201 Posts

0 Online

78 Members

Latest Post: Create a PL/SQL Function to calculate increment for the employees. Function will take increment percentage and salary as input and return increment amount as output. Our newest member: dayanaaustin 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.3