What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-16 16:30:05
oracle pipelined function
-- Return types CREATE TYPE t_tf_row AS OBJECT ( id NUMBER, description VARCHAR2(50) ); CREATE TYPE t_tf_tab IS TABLE OF t_tf_row; -- Build a pipelined table function. CREATE OR REPLACE FUNCTION get_tab_ptf (p_rows IN NUMBER) RETURN t_t... Add solution -
SQL 2022-01-27 19:17:15
oracle pipelined function return rowtype
-- Return types CREATE TYPE t_tf_row AS OBJECT ( id NUMBER, description VARCHAR2(50) ); CREATE TYPE t_tf_tab IS TABLE OF t_tf_row; -- Build a pipelined table function. CREATE OR REPLACE FUNCTION get_tab_ptf (p_rows IN NUMBER) RETURN t_t... Add solution -
SQL 2021-11-20 22:08:20
pipe row function in oracle example
-- Return types CREATE TYPE t_tf_row AS OBJECT ( id NUMBER, description VARCHAR2(50) ); CREATE TYPE t_tf_tab IS TABLE OF t_tf_row; -- Build a pipelined table function. CREATE OR REPLACE FUNCTION get_tab_ptf (p_rows IN NUMBER) RETURN t_t... Add solution -
SQL 2021-11-14 20:28:27
check psql validity function
CREATE OR REPLACE FUNCTION is_sql(sql text) returns boolean language plpgsql AS $$ DECLARE exception_message text; exception_context text; BEGIN BEGIN EXECUTE E'DO $IS_SQL$ BEGIN\nRETURN;\n' || trim(trailing E'; \r\n' from sql) || ... Add solution -
Javascript 2021-10-14 14:00:05
js remove dollar sign from string
A common problem with HTML input forms is that users tend to include dollars signs when inputting currency numbers. These dollars signs can be easily removed through JavaScript by using the JavaScript replace function and a simple regular expression. This... Add solution
Best helpers
Ranking is empty