function - Comparison between my day in table and the sysdate in server -


i'm trying write function return day_id after comparing current day name on server , day name on table contents

**my code is

 create or replace   function getsysdate  return char    v_day char(20) ;  v_day_id days.day_id%type ;  v_day_name days.day_name%type ;  begin  select day_id, to_char(sysdate, 'day', 'nls_date_language=arabic'), day_name  v_day_id,v_day,v_day_name  days  v_day_name = v_day ;  return v_day_id ;  end;

but unfortunately,it's no data found !

note ! : datatype of day_name varchar (20 byte)

**the error  connecting database admin.  ora-01403: no data found  ora-06512: @ "admin.getsysdate", line 9  ora-06512: @ line 5  process exited.  disconnecting database admin.  ** table   day_id number  day_name   varchar2(20 byte)

your filter using local variables have not been initialised; in fact you're trying set them , use them filter @ same time, doesn't make sense.

where v_day_name = v_day

... never going match records table.

i think want:

create or replace function getsysdate return days.day_id%type   v_day_id days.day_id%type; begin   select day_id   v_day_id   days   day_name = to_char(sysdate, 'day', 'nls_date_language=arabic');   return v_day_id; end; /

i don't know how days table populated, i'm guessing day_id 1-7 , day_name corresponding day, , in region can't simple to_char. this sql fiddle shows function based on assumption, ids in wrong order. i've shown both assignment in anonymous block, , used plain sql.


Comments

Post a Comment

Popular posts from this blog

How to mention the localhost in android -

i trying call localhost in android application. unfortunately not possible used several methods emulator local host http://10.0.2.2/android/dbconnection.php and network ip address http://192.168.1.xx/android/dbconnection.php also http://localhost:8080/android/dbconnection.php but nothing connected localhost. purpose refer stackoverflow answers not working i facing same problem when worked on localhost. referred stackoverflow answer got solution create new emulator works fine in new emulator.
Read more

php - Calling a template part from a post -

i include iframe within post in wordpress. located inside content of post, meaning cannot in post template file, otherwise either before or after. i'd add facebook plugin within posts: <div id="socialwrap"><div class="fb-like" data-href="http://onlinearizonahomes.info" data-send="true" data-width="450" data-show-faces="true" data-font="arial"></div></div> i thinking of calling template part within post <?php get_template_part( 'social' ); ?> cannot use php within post without plugin (i'd avoid using plugin this). an alternative using javascript create html in post, seems unnecessary use of javascript. what best way add html within wordpress post? you can use shortcode. add functions.php function cudjex_fbshare( $atts, $content = null ) { global $post; $link = get_permalink($post->id); return '<div id="socialwrap...
Read more

c# - String.format() DateTime With Arabic culture -

check below code snippet, namespace testdateconvertion { class program { static void main(string[] args) { datetime testvalue = new datetime(2013, 12, 15, 15, 33, 44); cultureinfo culture = new cultureinfo("ar-sa"); string stringvalue = string.format(culture, "{0:d} {0:hh:mm:ss}", testvalue); console.writeline(stringvalue); console.readline(); } } } it gives output 22/02/35 15:33:44 i not getting how possible. whats 35 doing in output there that's 13/12/2015 in hijri, 35 means 1435 in hijri, default date format saudi arabia.
Read more