I have the table below: ID |ST开发者_JAVA技巧ART|END A| 11/2/2011 10:00 | 13/2/11 10:00 A| 15/2/2011 10:00 | 16/2/11 10:00
I am creating a function, logged in as sys. CREATE FUNCTION Core.Get_Contact_Code ( First_Name IN NVARCHAR2,
I have an error at this function. I have no idea why 开发者_如何学Cit doesn\'t work. Can you help me please?
I am trying to implement (OpenId+OAuth) hybrid protocol using PL/SQL. I have setup OpenID Authentication successfully with google for my site http://example.com where the user is directed to google ac
I\'m trying for days to disable the constraints of all my tables, insert data and enable the constraints. It works but I did some tests and when I insert a row that doesnt respect a foreign key, there
I\'m new to PL-SQL, and struggling to find clear documentation of operations are nested tables.Please correct any misused terminology etc.
I am working on an report for which am calling a function from front end. I am getting start month information as numbers starting from 1 to 12 and so am usin开发者_如何学Gog
We have a table which has three columns in it: Customer_name, Age_range, Number_of_people. 1开发者_如何学Go1-510
I have a stored proc. where i am passing a boolean value e.g. IS_ELIGIBLE. Now i want to be able to write query something like this:
How do I add a simple check before adding a column to a table for 开发者_JAVA技巧an oracle db? I\'ve included the SQL that I\'m using to add the column.
加载中,请稍侯......