Oracle sql practice exercise with solution | SQL query to print string in row of characters |PYRAMID

SQL Practical Interview question
Oracle sql practice exercise with solution
SQL questions for data analysis
SQL scenario based interview questions

[antonyjayaraj]

Thank you siva academy. I was searching for this topic only. I hope your channel will be helpful for me to update myself. Thank you. Subscribed your channel.

[kamalb]

Hi Siva,
How to write a stored procedure to insert bulk records based on conditions, if I will get any error I have to store into log table but these error data I have to commit. If I will get any errors only base table I have to rollback else I have to commit.

[nntrainingandplacementsolu]

Dear Siva, request you to please try to put script in description. Superb video brother.

[ramchinthakayala]

I hope your videos are helpful for my upcoming interview.

[lifeisgreat]

Hi Siva, I am kinda new to the sql, my concern is according to this example, you compose like query1 comma query2 connect by... what is such querying? parallel or something?

[somiyasaxena]

Hello Sir, I appreciate your work, it's not easy to learn SQL on its own without such online videos. I subscribe and also like your videos, but in this case, (I'm learning SQL on my own) in apex oracle, I'm not able to use the syntaxes that you are using. Like, 'output1' is not reading by the database, and I couldn't know anything except 'group by' instead of 'connect by level'. And in the end, I got row number but with 'w' only. I was learning 'substr' and i used it correctly what you were wrote, but still its having a problem:(

[sujaa]

It was very helpful Siva, thank you very much, hope to see more videos.
Regards,
Sujaa

[sairamsubramaniam]

This is great. Bro do you have a repository for all these queries, It will be useful for us.

[pratikbhatkar]

Hi, Can you do a video on Pragma Inline and subprogram inlining. I am not able to find a good tutorial on that

[Ganeshay-]

Very fun with new learn.. Fabulous sir

[HM]

why my query is not running it is showing error as incorrect syntax near the keyword ''by"... please help

[littlekidscartoonplanet]

hi sir, how can i print my name pl sql and replace them with stars.

[RoshiVarshi]

In my laptop connect by option gets error

[jeevadharmaraj]

Hi sir,
How to write a query to get this output

Welcome
Welcom
Welco
Welc
Wel
We
W

[Im_aviik]

Tried using WITH clause
with t as (
SELECT 'WELCOME' c FROM DUAL)
select SUBSTR(c, rownum, 1) col1, SUBSTR(c, (-1)*rownum, 1) col2, SUBSTR(c, 1, rownum) col3, SUBSTR(c, rownum) col4, LPAD(SUBSTR('WELCOME', rownum), length(c), ' ') col5,
LPAD(' ', length(c)+1-rownum, ' ')|| SUBSTR(c, 1, rownum) col6 from t
connect by level <=length(c);

[gautamtrivedi]

Hi shiva,

Can we get the output like this
W
E
L
C
O
M
E
without connect by