PL/SQL fill variable with if-condition value -

-

I am trying to fill a variable in PL / SQL such as if-condition value:

< P v_variable: = if (4> 3) then 'a' bse 'b' and;

But that does not work.

Is there any option to do this? Instead of doing so, a if , I

go with: 
  v_variable: = when the 4> 3 then 'A' and 'B' end;

Comments

Post a Comment

Popular posts from this blog

sql - Postgresql record to array -

-
I need to change back into an array to change lines from the array and filter the records. I am using info_schema._pg_expandarray in a SELECT query to get a line copy value in the array. Looking at the following array: "four" [] {i, i, o, t, b} _pg_expandarray leaves 5 rows with 1 row type record: records (I, 1) (i, 2) (o, 3) (t, 4) I have to filter this result set 't' to exclude record records. How can I do this? Should I convert back to the array? What is a way to filter the array directly? Thanks in advance. If your purpose is to create one set of the above rows, but remove the 't' in the line So, this is the trick: test => Information (i), 'o', 't', 'b' i. N --- --- --- i | 1 mother 2 o | 3b 5 (4 lines) As a side, unless you specifically want to return the index as a second column, then I unnest () information_schema._pg_expandarray () , which does not appear in the document and is probably...
Read more

c++ - Cmake produces file extensions in static library archives -

-
I have recently switched to autotools to cement, since the limiter cross platform is better for development and what I saw When I build a stable library of my C ++ code, all the files inside .cpp.o is a suffix ar income tax PA8 / libgenericTZR.a genericTZR.cpp.o I have seen other libraries made by other tools and they do not do it, I'm not sure this is the realm And there is a bad thing, but how can I create static libraries without cpp file extension? This is my CMake file add_executable (PA8 ISP_Charges.cpp genericTZR.cpp genericTZR.h) set (LIBSRC genericTZR.c genericTZR.h) add_library (genericTZR shared $ {LIBSRC}) add_library (genericTZR shared $$ TARGET_OBJECTS: myObjects & gt;) install add_library (Generic TZR-static static $ {LIBSRC}) set_target_properties (Generic TZR-Static Properties OUTPUT_NAME $ install (TARGETS PA8 DESTINATION BIN) TARGETS GENICTZR GENERICTZR-STATIC DESTINATION lib) Installed (files "$ {PROJECT_BINARY_DIR} /PA8/genericTZR.h...
Read more

java - Clearing application data programatically android -

-
I have an app with SharedPreferences. I clicked on a button to clear the complete apps data so that the application started as a fresh reason when it was first installed. I have tried: - ClearData.java expanded public class ClearData application {Private Static ClearData example; @ Override Public Empty on Create () {Super. Connet (); Example = this; } Public Fixed ClearData getInstance () {return example; } Public Zero Clear Display Data () {file cache = would match (); File apiar = new file (cache.getpartent ()); If (appDir.exists ()) {string [] children = appDir.list (); For (strings: children) {if (! S.equals ("lib")) {deleteDir (new file (appDir, s)); Log.i ( "tag", "**************** delete the file / data / data / Mypackage /" + s + "given ******** *** ******** "); }}}} Public static Boolean deleteDir (file dir) {if (dir = Null & amp; amp;; dir.isDirectory ()) {String [] children = dir.list (); For (; i & lt; i = 0 int ch...
Read more