WHAT IS STRUCTURED QUERY LANGUAGE

20
441
views
STRUCTURED QUERY LANGUAGE

Database plays an important and crucial role. The most important 4GL capability of RDBMS is STRUCTURED QUERY LANGUAGE (SQL).

FEATURES OF STRUCTURED QUERY LANGUAGE  (SQL)
  1. Recovery and Concurrency.
  2. Security.
  3. Integrity Constraints.
CLASSIFICATION OF SQL STATEMENTS

SQL Database is differentiating into three sub-languages.

1. DATA DEFINITION LANGUAGE (DDL)

It is used to define the data structure in the database. It contains the necessary statements for creating, manipulating, altering and deleting the tables.

2.  DATA MANIPULATION LANGUAGE (DML)

DML uses to manipulate the database. It contains statements and updates, deletes, insert, select data stored of data in the database.

3. DATA CONTROL LANGUAGE (DCL)

It is used for controlling data stored in the database. It contains statements to give permission, control transaction of data in the database.

RULES FOR SQL COMMANDS
  • SQL statements are not case-sensitive.
  • SQL statements can be in one or more files.
  • Keywords cannot be abbreviated.
  • Only one statement can be current at any time within the buffer and it can be run in the continuous line by placing a semicolon (;) at the end clause.
EXECUTING STRUCTURED QUERY LANGUAGE STATEMENTS
  • 1Place a semicolon at the end of the last clause.
  • 2Place a slash on the last line of the buffer.
  • 3Place a slash at the SQL prompt.
  • Issue a SQL * Plus RUN command at the SQL prompt.
PROPERTIES OF A TABLE
  • The table creates at any time.
  • There is no need to specify the size of the table.
  • The table structure modifies any time.
  • Tables may acquire more space automatically. If the initial size is fill up.
    RULES TO NAME A TABLE
  • The name must begin with a letter A-Z or a-z.
  • You can use either upper case or lower case letters both are same.
  • The length of table name is up to 30 characters.
  • The name is not a SQL pre-reserve word.

 

20 COMMENTS

  1. Hey there! I know this is kind of off-topic but I had to ask. Does managing a well-established website such as yours take a large amount of work? I’m completely new to operating a blog but I do write in my journal every day. I’d like to start a blog so I can easily share my experience and views online. Please let me know if you have any ideas or tips for new aspiring blog owners. Thankyou!

  2. Its like you read my mind! You seem to grasp a lot approximately this, like you wrote the book in it or something. I feel that you simply can do with a few p.c. to drive the message house a little bit, but other than that, that is wonderful blog. An excellent read. I’ll certainly be back.

  3. I wish to express my gratitude for your kindness in support of persons that really need help with this important concern. Your personal commitment to getting the solution all-around has been surprisingly insightful and has continually permitted people much like me to realize their objectives. The warm and helpful hints and tips entails much a person like me and extremely more to my mates. Thanks a lot; from all of us.

  4. Wow that was unusual. I just wrote an incredibly long comment but after I clicked submit my comment didn’t show up. Grrrr… well I’m not writing all that over again. Regardless, just wanted to say wonderful blog!

  5. Let me know if you’re looking for a author for your site. You have some really great posts and I think I would be a good asset. If you ever want to take some of the load off, I’d love to write some content for your blog in exchange for a link back to mine. Please shoot me an e-mail if interested. Thanks!

  6. What’s Happening i’m new to this, I stumbled upon this I have found It positively useful and it has helped me out loads. I hope to contribute & assist other users like its aided me. Great job.

  7. Hello there! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done a extraordinary job!

  8. I’m really intrigued to know what site system you have been utilizing? I’m having a few slight protection challenges with the latest blog related to medical lawsuit lawyers and I would like to find one thing more safe. Have you got any suggestions?

  9. Thank you for sharing this info, I bookmarked this page. I’m furthermore in need of material around omega xl complaints, do you know where I could discover a thing such as this? I’ll be back very soon!

  10. Nice weblog right here! Also your site a lot up very fast! What host are you the use of? Can I am getting your affiliate hyperlink in your host? I desire my site loaded up as quickly as yours lol

LEAVE A REPLY

Please enter your comment!
Please enter your name here