Forums
 
Notifications
Clear all

SQL Queries Forum
Unread Posts  |  Forums  |  Topics

SQL
Forums
Status
Topics
Forum
Replies
Views
Users
Date 
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.
  Other Documents
1
319
Rahul Updhyay
John
Nov 15
Nov 15
What are the commonly used SQL Queries on Employee Table?
Topic Tags:  sqlusigemployeetabl, eemployeetablesqlexample, employeedatasql, samplesqlemployeetable, simplesqlexamples,
  Interview Questions & Answers
2
196
Ganeshan Kumaran
John
Sep 27
Sep 27
Create View Mysql: Can you help me to create these views using employee table as reference?
Topic Tags:  createviewmysql,
  Other Documents
2
137
Saba Ot
John
Sep 26
Sep 26
Load More Topics
PL SQL
Forums
Status
Topics
Forum
Replies
Views
Users
Date 
How to achieve this complex scenario using PLSQL Procedure?
Topic Tags:  taskstatus, complexplsqlprocedure, plsqlinterview,
  Interview Questions & Answers
2
129
John
kumar BI
Sep 15
Sep 15
Can you explain little advance topics related plsql like varray nested table bulk collection
Topic Tags:  plsqladvacedtopics, varrynestedtable, bulkcollection,
  Interview Questions & Answers
0
117
V Cruz
Aug 18
Aug 18
Write a PL/SQL procedure to perform withdraw operation that only permits a withdrawal, if there is sufficient funds in the account then update the Account table and print the message, 'Transaction successful.' else print, 'Insufficient Amount'. T...
Topic Tags:  withdrawamountprocedure,
  Interview Questions & Answers
2
297
Rahul U
Rahul Updhyay
Aug 09
Aug 09
Load More Topics
Oracle
Forums
Status
Topics
Forum
Replies
Views
Users
Date 
Find the day name of 2021 new year day from sysdate?
Topic Tags:  nameof2021, newyearday, fromsysdate,
  Interview Questions & Answers
2
116
vinodkrsetty
Mahesh Karpe
Oct 01
Oct 01
Can we join view with table in oracle?
Topic Tags:  joinviewwithtable,
  Interview Questions & Answers
2
91
vinodkrsetty
VK
Sep 17
Sep 17
How to find only non matching records from both tables?
Topic Tags:  nonmatchingrecordstwotabl, nonmatchingrowsoracle,
  Interview Questions & Answers
2
144
vinodkrsetty
Ganeshan Kumaran
Sep 03
Sep 03
Load More Topics
Data Warehousing & ERD
Forums
Status
Topics
Forum
Replies
Views
Users
Date 
What is the best ETL tool? What are the important features of ETL tools?
Topic Tags:  etltool, bestetltool, etltoolfeatures, etltoolfunctions,
  Other
4
241
Ganeshan Kumaran
Sharavanan
Nov 08
Nov 08
What is slowly changing dimensions in data warehousing?
Topic Tags:  slowlychangingdimensions, datawarehouseslowlychang,
  Interview Questions & Answers
2
86
kumar BI
Deepika A
Sep 26
Sep 26
What is normalization in dbms?
Topic Tags:  normalizationindbms, normalization,
  Interview Questions & Answers
1
83
Saba Ot
VK
Sep 17
Sep 17
Load More Topics
Share: