#include<stdio.h>
#include<stdlib.h>
#include<string.h>
#define MEM(m) memset( m.arr,0x00,sizeof(m.arr));m.len=0
#define LE1(X) (X.len=strlen((char*)X.arr))
#define NU1(X) (X.arr[X.len]='\0')
#define MEM1(m) memset(m,0x00,sizeof(m))
#define SQLERROR sqlca.sqlcode<0
#define FAILURE -1
#define SUCCESS 1
#define NODATAFOUND     ( sqlca.sqlerrd[2] == 0 )
int SqlConnect(int);

EXEC SQL INCLUDE sqlca;
EXEC SQL BEGIN DECLARE SECTION;
varchar User_Name[100];
varchar User_Pass[100];
VARCHAR v_emp_name[20];
VARCHAR v_emp_id[20];
EXEC SQL END DECLARE SECTION;

main()
{
char clr_user[100];
char clr_pass[100];

memset(clr_user,0x00,sizeof(clr_user));
memset(clr_pass,0x00,sizeof(clr_pass));
strncpy((char*)User_Name.arr,clr_user,strlen(clr_user));
strncpy((char*)User_Pass.arr,clr_pass,strlen(clr_pass));
LE1(User_Name);
NU1(User_Name);
LE1(User_Pass);
NU1(User_Pass);
MEM1(v_emp_name);
LE1(v_emp_name);
NU1(v_emp_name);
MEM1(emp_id);
LE1(emp_id);
NU1(emp_id);
int emp_id ;
char emp_name [20];
int SqlConnect(int)
EXEC SQL CONNECT :User_Name IDENTIFIED BY :User_Pass;
if(SQLERROR)
{
sprintf("\nConnection Failed");
exit(0);
}
else
{
sprintf("\nConnection established");
}
return0;
 SQL create table betamonks(emp_name VARCHAR[20], emp_id number);
EXEC SQL INSERT INTO betamonks values(':v_emp_name','v_emp_id');
sprintf("emp_name:%s, emp_id:%s \n",emp_name.arr,emp_id.arr);
EXEC SQL COMMIT;
}

C Language online compiler

Write, Run & Share C Language code online using OneCompiler's C online compiler for free. It's one of the robust, feature-rich online compilers for C language, running the latest C version which is C18. Getting started with the OneCompiler's C editor is really simple and pretty fast. The editor shows sample boilerplate code when you choose language as 'C' and start coding!

Read inputs from stdin

OneCompiler's C online editor supports stdin and users can give inputs to programs using the STDIN textbox under the I/O tab. Following is a sample C program which takes name as input and print your name with hello.

#include <stdio.h>
int main()
{
    char name[50];
    printf("Enter name:");
    scanf("%s", name);
    printf("Hello %s \n" , name );
    return 0;
    
}

About C

C language is one of the most popular general-purpose programming language developed by Dennis Ritchie at Bell laboratories for UNIX operating system. The initial release of C Language was in the year 1972. Most of the desktop operating systems are written in C Language.

Key features:

  • Structured Programming
  • Popular system programming language
  • UNIX, MySQL and Oracle are completely written in C.
  • Supports variety of platforms
  • Efficient and also handle low-level activities.
  • As fast as assembly language and hence used as system development language.

Syntax help

Loops

1. If-Else:

When ever you want to perform a set of operations based on a condition if-else is used.

if(conditional-expression) {
   // code
} else {
   // code
}

You can also use if-else for nested Ifs and if-else-if ladder when multiple conditions are to be performed on a single variable.

2. Switch:

Switch is an alternative to if-else-if ladder.

switch(conditional-expression) {    
case value1:    
 // code    
 break;  // optional  
case value2:    
 // code    
 break;  // optional  
...    
    
default:     
 // code to be executed when all the above cases are not matched;    
}

3. For:

For loop is used to iterate a set of statements based on a condition.

for(Initialization; Condition; Increment/decrement){  
  // code  
}

4. While:

While is also used to iterate a set of statements based on a condition. Usually while is preferred when number of iterations are not known in advance.

while(condition) {  
 // code 
}

5. Do-While:

Do-while is also used to iterate a set of statements based on a condition. It is mostly used when you need to execute the statements atleast once.

do {
  // code 
} while (condition);

Arrays

Array is a collection of similar data which is stored in continuous memory addresses. Array values can be fetched using index. Index starts from 0 to size-1.

Syntax

One dimentional Array:

data-type array-name[size];

Two dimensional array:

data-type array-name[size][size];

Functions

Function is a sub-routine which contains set of statements. Usually functions are written when multiple calls are required to same set of statements which increases re-usuability and modularity.

Two types of functions are present in C

  1. Library Functions:

Library functions are the in-built functions which are declared in header files like printf(),scanf(),puts(),gets() etc.,

  1. User defined functions:

User defined functions are the ones which are written by the programmer based on the requirement.

How to declare a Function

return_type function_name(parameters);

How to call a Function

function_name (parameters)

How to define a Function

return_type function_name(parameters) {  
  //code
}