ROWNUM sql Fonksiyonu

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,


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 […]

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 webforms? MVC?

Does webforms? 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 MVC?

What is MVC? MVC operation logic For example; If we assume the address, 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 […]