|
|
-
lostformars Learned 6 Months ago through Just Learned
Heard of Space function?
It returns a string of repeated spaces.
Syntax:
SPACE ( integer_expression )
integer_expression : Is a positive integer that indicates the number of spaces. If integer_expression is negative, a null string is returned....
|
-
lostformars Liked 6 Months ago through Just Learned
Heard of Space function?
It returns a string of repeated spaces.
Syntax:
SPACE ( integer_expression )
integer_expression : Is a positive integer that indicates the number of spaces. If integer_expression is negative, a null string is returned....
|
-
lostformars Liked 6 Months ago through Just Learned
Heard of Space function?
It returns a string of repeated spaces.
Syntax:
SPACE ( integer_expression )
integer_expression : Is a positive integer that indicates the number of spaces. If integer_expression is negative, a null string is returned.
|
-
This challenge is about finding second highest salary for each department...
|
-
My solution was very similar to another submitted solution. However, I really prefer CTEs over sub queries. Another benefit is Oracle's sub query factoring (not in use here), which will usually be more efficient (but not always!)....
|
-
This challenge involves assigning food packets to birds from two different baskets. Your job is to read the input table and produce the required result set using a single PLSQL query....
|
-
I realize this is late. I just found the PLSQL challenges. But, my solution was different from others that I found already submitted. CTEs make the query more readable. I saw some uses of Dense_Rank to join fruits and grains but this would not work prop...
|
|
|
|
|