ROWNUM sql Fonksiyonu bir grid ,repeater veya tabloda listeleme yapmak istiyorsak ve bu çekilen verinin ID de sıralamsını sağlar, SELECT TO_CHAR(ROWNUM) AS SIRA
Decode Sql Fonksiyon
Decode fonksiyonu veri tabanımızdaki bilgilerin belirli şartlara uyup uymadığını bulabiliriz. Örneğin DECODE(PERSONEL_LISTESI,1,’Müdür’,2,’GenelMüdür’,3,’ARGE ‘)AS PERSONEL,
NVL Sql
Hello , NVL Sql query today I will press the form of use, After the Select variable Texbox if the field for that ID is empty in that table in […]
Length of SQL query
(Turkish) Lenght SQL sorgu
Disting sql
Disting it allows us to draw the data that repeats in the table as one. SELECT DISTINCT column1, column2, … FROM table_name; SELECT DISTINCT Examples The following SQL statement selects […]
Does asp.net webforms? Asp.net MVC?
Does asp.net webforms? Asp.net MVC? webforms, html pages and objects are sent through the process. A lot of webforms continue to be used in the platform. Webforms should be preferred […]
What is MVC? What is Asp.net MVC?
What is MVC? MVC operation logic For example; If we assume the address www.canerdogan.net.tr, the request comes from the Controller. The controller looks at the incoming request and uses the […]
Personnel performance evaluation
Personnel performance evaluation Hello, There is no more in this context, a project made in Turkey. performance evaluation. The project I have done, There are more modules than these. A […]
c # horse racing game application
Hello , This week I share with you the horse racing game written in C #. With this application it will be a good application example with random value throw, […]
Human Resources Assessment Ongoing project
Human Resources Assessment Ongoing project The project I work with is coded in PHP and MySQL.; There is no project in Turkey in this context. There is a similar project […]