I am a Java developer with limited knowledge of Oracle PL/SQL. Please let me know how to pass an array to a PL/SQL function in the following example and how to invoke it.
Good Afternoon, I\'m starting in the world of Qt and a Firebird database.And finish the driver installation process and perform operations onthe database insert, update and consultation.
i just want to know that, there is any way through which i can Compare a column value with Some String value.Something like this...
I am rather new at PL/SQL (esp. using Dynamic SQL), I created this function, and it r开发者_Python百科uns/compiles without any errors or warnings, but when I run the function....
I have the trigger: create or replace TRIGGER JACKET_DELETE BEFORE DELETE ON JACKET FOR EACH ROW BEGIN DELETE FROM PORT
I have two select statements that look like this SELECT DISTINCT(NAME, PHONE_NUMBER) FROM PHONE_CALLS GROUP BY NAME, PHONE_NUMBER;
I ha开发者_开发知识库ve a stored procedure create or replace procedure Trial is Begin ---Block A--
I\'m querying the DB and need to parse one of the fields for spe开发者_Python百科cific values (using string functions). So I figured it\'d be best to write a function for it. I\'ve never written a fun
I need to convert a rich formatted text of a VARCHAR2 field to plain text. For example: {\\rtf1\\ansi\\ansicpg1252\\deff0{\\fonttbl{\\f0\\fnil Tahoma;}{\\f1\\fnil\\fcharset0 Tahoma;}}
I have a query that 开发者_Python百科uses a difference between two dates in order to find the duration used somewhere else in the query\'
加载中,请稍侯......