create or replace procedure create_src_table() returns table (name varchar, age number(10,0),dob date) language sql as $$ declare create_query varchar; res resultset; begin create_query := `CREATE TEMPORARY TABLE SRC_TEMP_TBL AS SELECT * FROM (WITH CTE_1 AS (SELECT * FROM "DB"."DW"."USER_TBL" WHERE name=’rahul’), CTE_2 AS (SELECT * FROM CTE_1 WHERE CAST(DOB AS DATE)<2000-05-01) SELECT name,age,dob FROM CTE_2 […]
Tag: Recent Questions – Stack Overflow
Successfully Hosted Nodejs app on render not responding
I have a nodejs app which uses handlebars as templating engine, the app run perfectly fine with no errors on development, and also after hosting it on render the renter’s console show status for successful deployment and it’s live right now. But the problem is that when ever I make request the site it never […]