I have another simple one. How to make a long decode inside a function in oracle? My select looks like this:
I had a \'procedure A\' in which it has to return a null cursor to front end and then immediately it should continue with the next step in which it will call a procedure which will take 20 min to comp
I am new to pl/sql. can any one tell me how to callpl/sql function inside a trigger. I tired it but it gives an error when i try to run it.
How to query rows in a table where the created_date column value in the table fall开发者_StackOverflows on a weekend date ONLY, i.e. Saturday/Sunday using Oracle SQL..
I\'m getting my first experience with Oracle and TOAD (I know SSMS). I came across this \"%Type\" next to an input parameter in an update proc开发者_JS百科edure and I have no idea what it is or what i
This works: SELECT (CASE WHEN x = \'value\' THEN a.col1 ELSE nvl(a.col1, a.col2) END) FROM table1 a WHERE a.this = \'that\'
I\'d like to do something like this with PL/SQL: for ACCOUNT in account_cursor loop for related_data in (select something from table where some_column = ACCOUNT.column)
I have to load 46 tables with data using 开发者_如何学GoSQL Loader for Oracle. All the data files are CSV.
How do I apply IN parameter as my_email and OUT as my_salary in this procedure: CREATE OR REPLACE PROCEDURE FYI_CENTER AS
I have a table like this: UserIDCustomer ID status 111 121 131 142 151 163 172 281 292 ........ I want to summarize this table, to this:
加载中,请稍侯......