Home / Uncategories / Constitution of India and Polity

Constitution of India and Polity

Edit


Constitution of India and Polity



The present constitution of India was framed by the Constitution Assembly of India setup under Cabinet Mission Plan of May 16, 1946.

Composition of Constituent Assembly:-
  • The Constituent Assembly consisted of 385 members, of which 292 were elected by he elected members of the Provincial Legislative Assemblies while 93 members were nominated by the Princely States. To these were to be added a representative each from the four Chief Commissioners Provinces of Delhi, Ajmer-Marwar, Coorg and British Baluchistan.
  • Each Province and each Indian State or group of States were allotted the total number of seas proportional to their respective population roughly in the ration of one to a million.
  • B N Rao was appointed the Constitutional Advisor of the Assembly.
  • The first meeting of the Constituent Assembly took place of Dec 9, 1946 with Dr. Sachidanand Sinha as its interim President. Dr. Rajendra Prasad was elected as its President n Dec 11, 1947.
  • The Assembly framing the Constitution.had 13 Committees.
  • The all-important Drafting Committee, which bore the responsibility of drafting the Constitutional document during the recess of the Constitutent Assembly, from July 1947 to September 1948, was formed on August 29, 1947. Its members were:
                 1.Dr. B.R. Ambedkar
                     2.N. Gopalaswami Ayyar
                       3.K.M. Munshi
                         4.Syyed Mohd. Saadulla
                           5.N.Madhav Rao
                             6.D.P.Khaitan (T Krishnamachari, after Kahitan’s Death in 1948)
            • It was finally passed and accepted on Nov 26, 1949. The session of the Assembly was held on Jan 24, 1950, which unanimously elected Dr, Rajendra Prasad as the President of India. In all the 284 members of the Assembly signed the official copies of the Indian Constitution which came into effect on Jan 26, 1950, known and celebrated as the Republic Day of India.
            Share on Google Plus

            About Mindsforest

              Blogger Comment
              Facebook Comment

            1 comments:

            1. Unknown15 June 2018 at 04:57

              Hi Bru,


              This is indeed great! But I think perhaps you are generally referring Constitution of India and Polity which is getting unsustainable.


              I need to check various columns of a particular table to see if they are not really being populated or the data is always the same. So that we can perhaps remove some columns going forward. This table will be filtered by std_job_no column as i have a list of values for this column which pertain to a particular area of the data.

              To retrieve the column names for the table i have written this which produces the correct results.. note i do not require std_job_no column as i will be using this later as part of the group by query.

              SELECT DISTINCT TABLE_NAME, COLUMN_NAME FROM ALL_TAB_COLUMNS
              WHERE OWNER ='ELLIPSE'
              AND TABLE_NAME='MSF690'
              AND COLUMN_NAME<>'STD_JOB_NO'
              ORDER BY TABLE_NAME

              Now i want to loop through these column names and substitute column_name into the following query

              select
              COL,UMN_NAME, COUNT(STD_JOB_NO)
              from msf690
              where std_job_no in (
              '009045', '009053', '009188', '009189', '009190', '009236', '009275', '009310', '009319', '009320', '009321', '009322', '009323', '009324', '009325', '009326', '009327', '009328', '009419', '009459', '009460', '009461', '009462', '009463', '009464', '009582', '009590', '009591', '009594', '009616', '009617', '009618', '009619', '009620', '009621', '009622', '009623', '009624'
              )
              and dstrct_code='RTK1'
              GROUP BY COLUMN_NAME

              So i would then get the list of all values for each column name and how often they are populated.

              It should be something along the lines of..

              DECLARE

              BEGIN
              FOR RRR IN (

              SELECT DISTINCT TABLE_NAME, COLUMN_NAME FROM ALL_TAB_COLUMNS
              WHERE OWNER ='ELLIPSE'
              AND TABLE_NAME='MSF690'
              AND COLUMN_NAME<>'STD_JOB_NO'
              ORDER BY TABLE_NAME
              )
              LOOP
              EXECUTE IMMEDIATE 'select ' ||
              RRR.COLUMN_NAME || ', COUNT(STD_JOB_NO)
              from msf690
              where std_job_no in (
              '009045', '009053', '009188', '009189', '009190', '009236', '009275', '009310', '009319', '009320', '009321', '009322', '009323', '009324', '009325', '009326', '009327', '009328', '009419', '009459', '009460', '009461', '009462', '009463', '009464', '009582', '009590', '009591', '009594', '009616', '009617', '009618', '009619', '009620', '009621', '009622', '009623', '009624'
              )
              and dstrct_code='RTK1'
              GROUP BY RRR.COLUMN_NAME'

              and then i want to dbms_output this without inserting the values into a table as I don't have permissions to create tables.








              Great effort, I wish I saw it earlier. Would have saved my day :)


              ,Merci
              Radhey

              ReplyDelete

            Subscribe to: Post Comments ( Atom )